We store user email addresses within the SAP SU01 user master record. Where is this information located? I would like to be able to extract certain pieces of data, such as an AGR_Users table.
This data is stored in SAP address tables in the SU01 user master record that use address numbers and person numbers as keys. Yet another table must be consulted for the relationship between the user ID and the person number. If you are doing this programmatically, you should use SAP standard BAP BAPI_USER_GET_DETAIL to read this information.
Dig Deeper on SAP security
Related Q&A from Corwin Slack
A SearchSAP.com reader wants to know how to grant a user access to cost centers, as well as access to one cost element across all cost centers. Continue Reading
Learn how to stop SAP users from displaying HR table contents in an SAP table without restricting access to an SE16N transaction. Continue Reading
Discover tips for mapping SAP roles and profiles, including how to map multiple SAP profiles to a single derived role, and why a second profile is ... Continue Reading