topic Re: Derive User Name (BNAME) using PERNR in Application Development and Automation Discussions

Derive User Name (BNAME) using PERNR

Former Member — Wed, 27 Aug 2008 05:18:15 GMT

Hi,

I need to derive the User name (BNAME) using PERNR.

Can anyone suggest me the appriopriate tables please?

Thanks..

Regards,

R Adarsh

Re: Derive User Name (BNAME) using PERNR

naveen_inuganti2 — Wed, 27 Aug 2008 05:21:16 GMT

Hi.....

Check this program...

data: itab like pa0002 occurs 0 with header line.
parameters: p_name like pa0002-pernr.
select single vnamc nchmc from pa0002 into corresponding fields of itab where pernr = p_name.
data:text(30).
concatenate  itab-vnamc itab-nchmc into text separated by ' '.
write:/ text.

Thanks,

Naveen.I

Re: Derive User Name (BNAME) using PERNR

Former Member — Wed, 27 Aug 2008 05:21:17 GMT

Hi,

You can try tables PA0001 or PA0002.

Regards,

Samson Rodrigues.

Re: Derive User Name (BNAME) using PERNR

bpawanchand — Wed, 27 Aug 2008 05:23:15 GMT

SELECT
    usrid
    FROM pa0105
    INTO (w_USRNAME)
    UP TO 1 ROWS
    WHERE subty = '0001' AND
                  begda le sy-datum AND
                 endda ge sy-datum. 
ENDSELECT.

Try this out i think it will give you the Sap user login name

Regards

Pavan

Re: Derive User Name (BNAME) using PERNR

Former Member — Wed, 27 Aug 2008 05:23:29 GMT

hi adarsh r

goto Infotype PA0002

Regards

Deva

Re: Derive User Name (BNAME) using PERNR

Subhankar — Wed, 27 Aug 2008 05:52:36 GMT

Hi ...

get the user name (UNAME) from PA0002 using PERNR(Personnel number)

If want to get the full name please concatenate the value VNAMC and NCHMC..

I think it will work..

Edited by: Subhankar Garani on Aug 27, 2008 7:54 AM