SAP table for Userid , First Name & Last Name

[manoj_goyal2]

Hi Guys,

Can somebody tell me the SAP table which has logon Userid, First name & Last Name.

Thanks,

mini

[former_member156446]

did u check USR* tables?

[GauthamV]

Use this View which is a combination of USR21,ADRC,ADRP tables.

USER_ADDR

[tursko]

Thanks! Very useful.

Note: USER_ADDR is a DB view.

[former_member833753]

This is helpful, thanks

[Former Member]

Hi,

Goto USR21 table pass your SAP login name. You will get the PERSONNUM pass this number to ADRP table, you will get the First Name and Last Name.

Pass the Address Number to ADRC table, you will get the address details.

Hope this mabe be useful..

Regards,

Prashant

[sujeet2918]

Hello,

Check table USR03.

Regards,

Sujeet

[Former Member]

Hi,

check "USER_ADDRP" table , here BNAME is userid ,name_first is firstname and name_last is lastname.

hope it'll help.

Regards,

Sneha.

[former_member39024]

You can find First name, last name and Email address of users from SU10 -> Address tab