MPE_RTG_PVSTAGE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProdnVersStaging | view | from | BASIC | Production Version Staging Basic View |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- 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