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.

Rgds,

 

---

Possibly related posts: (automatically generated)

• Top 5 Reasons Not To Master Your Data in SAP ERP
• RE:[sap-acct] F110 Payment Run – Remittance Advices FAXED or EMAIL to Ven…