How to find out email id from CUA ?

[Former Member]

Hi,

I would like to have a list of user id with email from CUA. Is there any table/report from where I can get both ?

All users are maintained with user id and email into SU01.

Thanks...

[Former Member]

Hi,

You can obtain this data from the tables USR21 and ADR6.From USR21 you can obtain address number and personnel number for users and then give these values in ADR6 to find their e-mail addresses. I am not aware of the standard report for this puropse. You can create a custom report using join of these two tables.

Please award points if the answer has helpful.

Regards.

Ruchit.

[WolfgangJanzen]

How about BAPI_USER_GET_DETAIL?

import parameter: USERNAME

export parameter: ADDRESS-E_MAIL

[Former Member]

As ruchit said we can grab from ADR6 and USR21.

you can use RSUSR007 repor which can show the users who

have their email address maintained and who din't.

but you won't be getting the mail address.

and I am not sure whether BAPI_USER_GET_DETAIL allows you to look at multiple users at a time.

[Former Member]

Ruchit,

Helpful ans. Points are assigned to you.

One more thing. How can I find out field name (like, in this case it is SMTP_ADDR) from any view/screen ? And after getting field name, how to find out what table in SAP has this field ?

Thanks/....

[Former Member]

Hi,

In order to find the field/table name of any field of a screen do an F1 on that field. A pop up would come up. At the top of the pop up you will find a tool icon (if you move your curson it it will show technical information)just adjacent to book shaped icon for application help. it will give you the field name and also table/structure name. if it gives you table name then it is easy but if it gives you structure name then it is extra manual effort for you. in case of structure ignore the structure name and just choose data element name. Go to SE11 and give the data element name as input in data type field. Go to display mode. then inside it try to get the where used list for the data element. Hotkeys are CTRLSHIFTF3 (also the icon for where user list is on application menu bar). You will get a pop up with table field checkbox selected as default. let it remain the only selection and press enter. next you will get a list of all tables that have a field corresponding to the data element. Then you need to make checks on which table is the best for you.

Try it out for SMTP_ADDR as it points to a structure SZA5_D0700.Couple of times you do this you wil find it lot more easier.

I hope this would help you out for future as well.

With Regards.

Ruchit.

[Former Member]

Ruchit,

Thank you for your valuable information. Again, points are assigned to you.

Thanks again..

[Former Member]

Hi Prashant,

To make it even more easy I would suggest that you use transaction SQVI. I tried it for this issue and it worked. I plan to use it now for other similar queries. In SQVI you can define a join of USR21 and ADR6 tables and construct a query around it which would get you the data easily.

Please follow the following steps for this:

1. Go to transaction SQVI.

2. Give the query name as Z*....

3. Now press the create button.

4. Give a title of your choice and in data source choose TABLE JOIN option. Choose Basis Mode option as well.Press enter.

5. Now you come to the Join Definition Screen. Choose insert table and then choose ADR6 and USR21. After this go back.

6. Now choose List fld. select TABSTRIP. From available fields option move

User name in user master record and Internet mail (SMTP) address to Fields in list. This will define out output fields.

7. Choose SELECTION FIELDS tabstrip. Here move the value User name in user master record from available fields to Selection fields.

8. Save the entries.

9. Execute the query and give user ids of your choice and check for the output.

Let me know if it worked for you!!. Please award points accordingly.

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

I tried Joining Tables USR21 and ADR6 by SQVi , through creating queries, and it worked absolutly fine and i got the desired result,

P,S: We do not have CUA in our SAP Environment,it is managed by TIM

Many Thanks,

[Former Member]

Hi Prashant,
> Let me know if it worked for you!!. Please award points accordingly.
> 
> Regards.
> 
> Ruchit.

on comparative terms, the Security forum was quite tidy, please refrain from polluting it

[Former Member]

> on comparative terms, the Security forum was quite tidy, please refrain from polluting it

Please check the date of that post

Rob

[Former Member]

Thanks, for pointing it out

I feel like (bowdlerized) now

Edited by: Rob Burbank on Jul 15, 2011 2:47 PM

[Former Member]

Well, I thought it was kind of funny.

Rob