Finding Email address Customer and Vendor Master on SAP
It’s not quite simple to find email address of Customer and Vendor Master on SAP. You need to activated SQL trace and change email on master to find where email address is stored. Here i share the result of tracing using SQL trace of email addess Customer and Vendor master.
For Customer :
select adr6-addrnumber (email) from table adr6 join table kna1 with key adr6-addrnumber = kna1-adrnr
For Vendor :
select adr6-addrnumber (email) from table adr6 join table lfa1 with key adr6-addrnumber = lfa1-adrnr
ABAP Version :
data : lv_email like adr6-addrnumber.
select addrnumber into lv_email from adr6 as a inner join kna1 as b on a~addrnumber = b~adrnr.