topic Re: Table for User Name and User ID? in Application Development and Automation Discussions

Table for User Name and User ID?

Former Member — Wed, 09 May 2007 19:25:26 GMT

Hi Experts,

I hv User ID, that Logs in. So, I waanna to pull the corresponding Name.

So,

Wher Can I find these data i.e. Which is the best Table/source?

ThanQ.

Re: Table for User Name and User ID?

RichHeilman — Wed, 09 May 2007 19:28:40 GMT

Go to table USR21 and get the person number, then use that person number number to go to ADRP. There should be the name.

Regards,

Rich Heilman

Message was edited by:

Rich Heilman

Re: Table for User Name and User ID?

ferry_lianto — Wed, 09 May 2007 19:29:17 GMT

Hi,

Please check table USR03.

Regards,

Ferry Lianto

Re: Table for User Name and User ID?

RichHeilman — Wed, 09 May 2007 19:32:35 GMT

Oh, view V_USR_NAME is a view over the USR21 and ADRP tables. Cool.

Regards,

Rich Heilman

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 19:38:00 GMT

Yo ucan alternatively use SUSR_USER_ADDRESS_READ.

The exporting parameter user_address would have the full name of the user in the field name_text.

    DATA: user_address LIKE  addr3_val.
    CALL FUNCTION 'SUSR_USER_ADDRESS_READ'
      EXPORTING
        user_name                    = sy-uname
*       READ_DB_DIRECTLY             = ' '
      IMPORTING
        user_address                 = user_address
*       USER_USR03                   =
      EXCEPTIONS
        user_address_not_found       = 1
        OTHERS                       = 2.

    IF sy-subrc = 0.
       write:/ user_address-name_text.
    ENDIF.

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 20:09:29 GMT

Pass User ID in BNAME to USR21 table and you get PERSNUMBER.

Pass PERSNUMBER to ADRP table and you get First and Last Name

Thanks,

SKJ

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 21:30:14 GMT

1- can i use this (or any views) in SQL statements?

1- can i use this (or any views) in data declaration like name_first type v_usr_name-name_first?

thaq.

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 21:31:37 GMT

1- can i use this (or any views) in SQL statements?

2- can i use this (or any views) in data declaration like name_first type v_usr_name-name_first?

thaq.

Re: Table for User Name and User ID?

RichHeilman — Wed, 09 May 2007 21:34:51 GMT

YEs, and Yes

Regards,

RIch Heilman

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 21:35:47 GMT

Yes u can use views in the select statements and would works like the normal data base tables.

Shreekant

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 21:47:50 GMT

data wa_usr like v_usr_name.

select single * from v_usr_name into wa_usr

where bname = ''.

Thanks

Seshu

Re: Table for User Name and User ID?

Former Member — Wed, 09 May 2007 23:02:15 GMT

ThanQ.

Re: Table for User Name and User ID?

Former Member — Thu, 10 May 2007 13:49:36 GMT

Hi Rich,

If u hv any idea, then Pls. respond to my thread with title, <i><b>NT Log in IDs & Names</b></i>

Its like,

Where can I find the Names for NT Log in IDs? I mean, What table I hv to look for to grab the Name value for a given NT Log in ID?

ThanQ.

Message was edited by:

Sridhar

Re: Table for User Name and User ID?

Former Member — Thu, 21 Jun 2007 12:54:35 GMT

Hi experts

i have a problem

i have a role EMP in R/3, having default field employee data with personnel number , in BP it is accepting , but in table it is not showing the data ,

i have a role MKK in R/3 , i added the same field BUCP10 to BP , this field also not showing any data in table BUT000,

what is the reason please help me

Re: Table for User Name and User ID?

Former Member — Thu, 17 Jan 2008 22:19:30 GMT

USR21 Personnel number does not match HR Personnel number.

Re: Table for User Name and User ID?

Former Member — Tue, 07 Sep 2010 00:56:31 GMT

parameters namee type usr02-bname.

types: begin of usrz,

name_first type adrp-name_first,

name_last type adrp-name_last,

name_text type adrp-name_text ,

bname type usr21-bname,

end of usrz.

data ln_usrz type usrz.

select single

adrp~name_first

adrp~name_last

adrp~name_text

usr21~bname

into ln_usrz

from adrp

inner join usr21 on adrp_{persnumber = usr21}persnumber

where usr21~bname = namee.

write:

ln_usrz-name_first,

ln_usrz-name_last,

ln_usrz-name_text,

ln_usrz-bname.

Re: Table for User Name and User ID?

Former Member — Tue, 05 Aug 2014 09:20:01 GMT

Go to SU10 or SUIM, Authorization data -> execute after giving user id

Re: Table for User Name and User ID?

former_member239673 — Wed, 12 Nov 2014 20:42:47 GMT

You Can use USER_ADDR table

Regards

Re: Table for User Name and User ID?

Former Member — Fri, 06 Feb 2015 05:22:03 GMT

This message was moderated.

Re: Table for User Name and User ID?

former_member1337968 — Wed, 26 Jul 2023 13:59:14 GMT

This is the best answer.