topic Re: User Name in Application Development and Automation Discussions

User Name

Former Member — Sat, 19 May 2007 09:47:49 GMT

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 — Sat, 19 May 2007 09:53:10 GMT

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

reward points if helpful.

Regards,

Atish

Former Member — Sat, 19 May 2007 09:54:52 GMT

usr02-table.

Regards

Peram

Former Member — Sat, 19 May 2007 10:02:21 GMT

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 — Sun, 20 May 2007 11:20:17 GMT

Hi,

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

Regards,

Ramu N.

Former Member — Sun, 20 May 2007 11:30:36 GMT

Hi Ishaq,

The table USR01 and USR02 holds the user information.

U can also the Tcode SU01D to get the detailed information of a particular user.

Former Member — Sun, 20 May 2007 12:35:04 GMT

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