I_ProcOrdOpsMgmtComponents

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_ProcOrdOpsMgmtComponents.
-- 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: IPRCORDOPCOMPS

CREATE VIEW I_ProcOrdOpsMgmtComponents AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  RecordType,
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  comp.ProcessOrder AS ProcessOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ManufacturingOrderOperation,
  ManufacturingOrderSequence,
  Material,
  MaterialName,
  PlanningPlant,
  MatlCompIsMarkedForBackflush,
  ProductionPlant,
  PlantTimeZone,
  BaseUnit,
  EntryUnit,
  case when aggrComp.RequiredQuantity > 0 then (aggrComp.RequiredQuantity + comp.RequiredQuantity) else comp.RequiredQuantity end as RequiredQuantity AS RequiredQuantityendasRequiredQuantity,
  case when aggrComp.WithdrawnQuantity > 0 then (aggrComp.WithdrawnQuantity + comp.WithdrawnQuantity) else comp.WithdrawnQuantity end as WithdrawnQuantity AS WithdrawnQuantityendasWithdrawnQuantity,
  comp.ConfirmedAvailableQuantity + comp.WithdrawnQuantity AS CommittedQuantity,
  RequirementDateTime,
  MatlCompRequirementDate,
  MatlCompRequirementTime,
  StorageLocation,
  case when aggrComp.NumberOfBatches = 1 and comp.Batch is initial then _spiltCompBatch.Batch else comp.Batch end as Batch AS BatchendasBatch,
  case when aggrComp.NumberOfBatches > 0 then aggrComp.NumberOfBatches else 0 end as NumberOfBatches AS NumberOfBatcheselse0endasNumberOfBatches,
  BatchSplitType,
  MaterialComponentIsMissing,
  ReservationIsFinallyIssued,
  MatlCompIsMarkedForDeletion,
  comp.LeadingReservationItem AS LeadingReservationItem,
  comp.IsBatchManagementRequired AS IsBatchManagementRequired,
  comp.MaterialIsCoProduct AS MaterialIsCoProduct,
  comp.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  comp.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  comp.StorageLocationName AS StorageLocationName,
  ProcOrdCompAvailabilityStsCode,
  comp.StockSegment AS StockSegment,
  comp.RequirementSegment AS RequirementSegment
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]
;