topic Re: standard table for all users in Application Development and Automation Discussions

standard table for all users

Former Member — Mon, 12 Dec 2005 07:00:48 GMT

Hi,

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

Plz give me information on this.

Thanks,

Ravindra.

Re: standard table for all users

Former Member — Mon, 12 Dec 2005 07:03:11 GMT

table USR01,

Re: standard table for all users

Former Member — Mon, 12 Dec 2005 07:05:02 GMT

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

Re: standard table for all users

abdul_hakim — Mon, 12 Dec 2005 07:07:14 GMT

Use USR01.

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

REgards,

ABdul

Re: standard table for all users

Former Member — Mon, 12 Dec 2005 07:10:09 GMT

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

Re: standard table for all users

Former Member — Mon, 12 Dec 2005 07:15:33 GMT

try using USR01!!

Re: standard table for all users

andreas_mann3 — Mon, 12 Dec 2005 07:20:44 GMT

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