find user-id

[former_member184495]

hi,

my requirement is i have a personnel number of an employee in P0000 ,

i need to identify the SAP user-id for that PERNR,

how do i get that ?

cheers,

Aditya.

[former_member184495]

hi,

my requirement is i have a personnel number of an employee in P0000 ,

i need to identify the SAP user-id for that PERNR,

how do i get that ?

cheers,

Aditya.

[Former Member]

select uname into ws_uname

from PA0000

where pernr EQ given_Pernr.

should return the user name.

[Former Member]

Hi,

Check tables USR01, USR02,

or see USR* in Se11,

here guve the personel No you will get the SAP User ID

Regards

Sudheer

[Former Member]

hi,

Check table PA0105

Field names

USRTY - 0001

USRID - User-id for PERNR

Regards

-

---

Sachin

[former_member184495]

answered