The BUT020 table in SAP ERP or S/4HANA stores BP: Addresses data. There are total 13 fields in BUT020 table. The BP: 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 BUT020 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 BUT020 Table Fields
Following is the list of fields that are available in SAP BUT020 table. The primary key fields of the table are CLIENT (Client), PARTNER (Business Partner Number), ADDRNUMBER (Address Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| ADDRNUMBER | Address Number | AD_ADDRNUM | ADRC | CHAR (10) |
| XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR (1) | |
| ADEXT | Address number in external system | BU_ADEXT | CHAR (20) | |
| NATION | Version ID for International Addresses | AD_NATION | TSADV | CHAR (1) |
| GUID | UUID in character form | SYSUUID_C | CHAR (32) | |
| MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | * | CHAR (10) |
| DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS (8) | |
| ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW (16) | |
| ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC (15) | |
| ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC (15) | |
| ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC (15) |
