C_Operationcomponents

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_Operationcomponents.
-- 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: CMPEOPERCOMPNTS

CREATE VIEW C_Operationcomponents AS
SELECT
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.RecordType AS RecordType,
  comp.ManufacturingOrder AS ManufacturingOrder,
  comp.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  comp.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  comp.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  comp.ProductionPlant AS ProductionPlant,
  comp.Plant AS Plant,
  comp.StorageLocation AS StorageLocation,
  comp.InventorySpecialStockType AS InventorySpecialStockType,
  _ProductionPlant.PlantName AS ProductionPlantName,
  comp.BaseUnit AS BaseUnit,
  comp.RequiredQuantity AS RequiredQuantity,
  comp.WithdrawnQuantity AS WithdrawnQuantity,
  case when comp.ReservationIsFinallyIssued = 'X' or comp.OrderIsTechnicallyCompleted = 'X' or comp.OrderIsClosed = 'X' or comp.OrderIsDeleted = 'X' or comp.OrderIsMarkedForDeletion = 'X' or (comp.OpenQuantity < 0) then 0 when (comp.ConfirmedAvailableQuantity > comp.WithdrawnQuantity) then (cast((comp.OpenQuantity-comp.ConfirmedAvailableQuantity+comp.WithdrawnQuantity) as pph_enmng)) else comp.OpenQuantity end as UncoveredQuantity AS OpenQuantityendasUncoveredQuantity,
  case when comp.ReservationIsFinallyIssued = 'X' or comp.OrderIsTechnicallyCompleted = 'X' or comp.OrderIsClosed = 'X' or comp.OrderIsDeleted = 'X' or comp.OrderIsMarkedForDeletion = 'X' or (comp.OpenQuantity < 0) then 0 else comp.OpenQuantity end as OpenQuantity AS OpenQuantityendasOpenQuantity,
  (comp.RequiredQuantity-comp.ConfirmedAvailableQuantity) AS MissingQuantity,
  _Aggr.MatlWrhsStkQtyInMatlBaseUnit AS SupplyAreaAvailableQuantity,
  comp.EffectivityParameterVariant AS EffectivityParameterVariant,
  comp.Assembly AS Assembly,
  comp.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  comp.SupplyArea AS SupplyArea,
  _MRPController.MRPControllerName AS MRPControllerName,
  comp.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  comp.MatlCompRequirementDate AS MatlCompRequirementDate,
  comp.MatlCompRequirementTime AS MatlCompRequirementTime,
  comp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  comp.Batch AS Batch,
  comp.ComponentScrapInPercent AS ComponentScrapInPercent,
  comp.IsNetScrap AS IsNetScrap,
  comp.OperationScrapInPercent AS OperationScrapInPercent,
  comp.EntryUnit AS EntryUnit,
  comp.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  comp.QuantityIsFixed AS QuantityIsFixed,
  comp.BOMItemDescription AS BOMItemDescription,
  comp.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  comp.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  comp.ManufacturingOrderType AS ManufacturingOrderType,
  comp.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  comp.DebitCreditCode AS DebitCreditCode,
  comp.BillOfMaterialCategory AS BillOfMaterialCategory,
  comp.BillOfMaterial AS BillOfMaterial,
  comp.BillOfMaterialVariant AS BillOfMaterialVariant,
  comp.BillOfMaterialVersion AS BillOfMaterialVersion,
  comp.InheritedBOMItemNode AS InheritedBOMItemNode,
  comp.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  comp.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  comp.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  comp.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _ItemCategoryT.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  _MfgOrdCompMfgRefStruc.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  _MfgOrdCompMfgRefStruc.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  _MfgOrdCompMfgRefStruc.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  cast(comp._ProductionPlant._Address.AddressTimeZone as co_plant_timezone ) AS PlantTimeZone,
  _PhantomFlag.MfgBOMItemIsPhantomChild AS MfgBOMItemIsPhantomChild,
  _MfgOrdCompMfgRefStruc._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  _MfgOrdCompMfgRefStruc._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails
FROM I_MfgOrderOperationCompWithSts AS comp
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_Materialaggr AS _Aggr ON Material = _Aggr.Material AND ProductionPlant = _Aggr.Plant AND StorageLocation = _Aggr.StorageLocation AND InventorySpecialStockType = _Aggr.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItemExtension.BillOfMaterial AND BillOfMaterialItemNodeNumber = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN P_MfgOrdCompMfgRefStruc AS _MfgOrdCompMfgRefStruc ON Reservation = _MfgOrdCompMfgRefStruc.Reservation AND ReservationItem = _MfgOrdCompMfgRefStruc.ReservationItem AND RecordType = _MfgOrdCompMfgRefStruc.RecordType  -- association [0..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _ItemCategoryT ON BillOfMaterialItemCategory = _ItemCategoryT.BillOfMaterialItemCategory AND _ItemCategoryT.Language = $session.system_language AND _ItemCategoryT.BillOfMaterialItemCategory <> 'D'  -- association [0..1]
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _PhantomFlag ON BillOfMaterialCategory = _PhantomFlag.MfgBillOfMaterialCategory AND BillOfMaterial = _PhantomFlag.MfgBillOfMaterial AND BillOfMaterialVariant = _PhantomFlag.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _PhantomFlag.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _PhantomFlag.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
;