0Employee/Vendor/Customer Email Address

[Former Member]

Hello,

Does anyone know how to get the email address into BW for an employee, vendor, or customer? The email address resides in the R/3 table ADR6, however, the email address is not referenced by the employee/vendor/customer number. So I'm not sure how to make the link from employee/vendor/customer master data to the corresponding email address. Any suggesstions would be greatly appreciated. Thanks!

[Former Member · Accepted solution]

Hi Shelly,

Create a generic funciton module on tables KNA1,.LFA1..with ADRC..

Example:-

For customers go to KNA1 table..for a customer number..and get the field <b>ADRNR</b>.. Retrieve the email info from table ADRC field <b>FLAGCOMM6</b> based on the address number <b>ADDRNUMBER</b>. Check if the SMTP info is populated in this field for given address number..

Same is the case with vendors..

Go to KNA1 get the addressnumber and retrive the mail info from ADRC table based on address number

Regards

Manga(Assign points if it helps!!)

[Former Member · Accepted solution]

Thank you very much!