0Employee/Vendor/Customer Email Address

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!