05-09-2007 8:25 PM
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.
05-09-2007 8:38 PM
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.
05-09-2007 8:28 PM
05-09-2007 8:32 PM
05-09-2007 10:30 PM
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.
05-09-2007 10:34 PM
05-09-2007 10:35 PM
Yes u can use views in the select statements and would works like the normal data base tables.
Shreekant
05-10-2007 12:02 AM
05-10-2007 2:49 PM
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
06-21-2007 1:54 PM
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
05-09-2007 8:29 PM
05-09-2007 8:38 PM
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.
05-09-2007 10:31 PM
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.
05-09-2007 10:47 PM
data wa_usr like v_usr_name.
select single * from v_usr_name into wa_usr
where bname = ''.
Thanks
Seshu
05-09-2007 9:09 PM
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
01-17-2008 10:19 PM
09-07-2010 1:56 AM
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 adrppersnumber = usr21persnumber
where usr21~bname = namee.
write:
ln_usrz-name_first,
ln_usrz-name_last,
ln_usrz-name_text,
ln_usrz-bname.
08-05-2014 10:20 AM
Go to SU10 or SUIM, Authorization data -> execute after giving user id
11-12-2014 8:42 PM
02-06-2015 5:22 AM
07-26-2023 2:59 PM