DMEC_TREE_SORT

Transparent Table Customizing Table
13 Fields 1 CDS Views

DMEE: Customer Sort and Key Fields for Format

DMEC_TREE_SORT is an SAP database table in S/4HANA. DMEE: Customer Sort and Key Fields for Format. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DataMdmExchCustDataSorting view_entity from BASIC DMEE Customer Tree Data Sorting

Fields (13)

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 sort_order dmee_sort_order Sequence
key_field dmee_key_field Key field
sort_tab dmee_sort_tab Structure
sort_fld dmee_sort_fld Sort Field
sort_if_tp dmee_if_tp DMEE: type of interf
user_field dmee_user_field User field
lev dmee_level Level
kf_exit_func dmee_kf_exit_func Exit function
key_only dmee_key_only No Sorting

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 Sort and Key Fields for Format
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMEC_TREE_SORT (
    MANDT,         -- Client [mandt]
    TREE_TYPE,     -- Tree Type [dmee_treetype]
    TREE_ID,       -- Format Tree [dmee_treeid]
    VERSION,       -- Version [dmee_version]
    SORT_ORDER,    -- Sequence [dmee_sort_order]
    KEY_FIELD,     -- Key field [dmee_key_field]
    SORT_TAB,      -- Structure [dmee_sort_tab]
    SORT_FLD,      -- Sort Field [dmee_sort_fld]
    SORT_IF_TP,    -- DMEE: type of interf [dmee_if_tp]
    USER_FIELD,    -- User field [dmee_user_field]
    LEV,           -- Level [dmee_level]
    KF_EXIT_FUNC,  -- Exit function [dmee_kf_exit_func]
    KEY_ONLY,      -- No Sorting [dmee_key_only]
    PRIMARY KEY (MANDT, TREE_TYPE, TREE_ID, VERSION, SORT_ORDER)
);

Learn More