table for userid and person name

[Former Member]

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_member188685]

Hi Satish,

USR03 will have userid and username

[Former Member]

HI

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]

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]

hi

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