Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

USER NAME table

Former Member
0 Likes
1,131

Hello Friends,

I have a user ID.

I need to find the last name and the first name of the person who created the order.

What are the table and the field for this?

Ster.

1 ACCEPTED SOLUTION
Read only

suresh_datti
Active Contributor
0 Likes
1,054

USR03.

~Suresh

USR03.

~Suresh

7 REPLIES 7
Read only

suresh_datti
Active Contributor
0 Likes
1,055

USR03.

~Suresh

Read only

Former Member
0 Likes
1,054

USR03

Message was edited by:

Chandrasekhar Jagarlamudi

Read only

Former Member
0 Likes
1,054

use either <b>USR01</b> or <b>USR02</b> or <b>USR03</b> table. Field is <b>BNAME</b>

Read only

Former Member
0 Likes
1,054

also use this FM

<b>RMSA191_GET_TXT_R3USER</b>

Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
1,054

These names may be stored in the address table. You can get to this table using the address number in USR21 and going to ADRC.

REgards,

RIch Heilman

Read only

Former Member
0 Likes
1,054

Hi,

Please try this FM SUSR_SHOW_USER_DETAILS.

Regards,

Ferry Lianto

Read only

Former Member
0 Likes
1,054

Pass userid to USR21.

Take PERSNUMBER and pass this to ADRP table.

You get NAME_FIRST, NAME_LAST

Thanks,

SKJ