DMEE_TREE_NODE
DMEE: Format Tree Nodes
DMEE_TREE_NODE is an SAP database table in S/4HANA. DMEE: Format Tree Nodes. It contains 48 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DataMdmExchNode | view_entity | from | BASIC | DMEE Node |
Fields (48)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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: Format Tree Nodes
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMEE_TREE_NODE (
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]
PRIMARY KEY (TREE_TYPE, TREE_ID, VERSION, NODE_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA