I_MfgOrderOperationCompCube

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_MfgOrderOperationCompCube.
-- 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: IPPMFGORDOPCOMPC

CREATE VIEW I_MfgOrderOperationCompCube 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.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  comp.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation_2,
  comp.ProductionPlant AS ProductionPlant,
  comp.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  comp.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  comp.AssemblyMRPController AS AssemblyMRPController,
  comp.ProductionSupervisor AS ProductionSupervisor,
  comp.MatlCompRequirementDate AS MatlCompRequirementDate,
  comp.MatlCompRequirementTime AS MatlCompRequirementTime,
  repdate.ReportingDateWeekDay AS RequirementDateWeekDay,
  repdate.ReportingDateWeek AS RequirementDateWeek,
  repdate.ReportingDateMonth AS RequirementDateMonth,
  repdate.ReportingDateYear AS RequirementDateYear,
  cast(concat(repdate.ReportingDateYear, repdate.ReportingDateMonth) as vdm_yearmonth) AS RequirementDateYearMonth,
  cast(repdate.ReportingPeriod as pph_reportingperiod preserving type) AS ReportingPeriod,
  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,
  cast('X' as xfeld preserving type) AS OrderIsReleased,
  cast(' ' as xfeld preserving type) AS OrderIsConfirmed,
  cast(' ' as xfeld preserving type) AS OrderIsDeleted,
  cast(' ' as xfeld preserving type) AS OrderIsTechnicallyCompleted,
  cast(' ' as xfeld preserving type) AS OrderIsClosed,
  cast(' ' as xfeld preserving type) AS OrderIsMarkedForDeletion,
  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.WBSElementInternalID_2 AS WBSElementInternalID_2,
  comp.ProductConfiguration AS ProductConfiguration,
  comp.ChangeNumber AS ChangeNumber,
  comp.EffectivityParameterVariant AS EffectivityParameterVariant,
  comp.SortField AS SortField,
  comp.MaterialComponentSortText AS MaterialComponentSortText,
  comp.BillOfMaterialCategory AS BillOfMaterialCategory,
  comp.BillOfMaterialInternalID_2 AS BillOfMaterialInternalID,
  comp.BillOfMaterialVariant AS BillOfMaterialVariant,
  comp.BOMItem AS BillOfMaterialItemNodeNumber,
  comp.BOMItemCategory AS BillOfMaterialItemCategory,
  comp.BillOfMaterialItemNumber_2 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,
  comp.Batch AS Batch,
  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.BatchSplitType AS BatchSplitType,
  comp.BatchMasterReservationItem AS BatchMasterReservationItem,
  comp.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  cast(comp.NumberOfVariableSizeComponents as int2) AS NumberOfVariableSizeComponents,
  comp.VariableSizeItemUnit AS VariableSizeItemUnit,
  comp.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  comp.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  comp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  comp.FormulaKey AS FormulaKey,
  comp.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  comp.OrderPathValue AS OrderPathValue,
  comp.OrderLevelValue AS OrderLevelValue,
  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,
  cast(division( cast(comp.RequiredQuantity as abap.dec(16,5)),(1 + division(comp.ComponentScrapInPercent,100,3)),3) as originaldemandquantity) AS OriginalDemandQuantity,
  comp.EntryUnit AS EntryUnit,
  comp.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  comp.Currency AS Currency,
  comp.WithdrawnQuantityAmount AS WithdrawnQuantityAmount,
  cast(comp._CompanyCode.Currency as vdm_v_company_code_currency preserving type) AS CompanyCodeCurrency,
  cast(1 as usrcurr13) AS FreeDefinedAmount1,
  comp._ReservationItem AS _ReservationItem,
  comp._ReservationDocRecordType AS _ReservationDocRecordType,
  comp._MfgOrderCategory AS _MfgOrderCategory,
  comp._MfgOrderType AS _MfgOrderType,
  comp._MfgOrder AS _MfgOrder,
  comp._MfgOrderSequence AS _MfgOrderSequence,
  comp._MfgOrderOperation AS _MfgOrderOperation,
  comp._MfgOrderOperationBySemanKey AS _MfgOrderOperationBySemanKey,
  comp._MfgOrderOperationBySemKey AS _MfgOrderOperationBySemKey,
  comp._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  comp._OrderInternalID AS _OrderInternalID,
  comp._ProductionPlant AS _ProductionPlant,
  comp._AssemblyMRPController AS _AssemblyMRPController,
  comp._ProductionSupervisor AS _ProductionSupervisor,
  comp._RequirementType AS _RequirementType,
  comp._MaterialGroup AS _MaterialGroup,
  comp._Material AS _Material,
  comp._Product AS _Product,
  comp._ProductPlant AS _ProductPlant,
  comp._ProductPlant2 AS _ProductPlant2,
  comp._Plant AS _Plant,
  comp._MatlCompDiscontinuationType AS _MatlCompDiscontinuationType,
  comp._StorageLocation AS _StorageLocation,
  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._Warehouse AS _Warehouse,
  comp._BOMExplosion AS _BOMExplosion,
  comp._BOMItemCategory AS _BOMItemCategory,
  comp._SalesOrder AS _SalesOrder,
  comp._SalesOrderItem AS _SalesOrderItem,
  comp._WBSElement AS _WBSElement,
  comp._ChangeNumber AS _ChangeNumber,
  comp._PurchasingGroup AS _PurchasingGroup,
  comp._PurchasingInfoRecord AS _PurchasingInfoRecord,
  comp._PurchaseOrder AS _PurchaseOrder,
  comp._PurchaseOrderItem AS _PurchaseOrderItem,
  comp._PurchaseRequisition AS _PurchaseRequisition,
  comp._PurchaseRequisitionItem AS _PurchaseRequisitionItem,
  comp._PurchaseRequisitionItem2 AS _PurchaseRequisitionItem2,
  comp._CompanyCode AS _CompanyCode,
  comp._BusinessArea AS _BusinessArea,
  comp._FunctionalArea AS _FunctionalArea,
  comp._GLAccount AS _GLAccount,
  comp._AccountAssignmentCategory AS _AccountAssignmentCategory,
  comp._BaseUnit AS _BaseUnit,
  comp._EntryUnit AS _EntryUnit,
  comp._Currency AS _Currency,
  comp._LongTextLanguage AS _LongTextLanguage
FROM I_MfgOrderOperationComponent AS comp
INNER JOIN P_PPH_ReportingDate3 AS repdate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _RequirementDate ON MatlCompRequirementDate = _RequirementDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarMonth AS _RequirementDateMonth ON RequirementDateMonth = _RequirementDateMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _RequirementDateYear ON RequirementDateYear = _RequirementDateYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_WeekDay AS _RequirementDateWeekDay ON RequirementDateWeekDay = _RequirementDateWeekDay.WeekDay  -- association [0..1]
LEFT OUTER JOIN I_ReportingPeriod AS _ReportingPeriod ON ReportingPeriod = _ReportingPeriod.ReportingPeriod  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..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 I_OrderReservationDocument AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID_2 = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _ManufacturingOrderSequence ON ManufacturingOrder = _ManufacturingOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _ManufacturingOrderSequence.ManufacturingOrderSequence  -- association [0..1]
;