P_ProcOrdMgmtOpComponents

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 P_ProcOrdMgmtOpComponents.
-- 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: PPORMGMTOPCOMP

CREATE VIEW P_ProcOrdMgmtOpComponents AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.RecordType AS RecordType,
  comp.ManufacturingOrder AS ProcessOrder,
  comp.Material AS Material,
  comp.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  comp.ManufacturingOrderType AS ManufacturingOrderType,
  comp.ProductionPlant AS ProductionPlant,
  _ProductionPlant.PlantName AS ProductionPlantName,
  cast( _ProductionPlant._OrganizationAddress[AddressRepresentationCode = ''].AddressTimeZone as co_plant_timezone ) AS PlantTimeZone,
  comp.ProductionSupervisor AS ProductionSupervisor,
  OrderInternalBillOfOperations,
  ManufacturingOrderOperation,
  comp.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  comp.BOMItemDescription AS BOMItemDescription,
  case when _MaterialText.MaterialName is null or _MaterialText.MaterialName = '' then comp.BOMItemDescription else _MaterialText.MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  comp.BaseUnit AS BaseUnit,
  comp.RequiredQuantity AS RequiredQuantity,
  comp.EntryUnit AS EntryUnit,
  comp.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  comp.WithdrawnQuantity AS WithdrawnQuantity,
  MatlCompRequirementDate,
  MatlCompRequirementTime,
  StorageLocation,
  StorageLocationName,
  MaterialIsCoProduct,
  BillOfMaterialItemCategory,
  _BOMItemCategory.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  comp.MaterialAvailyIsNotChecked AS MaterialAvailyIsNotChecked,
  MaterialComponentIsMissing,
  ReservationIsFinallyIssued,
  comp.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  Batch,
  BatchSplitType,
  IsBatchManagementRequired,
  LeadingReservationItem,
  Plant AS PlanningPlant,
  StockSegment,
  RequirementSegment
FROM P_ProcOrdMgmtOpCompWithSts2 AS comp
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
;