on 05-17-2007 6:25 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.