User Information

[Former Member]

Hi,

I have one query regarding user id. My requirement is like that If I enter SAP login id then I wanted to know the user name of that id (SAP login Id).

Any body will suggest me in which table the above mentioned information gets stored.

[Former Member]

Hi,

Check

USR01 -- User master record (runtime data)

USR02 -- Logon data

USR04 -- User master authorizations

or check all USR* tables in SE11

Also you can check the stats with RSSTAT20 or RSSTAT26.

Check this link if it helps

http://help.sap.com/saphelp_nw04s/helpdata/en/1e/478f40f3b19920e10000000a1550b0/content.htm

try transaction RSUSR200

Regards,

Omkar.

[uwe_schieferstein]

Hello Neha

If you need a function access to this information use BAPI_USER_GET_DETAIL. The requested information can be found in EXPORTING parameter ADDRESS.

Regards,

Uwe

[Former Member]

Check with table.

USR03 User address data

Regards,

Maha

[Former Member]

hi,

below is the code

SELECT persnumber

INTO w_persnumber UP TO 1 ROWS

FROM usr21 WHERE bname EQ sy-uname.

ENDSELECT.

if SY-SUBRC EQ 0.

select NAME_FIRST NAME_LAST

into w_name

where PERSNUMBER EQ w_persnumber

up to 1 rows

endselect

endif.

hope that helps

[Former Member]

sorry i missed out table names

SELECT persnumber

INTO w_persnumber UP TO 1 ROWS

from USR21

FROM usr21 WHERE bname EQ sy-uname.

ENDSELECT.

if SY-SUBRC EQ 0.

select NAME_FIRST NAME_LAST

into w_name

from ADRP

where PERSNUMBER EQ w_persnumber

up to 1 rows

endselect

endif.

[Former Member]

hi

good

if you have successfully enter the login id and password than you can use the usr01 table to know the rest details of that particular user.

thanks

mrutyun^