Customer Relationship Management Blogs by Members
Find insights on SAP CRM and other customer relationship management products and topics in blog posts from community members and share your own perspective.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member211387
Contributor

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

1 Comment