topic Re: table for userid and person name in Application Development and Automation Discussions

table for userid and person name

Former Member — Sun, 04 Feb 2024 01:39:27 GMT

Hi,

I want a table in which I can find two fields user id and person name.

can any body plz help me in this??

Thanks,

Satish.

Former Member — Tue, 13 Dec 2005 05:23:39 GMT

Hi Satish,

USR03 will have userid and username

Former Member — Tue, 13 Dec 2005 05:37:11 GMT

use these table for infos about user

<b>USR01 User master record (runtime data)

USR02 Logon Data (Kernel-Side Use)

USR03 User address data

USR04 User master authorizations

USR05 User Master Parameter ID

USR06 Additional Data per User </b>

Former Member — Tue, 13 Dec 2005 05:38:08 GMT

I think that table is USR21 & ADRP.

you can get the followings.

1) system variable SY-UNAME is sap's user id.

2) SELECT persnumber from USR21 WHERE bname = sy-uname.

3) SELECT name_first,name_middle,name_last,name_text from ADRP where persnumber = usr21-persnumber.

Good Luck..

Former Member — Tue, 13 Dec 2005 05:54:00 GMT

use the following

USR01 User master record (runtime data)

USR02 Logon Data (Kernel-Side Use)

USR03 User address data

USR04 User master authorizations

USR05 User Master Parameter ID

USR06 Additional Data per User

and USR21 and adrp!!

plz reward points if it helped and close the thread!!

Regards,

Gunjan