topic Re: Table that stores User Master Data info in Application Development and Automation Discussions

Table that stores User Master Data info

GinaCiuca — Wed, 30 Jul 2008 06:28:48 GMT

Can someone tell me the table name that stores the email addresses and phone numbers maintained in user master record (SU01)? I need to generate a list of users with this info.

A quick answer will be very appreciated.

Re: Table that stores User Master Data info

Bernhard_SAP — Wed, 30 Jul 2008 06:37:56 GMT

Hi Gina,

Phonenumbers are in table ADR2, e-mail is in ADR6.

The relation user-ID/Adress-/Personalnumber can be found in table USR21.

A more convenient way to select those informations is by using the standard bapi bapi_user_get-detail.

b.rgds, Bernhard

Re: Table that stores User Master Data info

Former Member — Wed, 30 Jul 2008 08:36:32 GMT

Hi Bernhard,

Could you please let me know how I can get the details from "bapi_user_get-detail" .

I have not used txn BAPI. Now I executed it. I see two tab strips "Alphabetical" and "Hierarchical". I selected "Alphabetical" and traversed till the USER, Expanded and found the "GetDetail" method.

Here I have checked that there is this function module "BAPI_ADDRESSORG_GETDETAIL"

I did a test thru SE37 and It was asking about:

OBJ_TYPE

OBJ_ID

OBJ_ID_EXT

CONTEXT

I have provided the USER, <user name> in first two fields and did not get any results.

Please let me know how to get the details.

Regards,

Srihari

PS: the CONTEXT was 0001 (default). Also please let me know if I have to get the details for n number of users.

Edited by: Srihari Rao on Jul 30, 2008 2:07 PM

Re: Table that stores User Master Data info

Bernhard_SAP — Wed, 30 Jul 2008 10:17:42 GMT

Hi Srihari,

in TX BAPI: expand Basis components>Security>USER>Get Detail to find the technical background of the bapis.

To execute the bapi, simply start it in SE37 (with 'F8').

b.rgds, Bernhard

Re: Table that stores User Master Data info

Former Member — Wed, 30 Jul 2008 10:52:16 GMT

Hi Bernhard,

That is what i have done. My question was:

If i have to check the details for more than 1 user, what are the inputs i have to give?

Regards,

Srihari

Re: Table that stores User Master Data info

Former Member — Wed, 30 Jul 2008 11:19:55 GMT

Hi,

Why cant we go with SUIM -> User -> User by Address data

Regards,

N.Amarnath

Re: Table that stores User Master Data info

Former Member — Wed, 30 Jul 2008 11:47:29 GMT

You could easily create a small program (ABAP) which calls the BAPI; this would allow you to loop on USR02, call the BAPI for all occurrences, then display the results... or you could go the way via USR21 to ADR6:

data: w_bname type XUBNAME,

w_email type ADR6-SMTP_ADDR.

select BNAME from USR02 into w_bname.

select single * from USR21 where BNAME = w_bname.

select single SMTP_ADDR into w_email from ADR6 where PERSNUMBER = USR21-PERSNUMBER and ADDRNUMBER = USR21-ADDRNUMBER.

endselect.

There are almost endless possibilities. This is what makes development so creative and fun, instead of resorting to standard SAP solutions like SUIM... ))

Re: Table that stores User Master Data info

GinaCiuca — Wed, 30 Jul 2008 12:31:24 GMT

Thank you Bernhard!

I have no access to SM37 or to create query in prod, but I exported the tables and I'll merge the data.

Re: Table that stores User Master Data info

GinaCiuca — Wed, 30 Jul 2008 12:42:40 GMT

Thank you for the steps, but I don't have this access either. SUIM doesn't display this info unless you hit the Details button for each record, so it doesn't help when you need to generate a large list of users

Re: Table that stores User Master Data info

Former Member — Wed, 30 Jul 2008 13:32:14 GMT

> SUIM doesn't display this info unless you hit the Details button for each record, so it doesn't help when you need to generate a large list of users.

You might want to reconsider that after reading [this thread|; , particularly the posts at the bottom of it.

Cheers,

Julius

Re: Table that stores User Master Data info

GinaCiuca — Wed, 30 Jul 2008 22:46:28 GMT

Hello Julius,

I can see the Extension but not the Telephone and E-mail data in u2018Users by Address Datau2019 report within SUIM. I checked the thread that you are referring to and I am not sure if I am missing something.

Thank you, G.

Re: Table that stores User Master Data info

Former Member — Thu, 31 Jul 2008 08:01:34 GMT

There are two fields, one is "extention", another is "telephone".

Run report RSUSR002 for the list of users, then select "Change Layout" (Ctrl + F8) and add the fields you want.

Cheers,

Julius

Re: Table that stores User Master Data info

GinaCiuca — Thu, 31 Jul 2008 14:35:27 GMT

Thank you Julius.

The Extension and Telephone are available in this report, only the E-mail is not