I_MfgOrderItemAmountCube

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_MfgOrderItemAmountCube.
-- 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: IMFGORDITEMAMTC
-- Parameters: P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_MfgOrderItemAmountCube AS
SELECT
  item.ManufacturingOrder AS ManufacturingOrder,
  item.ManufacturingOrderItem AS ManufacturingOrderItem,
  item.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  item.ManufacturingOrderType AS ManufacturingOrderType,
  item.ProductionPlant AS ProductionPlant,
  item.MRPPlant AS MRPPlant,
  item.MRPController AS MRPController,
  item.ProductionSupervisor AS ProductionSupervisor,
  item.MfgOrderItemIsFinallyDelivered AS MfgOrderItemIsFinallyDelivered,
  item.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  item.StorageLocation AS StorageLocation,
  item.Batch AS Batch,
  item.InventoryValuationType AS InventoryValuationType,
  item.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  item.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  item.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  item.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  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.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  item.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  item.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  item.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  item.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  item.MfgOrderItemPlannedEndDate AS MfgOrderItemPlannedEndDate,
  item.MfgOrderItemScheduledEndDate AS MfgOrderItemScheduledEndDate,
  item.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  cast(date.ReportingPeriod as pph_reportingperiod preserving type) AS ReportingPeriod,
  cast(left(item.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.ProductionUnit AS ManufacturingOrderUnit,
  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.BusinessArea AS BusinessArea,
  item.CostEstimate AS CostEstimate,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(item.PlannedScrapAmountInCCCrcy as plndscrapamtinccrcy preserving type) AS PlannedScrapAmountInCCCrcy,
  cast(item.ConfirmedScrapAmountInCCCrcy as confscrapamtinccrcy preserving type) AS ConfirmedScrapAmountInCCCrcy,
  cast(item.ConfirmedYieldAmountInCCCrcy as confyieldamtinccrcy preserving type) AS ConfirmedYieldAmountInCCCrcy,
  cast(item.ConfirmedReworkAmountInCCCrcy as confreworkamtinccrcy preserving type) AS ConfirmedReworkAmountInCCCrcy,
  item.InventoryPrice AS InventoryPrice,
  item.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  item.BaseUnit AS BaseUnit,
  item.ValuationArea AS ValuationArea,
  item.FiscalPeriod AS FiscalPeriod,
  cast(item.FiscalYear as gjahr preserving type) AS FiscalYear,
  item.FiscalYear AS FiscalYear_2,
  cast($parameters.P_DisplayCurrency as displaycurrency preserving type) AS DisplayCurrency,
  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._Product AS _Product,
  item._ProductionUnit AS _ManufacturingOrderUnit,
  item._BaseUnit AS _BaseUnit,
  item._StorageLocation AS _StorageLocation,
  item._InventoryValuationType AS _InventoryValuationType,
  item._ValuationArea AS _ValuationArea,
  item._CompanyCodeCurrency AS _CompanyCodeCurrency
FROM I_MfgOrderItemAmount AS item
INNER JOIN P_PPH_ReportingDate3 AS date ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ReportingPeriod AS _ReportingPeriod ON ReportingPeriod = _ReportingPeriod.ReportingPeriod  -- association [0..1]
LEFT OUTER JOIN I_WeekDay AS _EndDateWeekDay ON EndDateWeekDay = _EndDateWeekDay.WeekDay  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON ProductionPlant = _Batch.Plant AND Product = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
;