SAP Table BUT020 (BP: Addresses)
SAP table BUT020 has 3 primary key fields being CLIENT,PARTNER,ADDRNUMBER.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PARTNER | Business Partner Number | CHAR | 10 | 0 | BUT000 | BU_PARTNER | |
| ADDRNUMBER | Address Number | CHAR | 10 | 0 | ADRC | AD_ADDRNUM | |
| XDFADR | Indicator: Address is standard address | CHAR | 1 | 0 | BU_XDFADR | ||
| ADEXT | Address number in external system | CHAR | 20 | 0 | BU_ADEXT | ||
| NATION | Version ID for International Addresses | CHAR | 1 | 0 | TSADV | AD_NATION | |
| GUID | UUID in character form | CHAR | 32 | 0 | SYSUUID_C | ||
| MOVE_ADDR | Number of Move Target Address for Address Moves | CHAR | 10 | 0 | * | BU_MOVE_ADDR | |
| DATE_FROM | Date Obsolete | DATS | 8 | 0 | BU_DATE_OBSOLETE | ||
| ADDRESS_GUID | GUID of a Business Partner Address | RAW | 16 | 0 | BU_ADDRESS_GUID | ||
| ADDR_VALID_FROM | Validity Start of a Business Partner Address | DEC | 15 | 0 | BU_ADDR_VALID_FROM | ||
| ADDR_VALID_TO | Validity End of a Business Partner Address | DEC | 15 | 0 | BU_ADDR_VALID_TO | ||
| ADDR_MOVE_DATE | Date of Move for Address Moves | DEC | 15 | 0 | BU_ADDR_MOVE_DATE |
BUT020 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BUT020 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | DATE_FROM |
| 0 BUT020 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | NATION |
| 1 BUT020 | CLIENT | T000 | Clients | MANDT |
| 0 BUT020 | PARTNER | BUT000 | BP: General data I | PARTNER |