Get the SAP user ID which been deleted by email address

It’s common that we need to check the SAP ID for a specific user by her/his email address. And it’s well known that SAP user ID and accordingly email address stored at table ADR6 and USR21.

But what if the user ID been deleted afterward? There’ll be no entry existed for table ADR6 and USR21 at all. It’s easy to find out following the below steps:

1, Put the email address at ADR6-SMTP_ADDR to get the address number(ADDRNUMBER) and person number(PERSNUMBER) by SE11/SE16.

2. Using the address number and person number fetched from above, you can get the SAP user ID directly at table USR21 by field BNMAE of course if this user ID not been deleted yet.

3, If no result from above, then go to table ADR7 using the address number and person number to get the User ID by field UNAME. Done! It’ll be there even been deleted.

Besides: It’ll comes the question of when this user ID been deleted? It’s straight forward as well by the table USH04 by field PROFS.

       Field PROFS is an LCHR type, can’t be used as an input parameter. Just input the user ID for the field BNAME, and then check the result entry which PROFS is ‘D’ will get the deleted time stamp.

Or using the program RSUSR100 to check all change history using a specific user ID.

There is another way to check this may be quicker than this, just maybe:

• Guess the naming rule based on other email address and their SAP user ID in Table USR21.
• Then using Wildcard search like ‘L*F*’ based first name/last name in Table ADR7. Haha

Maybe Basis could have a better way to achieve this.