Address Independent Email – Business Partners
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.
For Organizations
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
|
BP TYPE |
BUT000.TYPE |
BUT000.PERSNUMBER |
ADR6.PERSNUMBER |
BUT000.ADDRCOMM |
ADR6.ADDRNUMBER |
|
Organization |
2 |
NULL |
NULL |
NOT NULL |
NOT NULL |
|
Person |
1 |
NOT NULL |
NOT NULL |
NOT NULL |
NOT NULL |
Hello,
thank you for your blog.
As I understand, email address is determined from table ADR6 for a business partner with type 1 via BUT000.PERSNUMBER.
Could it be that this business partner also has an entry in table ADR6 that is determined with BUT000.ADDRCOMM?
Example:
BUT000.BP: 123
BUT000.Type: 1
BUT000.PERSNUMBER: 456
BUT000.ADDRCOMM: 789
ADR6.PERSNUMBER: 456 - abcd@gamil.com
ADR6.ADDRNUMBER: 789 - efgh@gmail.com
which email address is being fetched for business partner 123?
Best Regards,
Haji