DMEC_TREE_NODE

Transparent Table Customizing Table
52 Fields 1 CDS Views

DMEE: Customer Format Tree Nodes

DMEC_TREE_NODE is an SAP database table in S/4HANA. DMEE: Customer Format Tree Nodes. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DataMdmExchCustNode view_entity from BASIC DMEE Customer Node

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tree_type DMEE_TREETYPE Tree Type
KEY tree_id DMEE_TREEID Format Tree
KEY version DMEE_VERSION Version
KEY node_id DMEE_NODEID Node ID
tech_name DMEE_TECH_NAME Node Name
ref_name DMEE_REF_NAME Reference ID
parent_id DMEE_NODEID Node ID
brother_id DMEE_NODEID Node ID
firstchild_id DMEE_NODEID Node ID
node_type DMEE_NODETYPE Node type
length DMEE_LENGTH Length
data_type DMEE_DATA_TYPE Type
ex_status DMEE_EX_STATUS Status
lev DMEE_LEVEL Level
x_compltab DMEE_X_COMPLTAB Entire table
tab_keyfld DMEE_TABKEYFLD Key field
atom_handl DMEE_ATOM_HANDL Atom Handling
mp_offset DMEE_MP_OFFSET Target Offset
mp_sc_tab DMEE_MP_SC_TAB Structure
mp_sc_fld DMEE_MP_SC_FLD Field Name
mp_sc_offset DMEE_MP_SC_OFFSET Source offset
mp_if_tp DMEE_IF_TP DMEE: type of interf
mp_sc_node DMEE_NODEID Node ID
mp_sc_node_attr DMEE_MP_SC_NODE_ATTR Attribute
mp_sc_ref_name DMEE_USED_REF_NAME Refer. Node ID
mp_const DMEE_MP_CONST Constant
cv_rule DMEE_CV_RULE Conv. function
mp_exit_func DMEE_MP_EXIT_FUNC Exit function
mp_selection DMEE_MP_SELECTION Sel. mapping
mp_cuky_tab REFTABLE Reference table
mp_cuky_fld REFFIELD Ref. field
int_data_type DMEE_INTDATATYPE Internal type
tdform_name DMEE_TDFORM_NAME Name in Acc. Sheet
shifted_output DMEE_SHIFTED_OUTPUT DMEE: Delayed Segment Output
segm_end DMEE_SEGM_END End of segment
segm_cr DMEE_SEGM_CR Carriage return
segm_lf DMEE_SEGM_LF Line feed
crlf_only DMEE_CRLF_ONLY Empty Segment for Generating CR/LF
ck_exit_func DMEE_CK_EXIT_FUNC Exit function
react_lev_screen DMEE_REACT_LEV_SCREEN System Response
react_lev_exit DMEE_REACT_LEV_EXIT System Response
msg_class_screen DMEE_MSG_CLASS_SCREEN Message Class
msg_num_screen DMEE_MSG_NUMBER_SCREEN Message Number
msg_class_exit DMEE_MSG_CLASS_EXIT Message Class
msg_num_exit DMEE_MSG_NUMBER_EXIT Message Number
trailer DMEE_TRAILER Trailer Segment
cv_source_format DMEE_CV_SOURCE_FORMAT Source Format
length_in_bytes DMEE_LENGTH_IN_BYTES Length in Bytes
node_redefined DMEE_NODERED Redefined Node
node_deactivated DMEE_NODE_DEACTIVATED Deactivated
var_name DMEE_VARIABLE Variable

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.

