topic Re: User Master Record ?? in Application Development and Automation Discussions

User Master Record ??

Former Member — Tue, 04 Apr 2006 18:54:19 GMT

Dear All,

Can anybody let me know, what is User master Record table.

Actually I have printed a EKKO-Ernam in PO Smartforms but we need to print

Users First Name, Last Name ..

Please help me in this regard.

Thanking you.

Venkat.

RichHeilman — Tue, 04 Apr 2006 18:58:25 GMT

USR01, USR01, USR03, etc.

Check any that start with USR*

In some cases, the names can be found in USR03

In my case, the names are stored in the address tables,

ADRC ADRP ADCP, which are linked to USR21 table. You can access this info from a view called USER_ADDR.

Regards,

Rich Heilman

Former Member — Tue, 04 Apr 2006 19:01:01 GMT

There is a database view - USER_ADDR - which contains most this info in one spot.

Just fill in BNAME = sy-uname.

Former Member — Tue, 04 Apr 2006 19:04:14 GMT

Hi,

Check the table USR03 table,

this is the Address data table.

Regards

Vijay

Former Member — Tue, 04 Apr 2006 21:19:26 GMT

Use SUSR_USER_ADDRESS_READ function module.

Former Member — Wed, 05 Apr 2006 00:21:02 GMT

Venkat,

Has your question been answered? If so, please reward points accordingly and close the thread.

Former Member — Wed, 05 Apr 2006 03:40:36 GMT

Venkat,

You can try this BAPI as well.

<b>BAPI_USER_GET_DETAIL</b>

Regards,

Ravi

Note : Please mark the helpful answers and close the thread