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
946

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
869

USR03.

~Suresh

7 REPLIES 7
Read only

suresh_datti
Active Contributor
0 Likes
870

USR03.

~Suresh

Read only

Former Member
0 Likes
869

USR03

Message was edited by:

Chandrasekhar Jagarlamudi

Read only

Former Member
0 Likes
869

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
869

also use this FM

<b>RMSA191_GET_TXT_R3USER</b>

Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
869

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
869

Hi,

Please try this FM SUSR_SHOW_USER_DETAILS.

Regards,

Ferry Lianto

Read only

Former Member
0 Likes
869

Pass userid to USR21.

Take PERSNUMBER and pass this to ADRP table.

You get NAME_FIRST, NAME_LAST

Thanks,

SKJ