MPE_RTG_PVSTAGE

Transparent Table Application Table

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)
);