BUT020

Transparent Table Application Table
13 Fields 37 CDS Views

BP: Addresses

BUT020 is an SAP database table in S/4HANA. BP: Addresses. It contains 13 fields. 37 CDS views read from this table.

CDS Views using this table (37)

ViewTypeJoinVDMDescription
/BOFU/CV_BP_AddressInformation view inner BOPF: /BOFU/BuPa Node Addressinformation
/BOFU/CV_BPCurrentDefaultAddr view_entity from BOPF: Business Partner Current Address
/BOFU/CV_BPCurrentDfltAddr view from BOPF: /BOFU/BuPa Current Default Address (Old)
/BOFU/CV_Q_BPByAddress view_entity left_outer BOPF: BP Query on Address Data
/BOFU/VE_BPAI view_entity inner BOPF: Business Partner Address Inf.
Fclm_Bm_Address view left_outer Address data for bank master and business partner
Fclm_Bm_Contacts view left_outer Contact person for bank
Fclm_Bm_Used_Bp_Adr view left_outer Used business partner address for banks
Fclm_Bm_Used_Unit view left_outer Bank data of where used unit
I_ACMBusinessPartnerDetailsVH view inner BASIC Business Partner Details
I_ACMCustPartnerDetailsVH view inner BASIC Customer Partner Details
I_BPContactPersonAddressGov view_entity inner TRANSACTIONAL Base Contact Person Workplace Address
I_BPCurrentDefaultAddress view from BASIC Business Partner Current Default Address
I_BPEmailAddress view inner BASIC Business Partner Email Core View
I_BPFaxNumber view inner BASIC BP Fax number core view
I_BPMobilePhoneNumber view inner BASIC Mobile Phone Number core view
I_BPTelephoneNumber view inner BASIC BusinessPartner Telephone Number
I_BPWebsiteURL view inner BASIC BP Website Core View
I_BPWebsiteURL_2 view inner BASIC BP Website
I_BusinessPartAddress_2 view from COMPOSITE Business Partner Address
I_BusinessPartnerAddress view from BASIC Core view for Business Partner Address
I_BusinessPartnerAddress_2 view from BASIC Basic View for BP Address
I_BusinessPartnerDefaultAddr view from BASIC Business Partner Default Address
I_BusPartAddress view from BASIC Business Partner Address
I_BusPartScriptedGroupAddress view from BASIC International version of a business partner address
I_BusPartScriptedOrgAddress view from BASIC International version of a business partner address
I_BusPartScriptedPersonAddress view from COMPOSITE International version of a business partner address
I_BusPartTelephoneNumberGov view left_outer BASIC BP Governance Telephone Number
I_EmplHomeAddress view inner BASIC Obsolete - DONOT USE_Employee Home Address
I_EmployeeHomeAddress view inner BASIC Employee Home Address
I_InvgCsMPersonAddress view from BASIC Composite/Basic view for ICM Person Address
I_MDGovBPAddrProtFltr view from BASIC MDG BP Protected Address Filter
ICM_PARTNER_ORGANIZATION view inner BusinessPartner_Organization
P_CN_CADEAddressID view from BASIC
SHSM_M_EKUNP view inner Business Partner by Postal Code Search Help
SHSM_V_BUT020 view from Ersatz für V_BUT020 in Suchhilfe
SHSM_V_BUT020_I view from Ersatz für V_BUT020_I in Suchhilfe

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY partner BU_PARTNER Busn. Partner
KEY addrnumber AD_ADDRNUM Address Number
xdfadr BU_XDFADR Stand. address
adext BU_ADEXT External number
nation AD_NATION Address Version
guid SYSUUID_C UUID
move_addr BU_MOVE_ADDR Move Target
date_from BU_DATE_OBSOLETE From
address_guid BU_ADDRESS_GUID GUID of a Business Partner Address
addr_valid_from BU_ADDR_VALID_FROM Valid From
addr_valid_to BU_ADDR_VALID_TO Valid To
addr_move_date BU_ADDR_MOVE_DATE Date of Move

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.

-- BP: Addresses
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT020 (
    CLIENT,           -- Client [MANDT]
    PARTNER,          -- Busn. Partner [BU_PARTNER]
    ADDRNUMBER,       -- Address Number [AD_ADDRNUM]
    XDFADR,           -- Stand. address [BU_XDFADR]
    ADEXT,            -- External number [BU_ADEXT]
    NATION,           -- Address Version [AD_NATION]
    GUID,             -- UUID [SYSUUID_C]
    MOVE_ADDR,        -- Move Target [BU_MOVE_ADDR]
    DATE_FROM,        -- From [BU_DATE_OBSOLETE]
    ADDRESS_GUID,     -- GUID of a Business Partner Address [BU_ADDRESS_GUID]
    ADDR_VALID_FROM,  -- Valid From [BU_ADDR_VALID_FROM]
    ADDR_VALID_TO,    -- Valid To [BU_ADDR_VALID_TO]
    ADDR_MOVE_DATE,   -- Date of Move [BU_ADDR_MOVE_DATE]
    PRIMARY KEY (CLIENT, PARTNER, ADDRNUMBER)
);

Learn More