In a straightforward case, you can obtain the user’s email address from the transaction code SU01. The email will be listed in the E-Mail Address field.
But, in some cases, you might want to know – which E-Mail address is been assigned or tagged to an ID. This is something useful if you came across troubleshooting with the single sign-on issue. The single sign-on would possibly be failing if the E-Mail is assigned to multiple users.
By the way, the steps we used here is not really that “intelligent” but, somehow it could give you some ideas and better inputs to troubleshoot further.
Now, open transaction code SE16N. Enter the table name as ADR6. Look for SMTP_ADDR and enter the E-Mail address. Press on Execute.
In the below example, it seems that the E-Mail address is maintained to 2 IDs. You can capture the IDs from the Person Number.
In transaction code SE16N, enter the new table USR21. Paste the Person Number value and click on Execute.
The result will tell you the username of the E-Mail address.
