topic Re: SAP table for Userid , First Name & Last Name in Application Development and Automation Discussions

SAP table for Userid , First Name & Last Name

manoj_goyal2 — Wed, 10 Jun 2009 01:16:24 GMT

Hi Guys,

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

Thanks,

mini

former_member156446 — Wed, 10 Jun 2009 01:22:50 GMT

did u check USR* tables?

GauthamV — Wed, 10 Jun 2009 04:33:57 GMT

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

USER_ADDR

Former Member — Wed, 10 Jun 2009 05:07:24 GMT

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

SujeetMishra — Wed, 10 Jun 2009 06:48:26 GMT

Hello,

Check table USR03.

Regards,

Sujeet

Former Member — Wed, 10 Jun 2009 10:07:12 GMT

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 — Wed, 11 Sep 2019 09:22:22 GMT

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

tursko — Mon, 14 Oct 2019 17:11:30 GMT

Thanks! Very useful.

Note: USER_ADDR is a DB view.

former_member833753 — Wed, 07 Dec 2022 09:26:22 GMT

This is helpful, thanks