Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Email Addresses table

Former Member
0 Kudos

Hi All,

Could you pls let me know the table name where in the email addresses such as for eg:

abc@yahoo.com

abc1234@indiatimes.com

abc567@rediffmail.com

are stored.

Advance Thanx,

Regards

Suresh

4 REPLIES 4

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

ADR6. Are you looking for email addresses of SAP users?

Regards,

Rich Heilman

0 Kudos

If it is for user ids, then check out this code.



report zrich_0001 .

data: begin of user_info,
      bname type usr21-bname,
      smtp_addr type adr6-smtp_addr,
      end of user_info.


* Get User Data
clear user_info.
select Single usr21~bname adr6~smtp_addr
                into corresponding fields of  user_info
                  from usr21
                    inner join adr6
                      on  usr21~addrnumber = adr6~addrnumber
                      and usr21~persnumber = adr6~persnumber
                            where usr21~bname = sy-uname.


  write:/ user_info-bname, user_info-smtp_addr
.

Regards,

Rich Heilman

0 Kudos

Hi,

just in case you are looking for the Employees' Email id in HR.. it is the field USRID_LONG in table PA0105 subty '0010'.

Regards,

Suresh Datti

former_member188685
Active Contributor
0 Kudos

ADr6 table