In SAP CRM Business Partner data contains a lot of information. The contact information like email address are stored in two separate categories. Address Dependent and Address Independent. This document provides information on the fields and tables pertaining to identifying the Address independent email address in SAP CRM.
The reference to the Address independent email is stored in table BUT000.
Email addreses are (address independent and dependent) stored in table ADR6.
In BUT000 the reference to Address independent email is stored as follows
For Persons -
BUT000.TYPE = 1
The field where the data is stored is BUT000.PERSNUMBER
The address independent email data is stored in ADR6 table. So one can retrieve the address independent email address from ADR6 table using the BUT000.PERSNUMBER value. The corresponding field in ADR6 for Person Number is ADR6.PERSNUMBER.
BUT000.TYPE = 2
The field where the data is stored in BUT000 table is BUT000.ADDRCOMM
ADR6 is where the email address is still stored but the field PERSNUMBER is not populated. The data is retrieved directly using the ADDRNUMBER in the ADR6 field.
The relationship will hence be BUT000.ADDRCOMM = ADR6.ADDRNUMBER