topic USER NAME table in Application Development and Automation Discussions

USER NAME table

Former Member — Fri, 13 Apr 2007 14:21:00 GMT

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.

suresh_datti — Fri, 13 Apr 2007 14:21:48 GMT

USR03.

~Suresh

Former Member — Fri, 13 Apr 2007 14:22:31 GMT

USR03

Message was edited by:

Chandrasekhar Jagarlamudi

Former Member — Fri, 13 Apr 2007 14:23:29 GMT

use either USR01 or USR02 or USR03 table. Field is BNAME

Former Member — Fri, 13 Apr 2007 14:24:27 GMT

also use this FM

RMSA191_GET_TXT_R3USER

RichHeilman — Fri, 13 Apr 2007 14:25:42 GMT

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

Former Member — Fri, 13 Apr 2007 14:27:01 GMT

Hi,

Please try this FM SUSR_SHOW_USER_DETAILS.

Regards,

Ferry Lianto

Former Member — Fri, 13 Apr 2007 14:27:30 GMT

Pass userid to USR21.

Take PERSNUMBER and pass this to ADRP table.

You get NAME_FIRST, NAME_LAST

Thanks,

SKJ