Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

User Table

Former Member

‎2009 Mar 16 6:55 PM

0 Likes
1,179

What is the tables that contains SAP user name and real name?

Thanks

Join USR21 table with ADRP table based on person number to get

both SAP user name and real name.

Reply
8 REPLIES 8
Read only

Former Member

‎2009 Mar 16 6:59 PM

0 Likes
1,137

you can try USR03

Read only

Former Member
In response to Former Member

‎2009 Mar 16 7:00 PM

0 Likes
1,137

you can go to SE16N and search for USR* to see all these tables.

Read only

Former Member
In response to Former Member

‎2009 Apr 29 6:45 AM

0 Likes
1,137

hy

i wnt to know about hw many user license in system where stored information in sim file.

thnks

bhavesh

Read only

former_member376453
Contributor

‎2009 Mar 16 7:12 PM

0 Likes
1,137

There is one database view USER_ADDR, from where you can directly get the user id as well as user name.

Kuntal

Read only

Former Member

‎2009 Mar 17 3:05 AM

0 Likes
1,137

check USR02 table

Reg,

Sachin

Read only

GauthamV
Active Contributor

‎2009 Mar 17 4:28 AM

0 Likes
1,137

Join USR21 table with ADRP table based on person number to get

both SAP user name and real name.

Read only

Former Member

‎2009 Mar 17 5:05 AM

0 Likes
1,137

Hi,

Check with below tables

USR02

USR03

Regards,

Anki reddy

Read only

Former Member

‎2009 Mar 17 5:08 AM

0 Likes
1,137

Hi,

Check these two tables

USR02

USR21

Regards,

Jyothi CH.