BUT100_DFT

Transparent Table Application Table
20 Fields 1 CDS Views

Draft table for entity I_BUSINESSPARTNERROLEGOVTP

BUT100_DFT is an SAP database table in S/4HANA. Draft table for entity I_BUSINESSPARTNERROLEGOVTP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BusinessPartnerRoleGovDraft view_entity from BASIC Draft Access Restriction BP Role

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartneruuid BU_PARTNER_GUID BP GUID
KEY bproleuuid ABP_BEHV_PID Preliminary ID
KEY masterdatachangeprocess MDC_PROCESS_ID Process ID
KEY mdchgprocesssrcesystem MDC_BUSINESS_SYSTEM Source System
KEY mdchgprocesssrceobject MDC_SOURCE_ID Source ID
KEY businesspartnerrole BU_PARTNERROLE BP Role
businesspartner BU_PARTNER Busn. Partner
businesspartnerroleforedit BU_PARTNERROLE BP Role
mdchgprocessstep MDC_PROCESS_STEP_NO Step Number
validfrom BU_ROLE_VALID_FROM Valid From
validto BU_ROLE_VALID_TO Valid To
validitystartdate abap.dats
validityenddate abap.dats
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_BUSINESSPARTNERROLEGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT100_DFT (
    MANDT,                          -- Client [MANDT]
    BUSINESSPARTNERUUID,            -- BP GUID [BU_PARTNER_GUID]
    BPROLEUUID,                     -- Preliminary ID [ABP_BEHV_PID]
    MASTERDATACHANGEPROCESS,        -- Process ID [MDC_PROCESS_ID]
    MDCHGPROCESSSRCESYSTEM,         -- Source System [MDC_BUSINESS_SYSTEM]
    MDCHGPROCESSSRCEOBJECT,         -- Source ID [MDC_SOURCE_ID]
    BUSINESSPARTNERROLE,            -- BP Role [BU_PARTNERROLE]
    BUSINESSPARTNER,                -- Busn. Partner [BU_PARTNER]
    BUSINESSPARTNERROLEFOREDIT,     -- BP Role [BU_PARTNERROLE]
    MDCHGPROCESSSTEP,               -- Step Number [MDC_PROCESS_STEP_NO]
    VALIDFROM,                      -- Valid From [BU_ROLE_VALID_FROM]
    VALIDTO,                        -- Valid To [BU_ROLE_VALID_TO]
    VALIDITYSTARTDATE,              -- abap.dats
    VALIDITYENDDATE,                -- abap.dats
    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, BUSINESSPARTNERUUID, BPROLEUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, BUSINESSPARTNERROLE)
);

Learn More