DMECR_TREE_HEAD

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

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

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

Learn More