Email field

[Former Member]

How can have the email of a person with his id or name?

Thanks

[Former Member · Accepted solution]

Hello,

TO get the email ID from the User ID, you have to use the table USR21 and ADR6 tables.

                SELECT SINGLE * INTO l_r_usr21 FROM usr21
                       WHERE bname = sy-uname.
                  SELECT SINGLE * INTO l_r_adr6 FROM adr6
                         WHERE addrnumber = l_r_usr21-addrnumber
                         AND   persnumber = l_r_usr21-persnumber
                         AND   date_from  < sy-datum.

Cheers,

Vasanth

[Former Member]

Refer to this related thread

http://www.sapdev.co.uk/reporting/email/email_sapmail.htm

Regards,

Santosh