Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
arghadipkar3013
Contributor
48,304
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

https://youtu.be/f02EqSbfeXM

 
5 Comments
Labels in this area