BUT052_DFT

Transparent Table Application Table
18 Fields 1 CDS Views

Draft table for entity I_BPCONTACTPERSONADDRESSGOVTP

BUT052_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCONTACTPERSONADDRESSGOVTP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPContactPersonAddrGovDraft view_entity from BASIC Draft Access Rel Workplace Address

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bprelshpuuid sysuuid_x UUID
KEY bpcntctpersnaddruuid 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 mdc_src_addrnum Src Address No
KEY bprelshpcatisinfwddirection boolean Boolean Variable (X = True, - = False, Space = Unknown)
mdchgprocessstep mdc_process_step_no Step Number
addressnumberforedit mdc_src_addrnum Src Address No
businesspartneraddressuuid mdc_src_addr_guid Src Addr Guid
standardusage bu_xdfadr Stand. address
contactrelationshipfunction ad_fnctn Function
contactrelationshipdepartment ad_dprtmnt Department
floor ad_floor Floor
workplacebuilding ad_bldng_p Building code
roomnumber ad_roomnum Room Number
prfrdcommmediumtype ad_comm Comm. Method

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_BPCONTACTPERSONADDRESSGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT052_DFT (
    MANDT,                          -- Client [mandt]
    BPRELSHPUUID,                   -- UUID [sysuuid_x]
    BPCNTCTPERSNADDRUUID,           -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,        -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,         -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,         -- Source ID [mdc_source_id]
    ADDRESSNUMBER,                  -- Src Address No [mdc_src_addrnum]
    BPRELSHPCATISINFWDDIRECTION,    -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    MDCHGPROCESSSTEP,               -- Step Number [mdc_process_step_no]
    ADDRESSNUMBERFOREDIT,           -- Src Address No [mdc_src_addrnum]
    BUSINESSPARTNERADDRESSUUID,     -- Src Addr Guid [mdc_src_addr_guid]
    STANDARDUSAGE,                  -- Stand. address [bu_xdfadr]
    CONTACTRELATIONSHIPFUNCTION,    -- Function [ad_fnctn]
    CONTACTRELATIONSHIPDEPARTMENT,  -- Department [ad_dprtmnt]
    FLOOR,                          -- Floor [ad_floor]
    WORKPLACEBUILDING,              -- Building code [ad_bldng_p]
    ROOMNUMBER,                     -- Room Number [ad_roomnum]
    PRFRDCOMMMEDIUMTYPE,            -- Comm. Method [ad_comm]
    PRIMARY KEY (MANDT, BPRELSHPUUID, BPCNTCTPERSNADDRUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, BPRELSHPCATISINFWDDIRECTION)
);

Learn More