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,242

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,165

USR03.

~Suresh

7 REPLIES 7
Read only

suresh_datti
Active Contributor
0 Likes
1,166

USR03.

~Suresh

Read only

Former Member
0 Likes
1,165

USR03

Message was edited by:

Chandrasekhar Jagarlamudi

Read only

Former Member
0 Likes
1,165

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,165

also use this FM

<b>RMSA191_GET_TXT_R3USER</b>

Read only

RichHeilman
Product and Topic Expert
Product and Topic Expert
0 Likes
1,165

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,165

Hi,

Please try this FM SUSR_SHOW_USER_DETAILS.

Regards,

Ferry Lianto

Read only

Former Member
0 Likes
1,165

Pass userid to USR21.

Take PERSNUMBER and pass this to ADRP table.

You get NAME_FIRST, NAME_LAST

Thanks,

SKJ