| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 2 | TREE_ID | DMEE: unique description for a DMEE format tree | nvarchar | 30 | 0 | | | | Allow NULL? |
| 3 | VERSION | DMEE: version of format tree | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | NODE_ID | DMEE: node ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | TECH_NAME | DMEE: node name for format tree node | nvarchar | 50 | 0 | | | | Allow NULL? |
| 6 | REF_NAME | DMEE: unique node identification for referencing purposes | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | PARENT_ID | DMEE: node ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | BROTHER_ID | DMEE: node ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | FIRSTCHILD_ID | DMEE: node ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | NODE_TYPE | DMEE: node type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | LENGTH | DMEE: length of DMEE node | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | DATA_TYPE | DMEE: data type of DMEE node | char | 1 | 0 | | | | Allow NULL? |
| 13 | EX_STATUS | DMEE: existence status of a format tree node | char | 1 | 0 | | | | Allow NULL? |
| 14 | LEV | DMEE: level of a format object | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | X_COMPLTAB | DMEE: loop starts with the first line of internal table | char | 1 | 0 | | | | Allow NULL? |
| 16 | TAB_KEYFLD | DMEE: key field of internal table | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | ATOM_HANDL | DMEE: Handling of Different Atoms for an Element | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | MP_OFFSET | DMEE: offset of a format object in target field | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | MP_SC_TAB | DMEE: name of DDIC structure for source field | nvarchar | 30 | 0 | | | | Allow NULL? |
| 20 | MP_SC_FLD | DMEE: name of a source field | nvarchar | 30 | 0 | | | | Allow NULL? |
| 21 | MP_SC_OFFSET | DMEE: mapping offset in source field | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | MP_IF_TP | DMEE: type of interface that source struct. originates from | char | 1 | 0 | | | | Allow NULL? |
| 23 | MP_SC_NODE | DMEE: node ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | MP_SC_NODE_ATTR | DMEE: node attribute that serves as source value | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | MP_SC_REF_NAME | DMEE: reference ID of the referenced node | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | MP_CONST | DMEE: constant as a source value | nvarchar | 132 | 0 | | | | Allow NULL? |
| 27 | CV_RULE | DMEE: internal conversion function | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | MP_EXIT_FUNC | DMEE: name of mapping exit function module | nvarchar | 30 | 0 | | | | Allow NULL? |
| 29 | MP_SELECTION | DMEE: selected mapping procedure | char | 1 | 0 | | | | Allow NULL? |
| 30 | MP_CUKY_TAB | Table for reference field | nvarchar | 30 | 0 | | | | Allow NULL? |
| 31 | MP_CUKY_FLD | Reference field for currency and qty fields | nvarchar | 30 | 0 | | | | Allow NULL? |
| 32 | INT_DATA_TYPE | DMEE: internal type (A: currency amount; SPACE: other) | char | 1 | 0 | | | | Allow NULL? |
| 33 | TDFORM_NAME | DMEE: name of node in SAPscript form | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | SHIFTED_OUTPUT | DMEE: Delayed Segment Output | char | 1 | 0 | | | | Allow NULL? |
| 35 | SEGM_END | DMEE: Rule for Closing a Segment | char | 1 | 0 | | | | Allow NULL? |
| 36 | SEGM_CR | Segments are separated by carriage return | char | 1 | 0 | | | | Allow NULL? |
| 37 | SEGM_LF | Segments are separated by line feed | char | 1 | 0 | | | | Allow NULL? |
| 38 | CRLF_ONLY | DMEE: Empty Segment for Generating CR/LF Only | char | 1 | 0 | | | | Allow NULL? |
| 39 | CK_EXIT_FUNC | DMEE: Name of CHECK Exit Function Module | nvarchar | 30 | 0 | | | | Allow NULL? |
| 40 | REACT_LEV_SCREEN | DMEE: System Response for Configurable Check | char | 1 | 0 | | | | Allow NULL? |
| 41 | REACT_LEV_EXIT | DMEE: System Response for Exit-Module Check | char | 1 | 0 | | | | Allow NULL? |
| 42 | MSG_CLASS_SCREEN | DMEE: Message Class for Response (Configurable Check) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 43 | MSG_NUM_SCREEN | DMEE: Message Number for Response (Configurable Check) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 44 | MSG_CLASS_EXIT | DMEE: Message Class for Response (Exit) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 45 | MSG_NUM_EXIT | DMEE: Message Number for Response (Exit) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | TRAILER | DMEE: Trailer Segment for Closing Data Record | char | 1 | 0 | | | | Allow NULL? |
| 47 | CV_SOURCE_FORMAT | DMEE: Source Format at Conversion (Incoming Files) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | LENGTH_IN_BYTES | Length in Bytes | char | 1 | 0 | | | | Allow NULL? |