how to get userid from username

[Former Member]

Hi All,

How can I get userid from username?

Thanks,

Anup Garg

[former_member194669]

Check for database view USER_ADDR

a®

[Former Member]

get it from table : USR03

but U might get multiple records ...

[Former Member]

>

> get it from table : USR03
> but U might get multiple records ...

Table USR03 is obsolete. See SAP note 96607.

[former_member705122]

Hi,

USR01 User master record (runtime data)

USR02 Logon data

USR04 User master authorizations

check this link:

http://www.erpgenie.com/abap/tables_system.htm

Regards

Adil

[Former Member]

The other way - utilize tables USR21 / ADRP / ADR6.

[Former Member]

Hi Anup,

Userids are stored in Infotype PA0105 ( table ) and field USRID.

PERNR is the Employee Number.

To know the Employee name check Infotype PA0002 ( table ) and fields

NACHN	Last Name
NACH2	Second Name
VORNA	First Name
CNAME	Complete Name

Best regards,

raam

[Former Member]

Use BAPI. Get what ever you need for a user.

BAPI_USER_GET_DETAIL

Amandeep

[Former Member]

>

> Use BAPI. Get what ever you need for a user.
> 
> BAPI_USER_GET_DETAIL
> 
> Amandeep

Almost, but not quite in this case.

BAPI_USER_GETLIST is what you would be looking for.

[Former Member]

Hi,

1st Step -> query on the table ADRP. Provide First Name and/or Last Name and get the Person Number.

2nd Step -> query on the table USR21. Provide the Person Number and get your desired User ID.

<removed_by_moderator>

Regards,

Nadim

Edited by: Julius Bussche on Jul 8, 2008 4:41 PM

[Former Member]

>

> <removed_by_moderator>
> 
> Regards,
> Nadim
> 
> Edited by: Julius Bussche on Jul 8, 2008 4:41 PM

Please stop that and read the rules of engagement.

In future, points will be removed....

[Former Member]

done