P_ProcOrdMgmtOpCompWithSts2

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_ProcOrdMgmtOpCompWithSts2.
-- 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: PPOROPCOMPSTSN

CREATE VIEW P_ProcOrdMgmtOpCompWithSts2 AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.RecordType AS RecordType,
  comp.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  comp.ManufacturingOrderType AS ManufacturingOrderType,
  comp.ManufacturingOrder AS ManufacturingOrder,
  comp.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  comp.ProductionPlant AS ProductionPlant,
  comp.ProductionSupervisor AS ProductionSupervisor,
  comp.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  comp.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  case when _AvNotChecked.StatusCode is null then '' else 'X' end AS MaterialAvailyIsNotChecked,
  comp.MatlCompRequirementDate AS MatlCompRequirementDate,
  comp.MatlCompRequirementTime AS MatlCompRequirementTime,
  comp.ReservationItemCreationCode AS ReservationItemCreationCode,
  comp.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  comp.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  comp.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  comp.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  comp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  comp.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  comp.MatlCompIsTextItem AS MatlCompIsTextItem,
  comp.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  comp.MatlCompIsConfigurable AS MatlCompIsConfigurable,
  comp.MaterialCompIsCostRelevant AS MaterialCompIsCostRelevant,
  comp.MaterialComponentIsClassified AS MaterialComponentIsClassified,
  comp.MaterialCompIsIntraMaterial AS MaterialCompIsIntraMaterial,
  comp.UsageProbabilityPercent AS UsageProbabilityPercent,
  comp.LongTextLanguageCode AS LongTextLanguageCode,
  comp.LongTextExists AS LongTextExists,
  comp.RequirementType AS RequirementType,
  comp.MaterialGroup AS MaterialGroup,
  comp.Material AS Material,
  comp.Plant AS Plant,
  cast(_MaterialPlant.MRPController as pph_dispo preserving type) AS MRPController,
  comp.SalesOrder AS SalesOrder,
  comp.SalesOrderItem AS SalesOrderItem,
  comp.WBSElementInternalID AS WBSElementInternalID,
  comp.ProductConfiguration AS ProductConfiguration,
  comp.ChangeNumber AS ChangeNumber,
  comp.EffectivityParameterVariant AS EffectivityParameterVariant,
  comp.BillOfMaterialCategory AS BillOfMaterialCategory,
  comp.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  comp.BillOfMaterialVariant AS BillOfMaterialVariant,
  comp.BOMItem AS BillOfMaterialItemNodeNumber,
  comp.BOMItemCategory AS BillOfMaterialItemCategory,
  comp.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  comp.BOMItemDescription AS BOMItemDescription,
  comp.BOMExplosionDateID AS BOMExplosionDateID,
  comp.PurchasingInfoRecord AS PurchasingInfoRecord,
  comp.PurchasingGroup AS PurchasingGroup,
  comp.DeliveryDurationInDays AS DeliveryDurationInDays,
  comp.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  comp.StorageLocation AS StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  comp.Batch AS Batch,
  comp.BatchSplitType AS BatchSplitType,
  comp.DebitCreditCode AS DebitCreditCode,
  comp.GoodsMovementType AS GoodsMovementType,
  comp.InventorySpecialStockType AS InventorySpecialStockType,
  comp.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  comp.ConsumptionPosting AS ConsumptionPosting,
  comp.SupplyArea AS SupplyArea,
  comp.GoodsRecipientName AS GoodsRecipientName,
  comp.UnloadingPointName AS UnloadingPointName,
  comp.StockSegment AS StockSegment,
  comp.RequirementSegment AS RequirementSegment,
  comp.Warehouse AS Warehouse,
  comp.StorageType AS StorageType,
  comp.StorageBin AS StorageBin,
  comp.BusinessArea AS BusinessArea,
  comp.CompanyCode AS CompanyCode,
  comp.GLAccount AS GLAccount,
  comp.AccountAssignmentCategory AS AccountAssignmentCategory,
  comp.FunctionalArea AS FunctionalArea,
  comp.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  comp.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  comp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  comp.FormulaKey AS FormulaKey,
  comp.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  comp.OrderPathValue AS OrderPathValue,
  comp.OrderLevelValue AS OrderLevelValue,
  _BillOfMaterialItem.MaterialIsCoProduct AS MaterialIsCoProduct,
  _Material.IsBatchManagementRequired AS IsBatchManagementRequired,
  comp.LeadTimeOffset AS LeadTimeOffset,
  comp.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  comp.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  comp.QuantityIsFixed AS QuantityIsFixed,
  comp.IsNetScrap AS IsNetScrap,
  comp.ComponentScrapInPercent AS ComponentScrapInPercent,
  comp.OperationScrapInPercent AS OperationScrapInPercent,
  comp.BaseUnit AS BaseUnit,
  cast(comp.RequiredQuantity as requirementquantity preserving type) AS RequiredQuantity,
  comp.WithdrawnQuantity AS WithdrawnQuantity,
  (comp.RequiredQuantity - comp.WithdrawnQuantity) AS OpenQuantity,
  cast((comp.WithdrawnQuantity - comp.RequiredQuantity) as deviationquantity) AS DeviationQuantity,
  comp.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  comp.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  comp.EntryUnit AS EntryUnit,
  comp.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  comp.LeadingReservationItem AS LeadingReservationItem
FROM I_ProcOrdMgmtOpCompBasic AS comp
INNER JOIN P_ProcOrdAORListDistinct AS _AORList ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProcOrdFirstOperation AS _FirstOperation ON ManufacturingOrder = _FirstOperation.ProcessOrder AND ProductionPlant = _FirstOperation.ProductionPlant AND ProductionSupervisor = _FirstOperation.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _RequirementDate ON MatlCompRequirementDate = _RequirementDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Plant = _MaterialPlant.Plant AND Material = _MaterialPlant.Material  -- association [0..1]
LEFT OUTER JOIN P_ProcOrderOperationDurn AS _OperationDetails ON ManufacturingOrder = _OperationDetails.ManufacturingOrder AND ManufacturingOrderOperation = _OperationDetails.ManufacturingOrderOperation AND ProductionPlant = _OperationDetails.ProductionPlant AND ProductionSupervisor = _OperationDetails.ProductionSupervisor  -- association [0..1]
;