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

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

USR03.

~Suresh

7 REPLIES 7
Read only

suresh_datti
Active Contributor
0 Likes
1,170

USR03.

~Suresh

Read only

Former Member
0 Likes
1,169

USR03

Message was edited by:

Chandrasekhar Jagarlamudi

Read only

Former Member
0 Likes
1,169

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

also use this FM

<b>RMSA191_GET_TXT_R3USER</b>

Read only

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

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

Hi,

Please try this FM SUSR_SHOW_USER_DETAILS.

Regards,

Ferry Lianto

Read only

Former Member
0 Likes
1,169

Pass userid to USR21.

Take PERSNUMBER and pass this to ADRP table.

You get NAME_FIRST, NAME_LAST

Thanks,

SKJ