cancel
Showing results for 
Search instead for 
Did you mean: 

what is the standard table name which contain ID and Name(text)?

Former Member
0 Kudos

Hi

I just curious about table name which have SAP user ID and Name.

could anyone can tell me the name or how to find this?

thank you

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

The database view: USER_ADDR, has all the info you need.

Just pass in the userId to the field Bname and get the first name, last name, etc...

Regards

Subramanian

Former Member
0 Kudos

Thank you

you fully solved my curious

that was what I looking for.

Answers (1)

Answers (1)

Former Member
0 Kudos

USR02 - User master records

Former Member
0 Kudos

thank you but there is no text of user name in USR02 .

I think I should join some other tables with BNAME filed.

do you have any idea that table has user name?

former_member185954
Active Contributor
0 Kudos

Hi,

Check the following tables:

USR02 - Logon data of the user

USR03 - Obsolete. Former address data of the users (prior to Release 4.0)

USR21 - Assignment of user name – address key (address and person number) (as of Release 4.0)

USCOMPANY - User company with address (as of Release 4.5)

SOUD - SAPoffice – user definition

Regards,

Siddhesh