Derive User Name (BNAME) using PERNR

[Former Member]

Hi,

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

Can anyone suggest me the appriopriate tables please?

Thanks..

Regards,

R Adarsh

[Former Member]

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

[naveen_inuganti2]

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

[Former Member]

Hi,

You can try tables PA0001 or PA0002.

Regards,

Samson Rodrigues.

[bpawanchand]

Hi

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

[Former Member]

hi adarsh r

goto Infotype PA0002

Regards

Deva

[Subhankar]

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