-- DMEE: Customer Format Tree Nodes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMEC_TREE_NODE (
    MANDT,             -- Client [MANDT]
    TREE_TYPE,         -- Tree Type [DMEE_TREETYPE]
    TREE_ID,           -- Format Tree [DMEE_TREEID]
    VERSION,           -- Version [DMEE_VERSION]
    NODE_ID,           -- Node ID [DMEE_NODEID]
    TECH_NAME,         -- Node Name [DMEE_TECH_NAME]
    REF_NAME,          -- Reference ID [DMEE_REF_NAME]
    PARENT_ID,         -- Node ID [DMEE_NODEID]
    BROTHER_ID,        -- Node ID [DMEE_NODEID]
    FIRSTCHILD_ID,     -- Node ID [DMEE_NODEID]
    NODE_TYPE,         -- Node type [DMEE_NODETYPE]
    LENGTH,            -- Length [DMEE_LENGTH]
    DATA_TYPE,         -- Type [DMEE_DATA_TYPE]
    EX_STATUS,         -- Status [DMEE_EX_STATUS]
    LEV,               -- Level [DMEE_LEVEL]
    X_COMPLTAB,        -- Entire table [DMEE_X_COMPLTAB]
    TAB_KEYFLD,        -- Key field [DMEE_TABKEYFLD]
    ATOM_HANDL,        -- Atom Handling [DMEE_ATOM_HANDL]
    MP_OFFSET,         -- Target Offset [DMEE_MP_OFFSET]
    MP_SC_TAB,         -- Structure [DMEE_MP_SC_TAB]
    MP_SC_FLD,         -- Field Name [DMEE_MP_SC_FLD]
    MP_SC_OFFSET,      -- Source offset [DMEE_MP_SC_OFFSET]
    MP_IF_TP,          -- DMEE: type of interf [DMEE_IF_TP]
    MP_SC_NODE,        -- Node ID [DMEE_NODEID]
    MP_SC_NODE_ATTR,   -- Attribute [DMEE_MP_SC_NODE_ATTR]
    MP_SC_REF_NAME,    -- Refer. Node ID [DMEE_USED_REF_NAME]
    MP_CONST,          -- Constant [DMEE_MP_CONST]
    CV_RULE,           -- Conv. function [DMEE_CV_RULE]
    MP_EXIT_FUNC,      -- Exit function [DMEE_MP_EXIT_FUNC]
    MP_SELECTION,      -- Sel. mapping [DMEE_MP_SELECTION]
    MP_CUKY_TAB,       -- Reference table [REFTABLE]
    MP_CUKY_FLD,       -- Ref. field [REFFIELD]
    INT_DATA_TYPE,     -- Internal type [DMEE_INTDATATYPE]
    TDFORM_NAME,       -- Name in Acc. Sheet [DMEE_TDFORM_NAME]
    SHIFTED_OUTPUT,    -- DMEE: Delayed Segment Output [DMEE_SHIFTED_OUTPUT]
    SEGM_END,          -- End of segment [DMEE_SEGM_END]
    SEGM_CR,           -- Carriage return [DMEE_SEGM_CR]
    SEGM_LF,           -- Line feed [DMEE_SEGM_LF]
    CRLF_ONLY,         -- Empty Segment for Generating CR/LF [DMEE_CRLF_ONLY]
    CK_EXIT_FUNC,      -- Exit function [DMEE_CK_EXIT_FUNC]
    REACT_LEV_SCREEN,  -- System Response [DMEE_REACT_LEV_SCREEN]
    REACT_LEV_EXIT,    -- System Response [DMEE_REACT_LEV_EXIT]
    MSG_CLASS_SCREEN,  -- Message Class [DMEE_MSG_CLASS_SCREEN]
    MSG_NUM_SCREEN,    -- Message Number [DMEE_MSG_NUMBER_SCREEN]
    MSG_CLASS_EXIT,    -- Message Class [DMEE_MSG_CLASS_EXIT]
    MSG_NUM_EXIT,      -- Message Number [DMEE_MSG_NUMBER_EXIT]
    TRAILER,           -- Trailer Segment [DMEE_TRAILER]
    CV_SOURCE_FORMAT,  -- Source Format [DMEE_CV_SOURCE_FORMAT]
    LENGTH_IN_BYTES,   -- Length in Bytes [DMEE_LENGTH_IN_BYTES]
    NODE_REDEFINED,    -- Redefined Node [DMEE_NODERED]
    NODE_DEACTIVATED,  -- Deactivated [DMEE_NODE_DEACTIVATED]
    VAR_NAME,          -- Variable [DMEE_VARIABLE]
    PRIMARY KEY (MANDT, TREE_TYPE, TREE_ID, VERSION, NODE_ID)
);

Learn More