User Name

[Former Member]

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

[Former Member]

U can read the name from USR03 table.

OR

U can also use the FM SUSR_SHOW_USER_DETAILS

Message was edited by: Anurag Bankley

[andreas_mann3]

hi,

or join tables usr21 and ADRP

A.

[Former Member]

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...

[Laxmana_Appana_]

Hi,

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

Regards

Appana

[Former Member]

can u explain in detail

[Former Member]

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

[Former Member]

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

[Former Member]

you can findout all user related tables with USR*.

Regards

srikanth