C_MfgOrderProdVersionObjPg

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 C_MfgOrderProdVersionObjPg.
-- 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.

CREATE VIEW C_MfgOrderProdVersionObjPg AS
SELECT
  Material,
  Plant,
  ProductionVersion,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  I_ProductionVersion._Plant.PlantName AS PlantName,
  ProductionVersionText,
  ProductionVersionIsLocked,
  ChangeNumber,
  MaterialBaseUnit,
  MaterialMinLotSizeQuantity,
  MaterialMaxLotSizeQuantity,
  ValidityStartDate,
  ValidityEndDate,
  cast(BillOfOperationsType as plnty preserving type ) AS BillOfOperationsType,
  cast(BillOfOperationsGroup as plnnr preserving type) AS BillOfOperationsGroup,
  cast(BillOfOperationsVariant as plnal) AS BillOfOperationsVariant,
  BillOfMaterialVariantUsage,
  i_billofmaterialusage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  BillOfMaterialVariant,
  MaterialCostApportionmentStruc,
  ProdnVersIsAllowedForRptvMfg,
  ProductionLine,
  ProductionVersionGroup,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MainProduct,
  IssuingStorageLocation,
  ReceivingStorageLocation,
  OriginalBatchReferenceMaterial,
  ProductionSupplyArea
FROM I_ProductionVersion
LEFT OUTER JOIN I_BillOfMaterialUsage ON BillOfMaterialVariantUsage = I_BillOfMaterialUsage.BillOfMaterialVariantUsage  -- association [1..1]
LEFT OUTER JOIN I_Material AS _OtherMaterial ON MainProduct = _OtherMaterial.Material  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _IssuingStorageLocation ON IssuingStorageLocation = _IssuingStorageLocation.StorageLocation AND Plant = _IssuingStorageLocation.Plant  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _ReceivingStorageLocation ON ReceivingStorageLocation = _ReceivingStorageLocation.StorageLocation AND Plant = _ReceivingStorageLocation.Plant  -- association [1..1]
;