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 |
Possible values
|
||||||
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 |