MPE_PMDL_HDR

Transparent Table Application Table
19 Fields 4 CDS Views

Production Model Header

MPE_PMDL_HDR is an SAP database table in S/4HANA. Production Model Header. It contains 19 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProdnModOpActyCompBasic view_entity from BASIC OAC Keys and basic data
I_ProdnModOpActyCompInstceBsc view_entity from BASIC OACI Keys and basic data
I_ProdnModOpComponentBasic view_entity from BASIC Op Comp Keys and basic data
I_ProductionModelBasic view_entity from BASIC Production Model Header

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prodn_model_uuid MPE_PMDL_UUID Prodn Model UUID
process_type MPE_PMDL_PROCESS_TYPE Process Type
prodn_model_type MPE_PMDL_TYPE Prod. Model Type
material MATNR40 Material
stlnr STNUM BOM
stlal STLAL AlternativeBOM
stlty STLTY BOM category
stlan STLAN Usage
werks WERKS_D Plant
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
salesorder CS_VBELN Sales Order
salesorder_item CS_VBPOS Item
created_on MPE_PMDL_CREATED_ON Created On
created_by MPE_PMDL_CREATED_BY Created By
changed_on MPE_PMDL_CHANGED_ON Changed On
changed_by MPE_PMDL_CHANGED_BY Changed By

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.

-- Production Model Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_PMDL_HDR (
    MANDT,             -- Client [MANDT]
    PRODN_MODEL_UUID,  -- Prodn Model UUID [MPE_PMDL_UUID]
    PROCESS_TYPE,      -- Process Type [MPE_PMDL_PROCESS_TYPE]
    PRODN_MODEL_TYPE,  -- Prod. Model Type [MPE_PMDL_TYPE]
    MATERIAL,          -- Material [MATNR40]
    STLNR,             -- BOM [STNUM]
    STLAL,             -- AlternativeBOM [STLAL]
    STLTY,             -- BOM category [STLTY]
    STLAN,             -- Usage [STLAN]
    WERKS,             -- Plant [WERKS_D]
    PLNTY,             -- Task List Type [PLNTY]
    PLNNR,             -- Group [PLNNR]
    PLNAL,             -- Group Counter [PLNAL]
    SALESORDER,        -- Sales Order [CS_VBELN]
    SALESORDER_ITEM,   -- Item [CS_VBPOS]
    CREATED_ON,        -- Created On [MPE_PMDL_CREATED_ON]
    CREATED_BY,        -- Created By [MPE_PMDL_CREATED_BY]
    CHANGED_ON,        -- Changed On [MPE_PMDL_CHANGED_ON]
    CHANGED_BY,        -- Changed By [MPE_PMDL_CHANGED_BY]
    PRIMARY KEY (MANDT, PRODN_MODEL_UUID)
);

Learn More