MPE_RTG_PVSTAGE

Transparent Table Application Table
25 Fields 1 CDS Views

Production Version Staging Table

MPE_RTG_PVSTAGE is an SAP database table in S/4HANA. Production Version Staging Table. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdnVersStaging view from BASIC Production Version Staging Basic View

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY guid SYSUUID_X16 UUID
matnr MATNR Material
werks WERKS_D Plant
verid VERID Prod. Version
text1 VERS_TEXT Prodn Version Text
plnty PLNTY Task List Type
plnnr MPE_RTG_ROUTING_GROUP Routing Group
plnal PLNAL Group Counter
versn PLNVERSN Routing Version
stlty STLTY BOM category
stlan STLAN Usage
stlnr STNUM BOM
stlal STALT Alternative
bstmi SA_LOSVN From Lot Size
bstma SA_LOSBS To Lot Size
adatu ADATM Valid from
bdatu BDATM Valid To
mksp MKSP Prodn Version Lock
validitystartdate VDM_V_VALIDITY_START_DATE Validity Start Date
validityenddate VDM_V_VALIDITY_END_DATE Validity End Date
bom_versn CS_VERSN BOM Version
zuonr CIM_ZUORD Allocation no.
plnme MPE_RTG_UNIT Unit
isnew CHAR1 Single-Character Flag

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 Version Staging Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_RTG_PVSTAGE (
    MANDT,              -- Client [MANDT]
    GUID,               -- UUID [SYSUUID_X16]
    MATNR,              -- Material [MATNR]
    WERKS,              -- Plant [WERKS_D]
    VERID,              -- Prod. Version [VERID]
    TEXT1,              -- Prodn Version Text [VERS_TEXT]
    PLNTY,              -- Task List Type [PLNTY]
    PLNNR,              -- Routing Group [MPE_RTG_ROUTING_GROUP]
    PLNAL,              -- Group Counter [PLNAL]
    VERSN,              -- Routing Version [PLNVERSN]
    STLTY,              -- BOM category [STLTY]
    STLAN,              -- Usage [STLAN]
    STLNR,              -- BOM [STNUM]
    STLAL,              -- Alternative [STALT]
    BSTMI,              -- From Lot Size [SA_LOSVN]
    BSTMA,              -- To Lot Size [SA_LOSBS]
    ADATU,              -- Valid from [ADATM]
    BDATU,              -- Valid To [BDATM]
    MKSP,               -- Prodn Version Lock [MKSP]
    VALIDITYSTARTDATE,  -- Validity Start Date [VDM_V_VALIDITY_START_DATE]
    VALIDITYENDDATE,    -- Validity End Date [VDM_V_VALIDITY_END_DATE]
    BOM_VERSN,          -- BOM Version [CS_VERSN]
    ZUONR,              -- Allocation no. [CIM_ZUORD]
    PLNME,              -- Unit [MPE_RTG_UNIT]
    ISNEW,              -- Single-Character Flag [CHAR1]
    PRIMARY KEY (MANDT, GUID)
);

Learn More