DMC_STREE

Transparent Table System Table (transport)

DMC:Baumstruktur zur Verwaltung von Strukturen

DMC_STREE is an SAP database table in S/4HANA. DMC:Baumstruktur zur Verwaltung von Strukturen. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
/ltb/aifm_i_target_table view_entity inner AI Mapping Target Table
/ltb/aifm_i_target_table_assoc view_entity inner Foreign Key Relations

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY guid dmc_stree_guid GUID StructNode
KEY container dmc_container_guid Container GUID
KEY stype dmc_srtype Sender/receiver
seqnum dmc_seqno Position
ident dmc_stidt Tree Structure
struct dmc_struct_guid GUID Structure
filedesc guid_22 GUID 22
prec guid_22 GUID 22
versio dmc_versio Version Number
chnam syuname User Name
struclevel dmc_slevel Level
parentid guid_22 GUID 22
changedate sydatum Current Date
author syuname User Name
createdate sydatum Current Date
descr dmc_descr Description
refname dmc_refnm Reference
stree_type dmc_stree_type STREE type

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.

-- DMC:Baumstruktur zur Verwaltung von Strukturen
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMC_STREE (
    GUID,        -- GUID StructNode [dmc_stree_guid]
    CONTAINER,   -- Container GUID [dmc_container_guid]
    STYPE,       -- Sender/receiver [dmc_srtype]
    SEQNUM,      -- Position [dmc_seqno]
    IDENT,       -- Tree Structure [dmc_stidt]
    STRUCT,      -- GUID Structure [dmc_struct_guid]
    FILEDESC,    -- GUID 22 [guid_22]
    PREC,        -- GUID 22 [guid_22]
    VERSIO,      -- Version Number [dmc_versio]
    CHNAM,       -- User Name [syuname]
    STRUCLEVEL,  -- Level [dmc_slevel]
    PARENTID,    -- GUID 22 [guid_22]
    CHANGEDATE,  -- Current Date [sydatum]
    AUTHOR,      -- User Name [syuname]
    CREATEDATE,  -- Current Date [sydatum]
    DESCR,       -- Description [dmc_descr]
    REFNAME,     -- Reference [dmc_refnm]
    STREE_TYPE,  -- STREE type [dmc_stree_type]
    PRIMARY KEY (GUID, CONTAINER, STYPE)
);