I_ProcOrdMgmtOpCompAggrgn

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_ProcOrdMgmtOpCompAggrgn.
-- 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: IPOROPCOMPAGGRGN

CREATE VIEW I_ProcOrdMgmtOpCompAggrgn AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.RecordType AS RecordType,
  comp.ProcessOrder AS ProcessOrder,
  comp.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  comp.ManufacturingOrderType AS ManufacturingOrderType,
  cast(comp.ManufacturingOrderOperation as processorderoperation preserving type) AS ManufacturingOrderOperation,
  comp.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  comp.Material AS Material,
  comp.MaterialName AS MaterialName,
  comp.PlanningPlant AS PlanningPlant,
  comp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  comp.ProductionPlant AS ProductionPlant,
  comp.ProductionPlantName AS ProductionPlantName,
  comp.PlantTimeZone AS PlantTimeZone,
  comp.BaseUnit AS BaseUnit,
  comp.EntryUnit AS EntryUnit,
  case when aggrComp.RequiredQuantity > 0 then (aggrComp.RequiredQuantity + comp.RequiredQuantity) else comp.RequiredQuantity end as RequiredQuantity AS RequiredQuantityendasRequiredQuantity,
  comp.MatlCompRequirementDate AS MatlCompRequirementDate,
  comp.MatlCompRequirementTime AS MatlCompRequirementTime,
  comp.ProcOrdCompAvailabilityStsCode AS ProcOrdCompAvailabilityStsCode,
  comp.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  comp.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  comp.StorageLocation AS StorageLocation,
  comp.StorageLocationName AS StorageLocationName,
  comp.MaterialIsCoProduct AS MaterialIsCoProduct,
  comp.StockSegment AS StockSegment,
  comp.RequirementSegment AS RequirementSegment,
  case when aggrComp.NumberOfBatches = 1 and comp.Batch is initial then _spiltCompBatch.Batch else comp.Batch end as Batch AS BatchendasBatch,
  comp.BatchSplitType AS BatchSplitType,
  comp.IsBatchManagementRequired AS IsBatchManagementRequired,
  comp.LeadingReservationItem AS LeadingReservationItem,
  case when aggrComp.NumberOfBatches > 0 then aggrComp.NumberOfBatches else 0 end as NumberOfBatches AS NumberOfBatcheselse0endasNumberOfBatches,
  comp.MaterialAvailyIsNotChecked AS MaterialAvailyIsNotChecked,
  comp.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  comp.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  comp.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  comp.BillOfMaterialItemNumber AS BillOfMaterialItemNumber
FROM P_ProcOrdMgmtOpComponents AS comp
LEFT OUTER JOIN P_ProcOrdMgmtOpCompSpltBat_2 AS _spiltCompBatch ON comp.Reservation = _spiltCompBatch.Reservation AND comp.ProcessOrder = _spiltCompBatch.ProcessOrder AND comp.ReservationItem = _spiltCompBatch.LeadingReservationItem  -- association [0..1]
;