SAP Table BUT052

BP Relationship: Addresses

BUT052 (BP Relationship: Addresses) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUT052 to other SAP tables.

BUT052 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RELNR BP Relationship Number BU_RELNR BUT050 CHAR 12 0
PARTNER1 Business Partner Number BU_PARTNER CHAR 10 0
PARTNER2 Business Partner Number BU_PARTNER CHAR 10 0
DATE_TO Validity Date (Valid To) BU_DATTO DATS 8 0
ADDRNUMBER Address number AD_ADDRNUM ADRC CHAR 10 0
XDFADR Indicator: Address is standard address BU_XDFADR CHAR 1 0
X Yes
NULL No
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
NATION Version ID for International Addresses AD_NATION CHAR 1 0

BUT052 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUT052 ADDRNUMBER BUT052 NATION ADRC Addresses (Business Address Services) NATION
BUT052 ADDRNUMBER BUT052 CLIENT ADRC Addresses (Business Address Services) CLIENT
BUT052 ADDRNUMBER BUT052 ADDRNUMBER ADRC Addresses (Business Address Services) ADDRNUMBER
BUT052 ADDRNUMBER BUT052 DATE_FROM ADRC Addresses (Business Address Services) DATE_FROM
BUT052 CLIENT BUT052 CLIENT T000 Clients MANDT
BUT052 RELNR BUT052 DATE_TO BUT050 BP relationships/role definitions: General data DATE_TO
BUT052 RELNR BUT052 CLIENT BUT050 BP relationships/role definitions: General data CLIENT
BUT052 RELNR BUT052 RELNR BUT050 BP relationships/role definitions: General data RELNR
BUT052 RELNR BUT052 PARTNER1 BUT050 BP relationships/role definitions: General data PARTNER1
BUT052 RELNR BUT052 PARTNER2 BUT050 BP relationships/role definitions: General data PARTNER2