User Name

[Former Member]

Hi,

Can anyone tell me from where do I pick the user name from.

I mean which table and which field contains the User Name.

Normally, the field with text User Name will contain the User ID such as SAPC_ABAP. I want the name not the ID.

Thanks in advance,

Ishaq.

[Former Member]

Table USR01, USR02 and so on contains the user data.

reward points if helpful.

Regards,

Atish

[Former Member]

usr02-table.

Regards

Peram

[Former Member]

Check this link:

First you would need to loook up person number (PERSNUMBER) via USER-ID in ADRP and then look for full name in USR21 via this person number.

So solution to your problem might look something like:

SELECT SINGLE adrp~name_text INTO name_text

FROM usr21 JOIN adrp ON usr21_{persnumber = adrp}persnumber AND

adrp~date_from = '00010101' AND

adrp~nation = ''

WHERE usr21~bname = usnam.

Where usnam ofcourse is USER-ID for which you want to find full name.

[Former Member]

Hi,

Use FM SWL_AGENTS_NAME_DETERMIN to get UserName by passing the User Id.

Regards,

Ramu N.

[Former Member]

Hi Ishaq,

The table <b>USR01</b> and <b>USR02</b> holds the user information.

U can also the Tcode <b>SU01D</b> to get the detailed information of a particular user.

[Former Member]

Use V_USR_NAME - this is database view and you will get the user id and user complete name..