DMECR_TREE_HEAD

Transparent Table Application Table
43 Fields 1 CDS Views

Draft table for entity I_PAYTFRMTCUSTTREEPRPTYTP

DMECR_TREE_HEAD is an SAP database table in S/4HANA. Draft table for entity I_PAYTFRMTCUSTTREEPRPTYTP. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DataMdmExchCustTreePrptyDrft view_entity from BASIC DMEE Customer Tree Property Draft

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hierarchytreetype DME_TREETYPE Mapping Type ID
KEY hierarchytree DME_TREE Format Mapping Name
KEY hierarchytreeversion IFME_HIERARCHYTREEVERSION Format Mapping Version
KEY draftuuid SDRAFT_UUID Draft Document ID
hierarchytreeparametersstruc DME_TREEPARAMSTRUC Tree Parameters Structure
outputstructuredelimitertype DME_OUTPSTRUCTDELIMTYPE Output Structure Delimiter Type
segmentgroupdelimitercharvalue DME_SGMTGRPDELIMITERVAL Segment Group Delimiter Sign
segmentdelimitercharactervalue DME_SGMTDELIMITERVAL Segment Delimiter Sign
compositedelimitercharvalue DME_COMPDELIMITERVAL Composite Delimiter Sign
delimiteriscompressed DME_DELIMITERCOMPRESS Compress Delimiters
delimiterescapecharactervalue DME_DELIMITERESCVAL Delimiter Escape Sign
hierarchyrootnode DME_ROOTNODE Root Node
sgmtgrpiscarriageretseparated DME_SEGMGRPCRSEP Segment Group CR Separated
segmentgrpislinefeedseparated DME_SEGMGRPLFSEP Segment Group LF Separated
segmentiscarriageretseparated DME_SEGMCRSEP Segment CR Separated
segmentislinefeedseparated DME_SEGMLFSEP Segment LF Separated
accompanyingsheettype DME_SHTTYPE Accompanying Sheet Type
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
lastchangedate TTET_DT_CHG_DATE Change Date
lastchangetime AEZEIT Changed At
specialhandlingcharacter DME_SPCLHNDLGCHAR Special Handling Character
specialhandlingcharacterisexcl DME_SPECHANDLCHAREXCL Exclude Special Handling Character
postprocessingprogramname DME_POSTPROCGPGM Program for Post Processing
lengthisbytes DME_LENGTHBYTES Length in Bytes
datareleaserequestid DMEE_REQUEST_ID Request ID
hierarchytreeversiontype DMEE_VERSION_TYPE Version Type
status DME_STATUS Status
iscustomerhierarchyparenttree DME_ISCUSTPARTREE Parent Tree In Customer Format
paymentmediumformat DME_PAYMENTFORMAT Payment Format
paymentmediumformatdescription FORMX_FPM Description
xmlemptyelementprocessingtype DMEE_XML_EMPTY_ELEMENT_PROC Empty Element Processing
hiertreespclcharhndlgoptions DMEE_CHARSET_OPTIONS Charset Options
hiertreespclcharregularexprval DMEE_CHARACTER_REGEX Regex Pattern
xmlschemadefinitionidentifier /PF1/DTE_MESSAGE_TYPE Message Identifier
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_PAYTFRMTCUSTTREEPRPTYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMECR_TREE_HEAD (
    MANDT,                           -- Client [MANDT]
    HIERARCHYTREETYPE,               -- Mapping Type ID [DME_TREETYPE]
    HIERARCHYTREE,                   -- Format Mapping Name [DME_TREE]
    HIERARCHYTREEVERSION,            -- Format Mapping Version [IFME_HIERARCHYTREEVERSION]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    HIERARCHYTREEPARAMETERSSTRUC,    -- Tree Parameters Structure [DME_TREEPARAMSTRUC]
    OUTPUTSTRUCTUREDELIMITERTYPE,    -- Output Structure Delimiter Type [DME_OUTPSTRUCTDELIMTYPE]
    SEGMENTGROUPDELIMITERCHARVALUE,  -- Segment Group Delimiter Sign [DME_SGMTGRPDELIMITERVAL]
    SEGMENTDELIMITERCHARACTERVALUE,  -- Segment Delimiter Sign [DME_SGMTDELIMITERVAL]
    COMPOSITEDELIMITERCHARVALUE,     -- Composite Delimiter Sign [DME_COMPDELIMITERVAL]
    DELIMITERISCOMPRESSED,           -- Compress Delimiters [DME_DELIMITERCOMPRESS]
    DELIMITERESCAPECHARACTERVALUE,   -- Delimiter Escape Sign [DME_DELIMITERESCVAL]
    HIERARCHYROOTNODE,               -- Root Node [DME_ROOTNODE]
    SGMTGRPISCARRIAGERETSEPARATED,   -- Segment Group CR Separated [DME_SEGMGRPCRSEP]
    SEGMENTGRPISLINEFEEDSEPARATED,   -- Segment Group LF Separated [DME_SEGMGRPLFSEP]
    SEGMENTISCARRIAGERETSEPARATED,   -- Segment CR Separated [DME_SEGMCRSEP]
    SEGMENTISLINEFEEDSEPARATED,      -- Segment LF Separated [DME_SEGMLFSEP]
    ACCOMPANYINGSHEETTYPE,           -- Accompanying Sheet Type [DME_SHTTYPE]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    LASTCHANGEDATE,                  -- Change Date [TTET_DT_CHG_DATE]
    LASTCHANGETIME,                  -- Changed At [AEZEIT]
    SPECIALHANDLINGCHARACTER,        -- Special Handling Character [DME_SPCLHNDLGCHAR]
    SPECIALHANDLINGCHARACTERISEXCL,  -- Exclude Special Handling Character [DME_SPECHANDLCHAREXCL]
    POSTPROCESSINGPROGRAMNAME,       -- Program for Post Processing [DME_POSTPROCGPGM]
    LENGTHISBYTES,                   -- Length in Bytes [DME_LENGTHBYTES]
    DATARELEASEREQUESTID,            -- Request ID [DMEE_REQUEST_ID]
    HIERARCHYTREEVERSIONTYPE,        -- Version Type [DMEE_VERSION_TYPE]
    STATUS,                          -- Status [DME_STATUS]
    ISCUSTOMERHIERARCHYPARENTTREE,   -- Parent Tree In Customer Format [DME_ISCUSTPARTREE]
    PAYMENTMEDIUMFORMAT,             -- Payment Format [DME_PAYMENTFORMAT]
    PAYMENTMEDIUMFORMATDESCRIPTION,  -- Description [FORMX_FPM]
    XMLEMPTYELEMENTPROCESSINGTYPE,   -- Empty Element Processing [DMEE_XML_EMPTY_ELEMENT_PROC]
    HIERTREESPCLCHARHNDLGOPTIONS,    -- Charset Options [DMEE_CHARSET_OPTIONS]
    HIERTREESPCLCHARREGULAREXPRVAL,  -- Regex Pattern [DMEE_CHARACTER_REGEX]
    XMLSCHEMADEFINITIONIDENTIFIER,   -- Message Identifier [/PF1/DTE_MESSAGE_TYPE]
    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, HIERARCHYTREEVERSION, DRAFTUUID)
);

Learn More