DMECR_TREE

Transparent Table Application Table
18 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 18 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 (18)

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

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]
    PRIMARY KEY (MANDT, HIERARCHYTREETYPE, HIERARCHYTREE, DRAFTUUID)
);

Learn More