standard table for all users

[Former Member]

Hi,

Is there any standard table where I can find only sap id and user names??

Plz give me information on this.

Thanks,

Ravindra.

[Former Member]

Hi

tables starting with nameUSR will give info about sap id and user name

usr01 - User master record (runtime data)

usr02- Logon Data (Kernel-Side Use)

usr03- user address data

and soon..

go to se11 type usr* in table name area and press F4

[Former Member]

table USR01,

[Former Member]

try using USR01!!

[Former Member]

Hi,

You can use FM 'HR_GET_EMPLOYEE_DATA' to get the above fields by passing PERNR and OBJID = 'P'.

Or use tables....

(PERNR) LIKE PA0000-PERNR "personnel number

(AKANAME) LIKE PA0002-RUFNM "name

(USRID) LIKE PA0105-USRID "user ID

Thanks.

If this helps you reward with points.

Message was edited by: Deepak333 k

[abdul_hakim]

Hi

Use USR01.

For other user details use USR02,03,04,05...etc...

REgards,

ABdul

[Former Member]

Hi

tables starting with nameUSR will give info about sap id and user name

usr01 - User master record (runtime data)

usr02- Logon Data (Kernel-Side Use)

usr03- user address data

and soon..

go to se11 type usr* in table name area and press F4

[andreas_mann3]

Hi,

try that:

  SELECT U~BNAME A~NAME_FIRST A~NAME_LAST
                         INTO  table USRTAB
               FROM  ( USR21 AS U INNER JOIN ADRP AS A
                         ON U~MANDT = A~CLIENT
                       AND  U~PERSNUMBER = A~PERSNUMBER )
        WHERE U~BNAME in ...

Andreas