The BUT052 table in SAP ERP or S/4HANA stores BP Relationship: Addresses data. There are total 9 fields in BUT052 table. The BP Relationship: Addresses table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT052 table. It is in SAP Business Partner: Basic Components (S_BUPA_GENERAL) ABAP package and is part of the Business Partner Foundation (BC-SRV-BP) module.
SAP BUT052 Table Fields
Following is the list of fields that are available in SAP BUT052 table. The primary key fields of the table are CLIENT (Client), RELNR (BP Relationship Number), PARTNER1 (Business Partner Number), PARTNER2 (Business Partner Number), DATE_TO (Validity Date (Valid To)), ADDRNUMBER (Address Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| RELNR | BP Relationship Number | BU_RELNR | BUT050 | CHAR (12) |
| PARTNER1 | Business Partner Number | BU_PARTNER | * | CHAR (10) |
| PARTNER2 | Business Partner Number | BU_PARTNER | * | CHAR (10) |
| DATE_TO | Validity Date (Valid To) | BU_DATTO | DATS (8) | |
| ADDRNUMBER | Address Number | AD_ADDRNUM | ADRC | CHAR (10) |
| XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR (1) | |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATS (8) | |
| NATION | Version ID for International Addresses | AD_NATION | * | CHAR (1) |
