SAP Table BUT021 (BP: Address usages)

SAP table BUT021 has 4 primary key fields being CLIENT,PARTNER,ADR_KIND,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
ADR_KIND Address Type CHAR 10 0 TB009 BU_ADRKIND
ADDRNUMBER Address Number CHAR 10 0 BUT020 AD_ADDRNUM
XDFADU Indicator: Standard Address Usage CHAR 1 0 BU_XDFADU

BUT021 foreign key relationships

Table Field Check Table Check Field
0 BUT021 ADDRNUMBER BUT020 BP: Addresses PARTNER
1 BUT021 ADR_KIND TB009 BP address types ADR_KIND
0 BUT021 CLIENT T000 Clients MANDT
1 BUT021 PARTNER BUT000 BP: General data I PARTNER