I_ProdnVersStaging

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProdnVersStaging.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPRODNVERSSTG

CREATE VIEW I_ProdnVersStaging AS
SELECT
  guid AS DraftUUID,
  matnr AS Material,
  werks AS Plant,
  verid AS ProductionVersion,
  text1 AS ProductionVersionText,
  plnty AS BillOfOperationsType,
  plnnr AS BillOfOperationsGroup,
  plnal AS BillOfOperationsVariant,
  versn AS BillOfOperationsVersion,
  stlty AS BillOfMaterialCategory,
  stlan AS BillOfMaterialVariantUsage,
  stlnr AS BillOfMaterial,
  stlal AS BillOfMaterialVariant,
  bstmi AS MaterialMinLotSizeQuantity,
  bstma AS MaterialMaxLotSizeQuantity,
  adatu AS ValidFrom,
  bdatu AS ValidTo,
  mksp AS ProductionVersionIsLocked,
  ValidityStartDate,
  ValidityEndDate,
  bom_versn AS BillOfMaterialVersion,
  zuonr AS ProdnRtgVersBOMInternalID,
  plnme AS BillOfOperationsUnit,
  isnew AS IsReadOnly
FROM mpe_rtg_pvstage
LEFT OUTER JOIN I_ProductText AS _MaterialText ON Material = _MaterialText.Product  -- association [0..*]
;