2007 Apr 13 3:21 PM
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.
2007 Apr 13 3:21 PM
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
2007 Apr 13 3:21 PM
2007 Apr 13 3:22 PM
2007 Apr 13 3:23 PM
use either <b>USR01</b> or <b>USR02</b> or <b>USR03</b> table. Field is <b>BNAME</b>
2007 Apr 13 3:24 PM
2007 Apr 13 3:25 PM
2007 Apr 13 3:27 PM
Hi,
Please try this FM SUSR_SHOW_USER_DETAILS.
Regards,
Ferry Lianto
2007 Apr 13 3:27 PM
Pass userid to USR21.
Take PERSNUMBER and pass this to ADRP table.
You get NAME_FIRST, NAME_LAST
Thanks,
SKJ
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |