DMECR_TREE

Transparent Table Application Table
25 Fields 1 CDS Views

Draft table for entity I_PAYTFRMTCUSTTREETP

DMECR_TREE is an SAP database table in S/4HANA. Draft table for entity I_PAYTFRMTCUSTTREETP. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DataMdmExchCustTreeDrft view_entity from BASIC DMEE Customer Tree Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hierarchytreetype DME_TREETYPE Mapping Type ID
KEY hierarchytree DME_TREE Format Mapping Name
KEY draftuuid SDRAFT_UUID Draft Document ID
createdbyuser VDM_CREATEDBYUSERID Created By
creationdate FIS_CPDAT Creation Date
creationtime TTET_DT_CR_TIME Creation Time
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
lastchangedate DME_CHANGEDON Changed On
lastchangetime AEZEIT Changed At
hierarchytreedocumentationref DME_TREEDOCN Tree Documentation
hierarchytreeisreleased DMEE_RELEASE Released
hierarchytreeoriginallanguage DME_TREEORIGLLANG Tree Original Language
outputfileformatisxml DME_OUTPFILEFRMTISXML XML Output File Format
hierarchyparenttree DME_HIERPARTREE Parent Tree
hierarchytreeredefinitionlevel DME_TREEREDEFINITIONLVL Tree Redefinition Level
hierarchytreeshorttext DME_TREEDESC Description
bopfuuid SDRAFT_UUID Draft Document ID
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
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_PAYTFRMTCUSTTREETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMECR_TREE (
    MANDT,                           -- Client [MANDT]
    HIERARCHYTREETYPE,               -- Mapping Type ID [DME_TREETYPE]
    HIERARCHYTREE,                   -- Format Mapping Name [DME_TREE]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    CREATEDBYUSER,                   -- Created By [VDM_CREATEDBYUSERID]
    CREATIONDATE,                    -- Creation Date [FIS_CPDAT]
    CREATIONTIME,                    -- Creation Time [TTET_DT_CR_TIME]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    LASTCHANGEDATE,                  -- Changed On [DME_CHANGEDON]
    LASTCHANGETIME,                  -- Changed At [AEZEIT]
    HIERARCHYTREEDOCUMENTATIONREF,   -- Tree Documentation [DME_TREEDOCN]
    HIERARCHYTREEISRELEASED,         -- Released [DMEE_RELEASE]
    HIERARCHYTREEORIGINALLANGUAGE,   -- Tree Original Language [DME_TREEORIGLLANG]
    OUTPUTFILEFORMATISXML,           -- XML Output File Format [DME_OUTPFILEFRMTISXML]
    HIERARCHYPARENTTREE,             -- Parent Tree [DME_HIERPARTREE]
    HIERARCHYTREEREDEFINITIONLEVEL,  -- Tree Redefinition Level [DME_TREEREDEFINITIONLVL]
    HIERARCHYTREESHORTTEXT,          -- Description [DME_TREEDESC]
    BOPFUUID,                        -- Draft Document ID [SDRAFT_UUID]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- abap.char
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, HIERARCHYTREETYPE, HIERARCHYTREE, DRAFTUUID)
);

Learn More