DMC_STREE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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