topic Re: User Name in Application Development and Automation Discussions

User Name

Former Member — Wed, 23 Aug 2006 09:34:34 GMT

In our company we use Single Sign On i.e, SSO ID for logon (it is 10 digit number used for logging to system)...

Now i want to find out the USer name for particular SSO ID enter in the report ...

Can anyone findout the FM for that..it should be like...when i enter the SSO ID as input the o/p to be given as the user name..

Thanks in advance

Re: User Name

Former Member — Wed, 23 Aug 2006 09:37:42 GMT

U can read the name from USR03 table.

U can also use the FM SUSR_SHOW_USER_DETAILS

Message was edited by: Anurag Bankley

Re: User Name

Former Member — Wed, 23 Aug 2006 09:41:28 GMT

you can findout all user related tables with USR*.

Regards

srikanth

Re: User Name

andreas_mann3 — Wed, 23 Aug 2006 09:41:39 GMT

hi,

or join tables usr21 and ADRP

Re: User Name

Former Member — Wed, 23 Aug 2006 11:02:58 GMT

Actually my problem is..

my field is EKPO-AFNAM..i want to link this field to NAME1 and NAME2..how to do this..

If i enter my number i.e, AFNAM value it should give me NAME1 AND NAME2...

Re: User Name

Laxmana_Appana_ — Wed, 23 Aug 2006 11:11:10 GMT

Hi,

From the database view : <b>USER_ADDRS</b> and select field <b>'NAME_TEXT'</b>, you will get complete user name.

Regards

Appana

Re: User Name

Former Member — Wed, 23 Aug 2006 11:48:46 GMT

can u explain in detail

Re: User Name

Former Member — Wed, 23 Aug 2006 12:07:43 GMT

you can use the below to fetch the required.

SELECT name1 name2 into lname1 lname2

from usr03

where bname = ekpo-afnam.

--> Here the variable lname1 and lname2 would have the details.

Regards

Anurag

Re: User Name

Former Member — Wed, 23 Aug 2006 12:10:10 GMT

Hi,

even i use the same concept of SSO,

u can find in view USER_ADDR , fieldname NAME_TEXTC

or u can find the NAME1 and NAME2 in ADRC table