user-name first last name

[Former Member]

Hi expert,

I know the user name ( = sy-uname ) . How I can know the first name and last name for the user-name ?

in witch table is it stored ?

Tks,

bye

[Former Member · Accepted solution]

Hi,

You fetch the pernr from sy-uname from PA0105. By using pernr you can directly fetch the names using the below function module.

CATS_GET_EMPLOYEE_NAME

Thanks & Regards,

Ganesh R K

[Former Member · Accepted solution]

Hi Ganesh R K,

tks for reply,

it's run ok, but there's some user-name that not are employee... and for they, nor run .....

[Former Member · Accepted solution]

Hi Roberto,

Select * from pa0105 where subty eq 0001 and usrid eq sy-uname.

select ename from pa0000 where pernr eq pa0105-pernr and endda eq 31.12.9999

Regards,

Dilek

[Former Member · Accepted solution]

Hi Dilek,

tks for your reply.... it's not run ok completely... beaucose there some user-name that are not emplyee,

like external consultant... and in this case not run...

Any idea ??

tks,

bye.

[Former Member · Accepted solution]

Then use su01d , given the sy-user and then display . It will give you the first name and last name off sy-user .

[Former Member]

There are two option for this

1.check transaction su01d then give the userid , it will give you the first name and last name

2. check table pa0105 in the given the sy-user in id number field and execute

Hope this would help you.

[Former Member]

Hi,

You can get this from Transaction SU3

Regards,

Kapil

[Former Member]

Hi ,

First name is stored in PA0002-VORNA and last name is stored in PA0002-NACHN.

Thanks & Regards,

Ganesh R K

[Former Member]

Hi,

tks for reply, but in this table, there's not the link between user-name and matricule number...