MDC_MODEL_TABLES
Source & Process Data Table Names
MDC_MODEL_TABLES is an SAP database table in S/4HANA. Source & Process Data Table Names. It contains 12 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MDChangeProcessModelTable | view | from | BASIC | Process model table |
| I_MDChangeProcModelSpecialFld | view_entity | inner | BASIC | MDC Model special fields |
| I_MDChangeProcModelTables | view | from | BASIC | MD Change Process Model Table Names |
| I_MDChgProcModelFieldExtension | view | inner | BASIC | MD Model Field Ext |
| I_MDChgProcStepEnrichmentKPI | view | left_outer | BASIC | MD Change Process Step Enrichment KPI |
| I_MDChgProcStepEvaluationKPI | view | left_outer | BASIC | MD Change Process Step Evaluation KPI |
| I_MDQltyModelTable | view | from | BASIC | MDQ Model Table |
| P_MasterDataModelJoin | view_entity | from | BASIC | MDC Model Join |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | bo_type | mdg_object_type_code_bs | Bus. Obj. Type | |||
| KEY | table_name | mdc_table_name | Table | |||
| root_table | mdc_root_table | Root | ||||
| process_data | mdc_process_relevant | Process | ||||
| omit_rules | mdc_omit_rules | Omit Rules | ||||
| allow_brfplus | mdc_brfplus_allowed | BRF+ | ||||
| obscured | mdc_obscured | Hidden | ||||
| switch_id | sfw_switch_id | Switch | ||||
| switch_reaction | sfw_showhide | Reaction to Switch | ||||
| deletion_stance | mdc_deletion_stance | Deletion Stance | ||||
| rule_mining_supported | mdc_rule_mining_supported | Rule Mining | ||||
| records_removable | mdc_remove_unchanged_data | Removable |
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.
-- Source & Process Data Table Names
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_MODEL_TABLES (
BO_TYPE, -- Bus. Obj. Type [mdg_object_type_code_bs]
TABLE_NAME, -- Table [mdc_table_name]
ROOT_TABLE, -- Root [mdc_root_table]
PROCESS_DATA, -- Process [mdc_process_relevant]
OMIT_RULES, -- Omit Rules [mdc_omit_rules]
ALLOW_BRFPLUS, -- BRF+ [mdc_brfplus_allowed]
OBSCURED, -- Hidden [mdc_obscured]
SWITCH_ID, -- Switch [sfw_switch_id]
SWITCH_REACTION, -- Reaction to Switch [sfw_showhide]
DELETION_STANCE, -- Deletion Stance [mdc_deletion_stance]
RULE_MINING_SUPPORTED, -- Rule Mining [mdc_rule_mining_supported]
RECORDS_REMOVABLE, -- Removable [mdc_remove_unchanged_data]
PRIMARY KEY (BO_TYPE, TABLE_NAME)
);
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