BUT051_DFT

Transparent Table Application Table
24 Fields 1 CDS Views

Draft table for entity I_BUSPARTCONTACTPERSONGOVTP

BUT051_DFT is an SAP database table in S/4HANA. Draft table for entity I_BUSPARTCONTACTPERSONGOVTP. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPContactPersonGovDraft view_entity from BASIC Draft Access BP Rel Contact Person

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bprelshpuuid 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 bprelshpcatisinfwddirection boolean Boolean Variable (X = True, - = False, Space = Unknown)
mdchgprocessstep mdc_process_step_no Step Number
contactpersonfunction bu_pafkt Function
contactpersonfunctionname bu_fnctn Function
contactpersondepartment bu_abtnr Department
contactpersondepartmentname bu_dprtmnt Company dept.
contactpersonauthoritytype bu_paauth Authority
contactpersonviptype bu_pavip VIP
contactpersonremarktext bu_parem Note
phonenumber ad_tlnmbr Telephone
phonenumberextension ad_tlxtns Extension
addressfaxnumber ad_fxnmbr Fax
faxnumberextension ad_fxxtns Extension
emailaddress ad_smtpadr E-Mail Address
businesspartner1 mdc_bprel_source_partner Partner
businesspartner2 mdc_bprel_source_partner Partner
bp1authorizationgroup bu_augrp Authorization Group
bp2authorizationgroup bu_augrp Authorization Group
etag mdc_process_update_token Update Token

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_BUSPARTCONTACTPERSONGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT051_DFT (
    MANDT,                        -- Client [mandt]
    BPRELSHPUUID,                 -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,      -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,       -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,       -- Source ID [mdc_source_id]
    BPRELSHPCATISINFWDDIRECTION,  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    MDCHGPROCESSSTEP,             -- Step Number [mdc_process_step_no]
    CONTACTPERSONFUNCTION,        -- Function [bu_pafkt]
    CONTACTPERSONFUNCTIONNAME,    -- Function [bu_fnctn]
    CONTACTPERSONDEPARTMENT,      -- Department [bu_abtnr]
    CONTACTPERSONDEPARTMENTNAME,  -- Company dept. [bu_dprtmnt]
    CONTACTPERSONAUTHORITYTYPE,   -- Authority [bu_paauth]
    CONTACTPERSONVIPTYPE,         -- VIP [bu_pavip]
    CONTACTPERSONREMARKTEXT,      -- Note [bu_parem]
    PHONENUMBER,                  -- Telephone [ad_tlnmbr]
    PHONENUMBEREXTENSION,         -- Extension [ad_tlxtns]
    ADDRESSFAXNUMBER,             -- Fax [ad_fxnmbr]
    FAXNUMBEREXTENSION,           -- Extension [ad_fxxtns]
    EMAILADDRESS,                 -- E-Mail Address [ad_smtpadr]
    BUSINESSPARTNER1,             -- Partner [mdc_bprel_source_partner]
    BUSINESSPARTNER2,             -- Partner [mdc_bprel_source_partner]
    BP1AUTHORIZATIONGROUP,        -- Authorization Group [bu_augrp]
    BP2AUTHORIZATIONGROUP,        -- Authorization Group [bu_augrp]
    ETAG,                         -- Update Token [mdc_process_update_token]
    PRIMARY KEY (MANDT, BPRELSHPUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, BPRELSHPCATISINFWDDIRECTION)
);

Learn More