Skip to Content
Technical Articles
Author's profile photo arghadip kar

How to find email address of SAP User id the smart way?

Introduction

In most Projects you will work in SAP there will be a requirement to find the following

  1. Find SAP User id from Email address
  2. Find Email Address from SAP User id.
  3. Find Full name of a SAP User Id
  4. Find Full name of Email address

 

Solution

With the introduction of out of the box CDS View you can find all the email addresses from SAP User Id with just one Select Statement.

The CDS View is PUSER002.

Go to SE11–> Enter Table PUSER002

 

You can check the field available after Displaying the CDS View

Now we can find the Full Name of user as well as email address attached to SAP User Master. Currently the SAP Email address that is maintained in PA0105 table for SAP User ID in Communication Infotype seems to be same in User Master in SU01D transaction Code.

 

 

Conclusion

You can use this solution in SAP ECC as well as SAP S/4HANA.

You can also create a Search help for this as this will make life easier for SAP End user and Consultants.

 

Video Version Below

 

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Varun Sahu
      Varun Sahu

      Good one, very helpful as compared to using a FM or multiple select queries

      Author's profile photo sushree mishra
      sushree mishra

      Very helpful. Have been looking for this for days now. Thank you.

      Author's profile photo Bharath Padmanabhan
      Bharath Padmanabhan

      Uber cool post. Love it. Please keep posting cool tips like this. Thank you so much.

      I am going to replace my lengthy existing code to join multiple tables with this view.

      Goodbye to USR21, ADR6 Joins.... 

      Author's profile photo Bharath Padmanabhan
      Bharath Padmanabhan

      My first thought when I read the description of the blog - Everyone knows how to fetch this data. What more smart option is out there?

      Then I read your name and I have been following your Youtube tips and tricks for a long time.

      You always come up with a cooler approach and I clicked the blog right away.

      You did it again 🙂 ...

      Author's profile photo Kalateh Janosch
      Kalateh Janosch

      Hey, just wanted to let you know that this only works in programs which are executed in user context if the user has the appropriate authorizations which most users will not be granted.

      You can use this for jobs etc. but most likely not in transactions that users will use.