BUT020_DFT

Transparent Table Application Table
48 Fields 1 CDS Views

Draft table for entity I_BUSINESSPARTNERADDRESSGOVTP

BUT020_DFT is an SAP database table in S/4HANA. Draft table for entity I_BUSINESSPARTNERADDRESSGOVTP. It contains 48 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BusinessPartnerAddrGovDraft view_entity from BASIC Draft Access Restriction BP Address

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY businesspartneraddressuuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
KEY addressnumber ad_addrnum Address Number
mdchgprocessstep mdc_process_step_no Step Number
businesspartner bu_partner Busn. Partner
validitystartdate bu_addr_valid_from Valid From
validityenddate bu_addr_valid_to Valid To
addressvaliditystartdate abap.dats
addressvalidityenddate abap.dats
careofname ad_name_co c/o
streetprefixname ad_strspp1 Street 2
additionalstreetprefixname ad_strspp2 Street 3
housenumber ad_hsnm1 House Number
streetname ad_street Street
housenumbersupplementtext ad_hsnm2 Supplement
streetsuffixname ad_strspp3 Street 4
additionalstreetsuffixname ad_lctn Street 5
homecityname ad_city3 Different City
districtname ad_city2 District
postalcode ad_pstcd1 Postal Code
cityname ad_city1 City
country land1 Country/Reg.
region regio Region
addresstimezone ad_tzone Time Zone
transportzone lzone Transport Zone
taxjurisdiction ad_txjcd Tax Jurisdiction
companypostalcode ad_pstcd3 Company Post Cd
deliveryservicetypecode ad_delivery_service_type Delvry Serv Type
deliveryservicenumber ad_delivery_service_number Delivery Service No.
pobox ad_pobx PO Box
poboxiswithoutnumber ad_pobxnum PO Box w/o No.
poboxpostalcode ad_pstcd2 PO Box Post Cde
poboxlobbyname ad_po_box_lby PO Box Lobby
poboxdeviatingcityname ad_pobxloc PO Box City
poboxdeviatingregion ad_pobxreg PO Region
poboxdeviatingcountry ad_pobxcty PO Box C/R
correspondencelanguage spras Language
prfrdcommmediumtype ad_comm Comm. Method
cityfileteststatus ad_checkst Check Status
addressline1text abap.char
addressline2text ad_smtpadr E-Mail Address
formattedaddress abap.char
completeaddress abap.char
standardusage boole_d TRUE

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.

-- Draft table for entity I_BUSINESSPARTNERADDRESSGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT020_DFT (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNERUUID,         -- UUID [sysuuid_x]
    BUSINESSPARTNERADDRESSUUID,  -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,     -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,      -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,      -- Source ID [mdc_source_id]
    ADDRESSNUMBER,               -- Address Number [ad_addrnum]
    MDCHGPROCESSSTEP,            -- Step Number [mdc_process_step_no]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    VALIDITYSTARTDATE,           -- Valid From [bu_addr_valid_from]
    VALIDITYENDDATE,             -- Valid To [bu_addr_valid_to]
    ADDRESSVALIDITYSTARTDATE,    -- abap.dats
    ADDRESSVALIDITYENDDATE,      -- abap.dats
    CAREOFNAME,                  -- c/o [ad_name_co]
    STREETPREFIXNAME,            -- Street 2 [ad_strspp1]
    ADDITIONALSTREETPREFIXNAME,  -- Street 3 [ad_strspp2]
    HOUSENUMBER,                 -- House Number [ad_hsnm1]
    STREETNAME,                  -- Street [ad_street]
    HOUSENUMBERSUPPLEMENTTEXT,   -- Supplement [ad_hsnm2]
    STREETSUFFIXNAME,            -- Street 4 [ad_strspp3]
    ADDITIONALSTREETSUFFIXNAME,  -- Street 5 [ad_lctn]
    HOMECITYNAME,                -- Different City [ad_city3]
    DISTRICTNAME,                -- District [ad_city2]
    POSTALCODE,                  -- Postal Code [ad_pstcd1]
    CITYNAME,                    -- City [ad_city1]
    COUNTRY,                     -- Country/Reg. [land1]
    REGION,                      -- Region [regio]
    ADDRESSTIMEZONE,             -- Time Zone [ad_tzone]
    TRANSPORTZONE,               -- Transport Zone [lzone]
    TAXJURISDICTION,             -- Tax Jurisdiction [ad_txjcd]
    COMPANYPOSTALCODE,           -- Company Post Cd [ad_pstcd3]
    DELIVERYSERVICETYPECODE,     -- Delvry Serv Type [ad_delivery_service_type]
    DELIVERYSERVICENUMBER,       -- Delivery Service No. [ad_delivery_service_number]
    POBOX,                       -- PO Box [ad_pobx]
    POBOXISWITHOUTNUMBER,        -- PO Box w/o No. [ad_pobxnum]
    POBOXPOSTALCODE,             -- PO Box Post Cde [ad_pstcd2]
    POBOXLOBBYNAME,              -- PO Box Lobby [ad_po_box_lby]
    POBOXDEVIATINGCITYNAME,      -- PO Box City [ad_pobxloc]
    POBOXDEVIATINGREGION,        -- PO Region [ad_pobxreg]
    POBOXDEVIATINGCOUNTRY,       -- PO Box C/R [ad_pobxcty]
    CORRESPONDENCELANGUAGE,      -- Language [spras]
    PRFRDCOMMMEDIUMTYPE,         -- Comm. Method [ad_comm]
    CITYFILETESTSTATUS,          -- Check Status [ad_checkst]
    ADDRESSLINE1TEXT,            -- abap.char
    ADDRESSLINE2TEXT,            -- E-Mail Address [ad_smtpadr]
    FORMATTEDADDRESS,            -- abap.char
    COMPLETEADDRESS,             -- abap.char
    STANDARDUSAGE,               -- TRUE [boole_d]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, BUSINESSPARTNERADDRESSUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER)
);

Learn More