Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply