cancel
Showing results for 
Search instead for 
Did you mean: 

How do we search Users with email address

Former Member
0 Kudos

Hi,

We want to provide report which shows all end users with their address details with email address.

In case if you have any information then please reply us.

Jigar Panchal

Accepted Solutions (1)

Accepted Solutions (1)

former_member190272
Active Contributor
0 Kudos

Hi,

Alternatively, you can use this FM (T code SE37)

CALL FUNCTION 'FTR_CORR_CHECK_EMAIL_SAP_USER'

EXPORTING

i_user = user

IMPORTING

e_email_address = email

EXCEPTIONS

mail_address = 1

determination_error = 2

OTHERS = 3.

<b>Rewads point if helpful</b>

Thanks

Pankaj Kumar

Former Member
0 Kudos

Hi Pankaj,

Thanks for the reply.

But can you elaborate on this.

With T Code SM37 I am not able to call the function.

It will be very helpful if you provide more detail on it.

Regards,

Jigar.

former_member190272
Active Contributor
0 Kudos

Hi

This is <b>SE37</b>

<b>Rewards point if helpful</b>

Thanks

Pankaj Kumar

Former Member

Hello Jigar,

You can get the informamtion through one more option also. In case of function module you need to execute the module again and again for each user or may be need to write a report. I would like to suggest you an alternative. That is making use of queries.

1. Go to transaction SQVI.

2. In the input field Quick View give the any name for query for example Z_EMAIL_ADD.

3. Choose create option. In the resulting pop up give description in Title field. In data source choose TABLE JOIN. Select Basis mode.

4. In the next screen choose INSERT TABLE pushbutton and in the pop up give USR21. Then again choose INSERT TABLE pushbutton and this time give ADR6.

5. Now go back using back arrow or F3.

6. Now in the new screen you will be under the tab strip List fld select.. From that entries under available filed (on right hand side) select User name in user master record and the first entry for Internet mail (SMTP) address. Now using single arrow pushbutton poitning towards left move these fields to tabstrip List fld select.

7. Now go to tabstrip selection filed. As done in step 6 move User name in user master record under it.

8. Save the changes and go back. A pop up will come asking you to save quick view Z_EMAIL_ADD. Choose yes.

9. Now execute the query. In the input field you can give one user or multiple users at a given time.

This approach is easier and time saving in my opinion and gives output in desirable format.

Please award points if the answer was helpful.

Regards.

Ruchit.

Answers (1)

Answers (1)

former_member190272
Active Contributor

Hi

<b>First your most welcome on sdn!</b>

You can check this SUIM---->User by Adderss Data-->Execute

Now you see all users

Rewads points if helpful

Thanks & Regards

Pankaj Kumar

Former Member
0 Kudos

Hi Pankaj,

Thanks for the reply.

We had already tried this option and it is not showing the email address.

In the User address details we had specified User email address Comm.Meth specified as Email as well as Remote Mail.

But still it is not showing the email address.

Regards,

Jigar Panchal