topic Re: User Information in Application Development and Automation Discussions

User Information

Former Member — Mon, 17 Dec 2007 06:44:33 GMT

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.

Re: User Information

Former Member — Mon, 17 Dec 2007 06:47:45 GMT

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.

Re: User Information

uwe_schieferstein — Mon, 17 Dec 2007 07:07:22 GMT

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

Re: User Information

Former Member — Mon, 17 Dec 2007 07:07:41 GMT

Check with table.

USR03 User address data

Regards,

Maha

Re: User Information

Former Member — Mon, 17 Dec 2007 07:14:37 GMT

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

Re: User Information

Former Member — Mon, 17 Dec 2007 07:17:01 GMT

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.

Re: User Information

Former Member — Mon, 17 Dec 2007 07:27:30 GMT

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^