1. Get email address for the SAP user name, current user(Option 1)
clear smtp_address.
select single adr6~smtp_addr into smtp_address
from usr21
inner join adr6
on usr21~addrnumber = adr6~addrnumber
and usr21~persnumber = adr6~persnumber
where usr21~bname = sy-uname.
2. Get email address for the SAP user name, current user(Option 2)
SELECT SINGLE * FROM PA0105 WHERE USRID = SY-UNAME.
SELECT SINGLE * FROM PA0002 WHERE PERNR = PA0105-PERNR.
FL_NAME-PERIOD = '.'.
FL_NAME-FIRST = PA0002-VORNA.
FL_NAME-LAST = PA0002-NACHN.
CONDENSE FL_NAME NO-GAPS.
CONCATENATE FL_NAME '@company.com' INTO NAME_LIST-FLNAME.
APPEND NAME_LIST.
3. Get the emal ID of the employees from HR database
SELECT SINGLE * FROM PA0105 WHERE PERNR = XVBPA-PERNR
AND SUBTY = '0010'.
Labels: ADR06, eMail, Extract, Extract eMail Id, HR database, Ids, PA0105, recipients, SAPHR, various types of recipients
posted by Vishal @ 1:56 PM
0 comments
