BUT021_FS

Transparent Table Application Table
7 Fields 12 CDS Views

Time-Dependent Address Usages

BUT021_FS is an SAP database table in S/4HANA. Time-Dependent Address Usages. It contains 7 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
/BOFU/CV_BP_AddressUsage view from BOPF: /BOFU/BuPa Node Address Usage
/BOFU/CV_BPCurrentDefaultAddr view_entity inner BOPF: Business Partner Current Address
/BOFU/CV_BPCurrentDfltAddr view inner BOPF: /BOFU/BuPa Current Default Address (Old)
/BOFU/VE_BPAU view_entity from BOPF: Business Partner Address Usage
I_BPCurrentDefaultAddress view inner BASIC Business Partner Current Default Address
I_BusinessPartnerAddressDsp view_entity from BASIC Business Partner Address Display
I_Businesspartneraddressusage view from BASIC Busineess Partner Address Usage Core View
I_BusinessPartnerDefaultAddr view inner BASIC Business Partner Default Address
I_EmplHomeAddress view inner BASIC Obsolete - DONOT USE_Employee Home Address
I_MDGovBPAddrProtFltr view inner BASIC MDG BP Protected Address Filter
P_BPProtectedAddrUsageCount view from COMPOSITE
P_MDGovBPAddrUsageFltr view from BASIC

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY partner BU_PARTNER Busn. Partner
KEY valid_to BU_ADVW_VALID_TO Valid To
KEY adr_kind BU_ADRKIND Address Type
KEY addrnumber AD_ADDRNUM Address Number
valid_from BU_ADVW_VALID_FROM Valid From
xdfadu BU_XDFADU Standard Usage

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Time-Dependent Address Usages
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT021_FS (
    CLIENT,      -- Client [MANDT]
    PARTNER,     -- Busn. Partner [BU_PARTNER]
    VALID_TO,    -- Valid To [BU_ADVW_VALID_TO]
    ADR_KIND,    -- Address Type [BU_ADRKIND]
    ADDRNUMBER,  -- Address Number [AD_ADDRNUM]
    VALID_FROM,  -- Valid From [BU_ADVW_VALID_FROM]
    XDFADU,      -- Standard Usage [BU_XDFADU]
    PRIMARY KEY (CLIENT, PARTNER, VALID_TO, ADR_KIND, ADDRNUMBER)
);

Learn More