MDC_MODEL_TJOIN

Transparent Table Control Table (SAP+Cust)
5 Fields 1 CDS Views

Model Table Joins

MDC_MODEL_TJOIN is an SAP database table in S/4HANA. Model Table Joins. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQltyModelTableHierNode view_entity from COMPOSITE Hierarchy Node for Model Table

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY otc MDG_OBJECT_TYPE_CODE_BS Bus. Obj. Type
KEY left_table MDC_TABLE_NAME Table
KEY right_table MDC_TABLE_NAME Table
process_data MDC_PROCESS_RELEVANT Process
active_data MDC_ACTIVE_DATA Active

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.

-- Model Table Joins
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_MODEL_TJOIN (
    OTC,           -- Bus. Obj. Type [MDG_OBJECT_TYPE_CODE_BS]
    LEFT_TABLE,    -- Table [MDC_TABLE_NAME]
    RIGHT_TABLE,   -- Table [MDC_TABLE_NAME]
    PROCESS_DATA,  -- Process [MDC_PROCESS_RELEVANT]
    ACTIVE_DATA,   -- Active [MDC_ACTIVE_DATA]
    PRIMARY KEY (OTC, LEFT_TABLE, RIGHT_TABLE)
);

Learn More