BUT052_DFT

Transparent Table Application Table

Draft table for entity I_BPCONTACTPERSONADDRESSGOVTP

BUT052_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCONTACTPERSONADDRESSGOVTP. It contains 26 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 (26)

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
addressline1textforedit abap.char
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
bpaddressisprotected BU_PROTECTED Sensitivity
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    ADDRESSLINE1TEXTFOREDIT,        -- abap.char
    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]
    BPADDRESSISPROTECTED,           -- Sensitivity [BU_PROTECTED]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, BPRELSHPUUID, BPCNTCTPERSNADDRUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, BPRELSHPCATISINFWDDIRECTION)
);