I_MfgOrderItemCube

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_MfgOrderItemCube.
-- 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: IPPMFGORDITEMC

CREATE VIEW I_MfgOrderItemCube AS
SELECT
  item.ManufacturingOrder AS ManufacturingOrder,
  item.ManufacturingOrderItem AS ManufacturingOrderItem,
  item.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  item.ManufacturingOrderType AS ManufacturingOrderType,
  ' ' AS OrderIsCreated,
  'X' AS OrderIsReleased,
  ' ' AS OrderIsPartiallyReleased,
  ' ' AS OrderIsPrinted,
  'X' AS OrderIsConfirmed,
  ' ' AS OrderIsPartiallyConfirmed,
  ' ' AS OrderIsPartiallyDelivered,
  ' ' AS OrderIsLocked,
  ' ' AS OrderIsClosed,
  ' ' AS OrderIsTechnicallyCompleted,
  ' ' AS OrderIsMarkedForDeletion,
  ' ' AS OrderIsDeleted,
  item.PlannedOrder AS PlannedOrder,
  item.Material AS Material,
  item.ProductionPlant AS ProductionPlant,
  item.PlanningPlant AS MRPPlant,
  item.MRPController AS MRPController,
  item.ProductionSupervisor AS ProductionSupervisor,
  item.Reservation AS Reservation,
  item.ProductionVersion AS ProductionVersion,
  item.MRPArea AS MRPArea,
  item.SalesOrder AS SalesOrder,
  item.SalesOrderItem AS SalesOrderItem,
  item.WBSElementInternalID_2 AS WBSElementInternalID,
  item.SettlementReservation AS SettlementReservation,
  item.CoProductReservation AS CoProductReservation,
  item.MaterialProcurementCategory AS MaterialProcurementCategory,
  item.MaterialProcurementType AS MaterialProcurementType,
  item.SerialNumberAssgmtProfile AS SerialNumberAssgmtProfile,
  item.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  item.MfgOrderItemReplnmtElmntType AS MfgOrderItemReplnmtElmntType,
  item.ProductConfiguration AS ProductConfiguration,
  item.ObjectInternalID AS ManufacturingObject,
  item.QuantityDistributionKey AS QuantityDistributionKey,
  item.EffectivityParameterVariant AS EffectivityParameterVariant,
  item.IsCompletelyDelivered AS IsCompletelyDelivered,
  item.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  item.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  item.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  item.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  item.StorageLocation AS StorageLocation,
  item.Batch AS Batch,
  item.InventoryValuationType AS InventoryValuationType,
  item.InventoryValuationCategory AS InventoryValuationCategory,
  item.InventoryUsabilityCode AS InventoryUsabilityCode,
  item.InventorySpecialStockType AS InventorySpecialStockType,
  item.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  item.ConsumptionPosting AS ConsumptionPosting,
  item.GoodsRecipientName AS GoodsRecipientName,
  item.UnloadingPointName AS UnloadingPointName,
  item.StockSegment AS StockSegment,
  cast(date.ReportingPeriod as pph_reportingperiod preserving type) AS ReportingPeriod,
  cast(left(MfgOrderConfirmedEndTime,2) as enddatehour) AS EndDateHour,
  date.ReportingDateWeekDay AS EndDateWeekDay,
  date.ReportingDateWeek AS EndDateWeek,
  date.ReportingDateMonth AS EndDateMonth,
  date.ReportingDateYear AS EndDateYear,
  cast(concat(date.ReportingDateYear, date.ReportingDateMonth) as vdm_yearmonth) AS EndDateYearMonth,
  item.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  item.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  item.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  item.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  item.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  item.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  item.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  item.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  item.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  item.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  item.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  item.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  item.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  item.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  item.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  item.MfgOrderItemPlannedEndDate AS MfgOrderItemPlannedEndDate,
  item.MfgOrderItemScheduledEndDate AS MfgOrderItemScheduledEndDate,
  item.MfgOrderItemPlndDeliveryDate AS MfgOrderItemPlndDeliveryDate,
  item.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  item.MfgOrderItemTotalCmtmtDate AS MfgOrderItemTotalCmtmtDate,
  item.MfgOrderItemTotalCmtmtDate AS MfgOrderItemAvailabilityDate,
  197001 AS MfgOrdPlndStrtDateYearMonth,
  197001 AS MfgOrdPlndStrtDateYearWeek,
  1 AS MfgOrdPlndStrtDateWeekDay,
  1 AS MfgOrdItemGdsRcptPlndDuration,
  1 AS MfgOrdItemGdsRcptSchdldDurn,
  1 AS MfgOrdItemGdsRcptActDuration,
  0 AS ProcgDurnPlndActualDvtnDays,
  0 AS ProcgDurnSchedldActualDvtnDays,
  item.ProductionUnit AS ProductionUnit,
  item.MfgOrderItemPlannedTotalQty AS MfgOrderItemPlannedTotalQty,
  item.MfgOrderItemPlannedScrapQty AS MfgOrderItemPlannedScrapQty,
  item.MfgOrderItemPlannedYieldQty AS MfgOrderItemPlannedYieldQty,
  item.MfgOrderItemGoodsReceiptQty AS MfgOrderItemGoodsReceiptQty,
  item.MfgOrderItemActualDeviationQty AS MfgOrderItemActualDeviationQty,
  item.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  item.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  item.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  item.MfgOrderConfirmedTotalQty AS MfgOrderConfirmedTotalQty,
  item.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  item.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  item.BusinessArea AS BusinessArea,
  item.AccountAssignmentCategory AS AccountAssignmentCategory,
  item._MfgOrder AS _MfgOrder,
  item._MfgOrderCategory AS _MfgOrderCategory,
  item._MfgOrderType AS _MfgOrderType,
  item._ProductionPlant AS _ProductionPlant,
  item._ProductionSupervisor AS _ProductionSupervisor,
  item._MRPController AS _MRPController,
  item._MRPPlant AS _MRPPlant,
  item._MRPArea AS _MRPArea,
  item._Material AS _Material,
  item._ProductionUnit AS _ProductionUnit,
  item._ProductionVersion AS _ProductionVersion,
  item._Reservation AS _Reservation,
  item._StorageLocation AS _StorageLocation,
  item._InventorySpecialStockType AS _InventorySpecialStockType,
  item._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  item._InventoryValuationType AS _InventoryValuationType,
  item._InventoryUsabilityCode AS _InventoryUsabilityCode,
  item._ConsumptionPosting AS _ConsumptionPosting,
  item._PlannedOrder AS _PlannedOrder,
  item._SalesOrder AS _SalesOrder,
  item._SalesOrderItem AS _SalesOrderItem,
  item._WBSElementBasicData2 AS _WBSElementBasicData,
  item._QuotaArrangement AS _QuotaArrangement,
  item._QuotaArrangementItem AS _QuotaArrangementItem,
  item._SettlementReservation AS _SettlementReservation,
  item._SettlementReservationItem AS _SettlementReservationItem,
  item._CoProductReservation AS _CoProductReservation,
  item._CoProductReservationItem AS _CoProductReservationItem,
  item._MatlProcurementCategory AS _MatlProcurementCategory,
  item._MatlProcurementType AS _MatlProcurementType,
  item._BusinessArea AS _BusinessArea,
  item._AccountAssignmentCategory AS _AccountAssignmentCategory
FROM I_ManufacturingOrderItem AS item
INNER JOIN P_PPH_ReportingDate3 AS date ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WeekDay AS _EndDateWeekDay ON EndDateWeekDay = _EndDateWeekDay.WeekDay  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _EndDate ON MfgOrderPlannedEndDate = _EndDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarMonth AS _EndDateMonth ON EndDateMonth = _EndDateMonth.CalendarMonth  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _EndDateYear ON EndDateYear = _EndDateYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_ReportingPeriod AS _ReportingPeriod ON ReportingPeriod = _ReportingPeriod.ReportingPeriod  -- association [0..1]
;