SAP BUT021_FS Table – Time-Dependent Address Usages

The BUT021_FS table in SAP ERP or S/4HANA stores Time-Dependent Address Usages data. There are total 7 fields in BUT021_FS table. The Time-Dependent Address Usages 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 BUT021_FS 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 BUT021_FS Table Fields

Following is the list of fields that are available in SAP BUT021_FS table. The primary key fields of the table are CLIENT (Client), PARTNER (Business Partner Number), VALID_TO (Validity End of a Business Partner Address Usage), ADR_KIND (Address Type), 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)
VALID_TO Validity End of a Business Partner Address Usage BU_ADVW_VALID_TO DEC (15)
ADR_KIND Address Type BU_ADRKIND TB009 CHAR (10)
ADDRNUMBER Address Number AD_ADDRNUM BUT020 CHAR (10)
VALID_FROM Validity Start of a Business Partner Address Usage BU_ADVW_VALID_FROM DEC (15)
XDFADU Indicator: Standard Address Usage BU_XDFADU CHAR (1)