I_MfgOrderItemAmount

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_MfgOrderItemAmount.
-- 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: IMFGORDITEMAMT

CREATE VIEW I_MfgOrderItemAmount AS
SELECT
  item.ManufacturingOrder AS ManufacturingOrder,
  item.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  item.ManufacturingOrderType AS ManufacturingOrderType,
  item.Material AS Material,
  cast(item.Material as productnumber preserving type) AS Product,
  item.ProductionPlant AS ProductionPlant,
  item.MRPPlant AS MRPPlant,
  item.MRPController AS MRPController,
  item.ProductionSupervisor AS ProductionSupervisor,
  item.ProductionVersion AS ProductionVersion,
  item.MRPArea AS MRPArea,
  item.SalesOrder AS SalesOrder,
  item.SalesOrderItem AS SalesOrderItem,
  item.WBSElementInternalID_2 AS WBSElementInternalID,
  item.MfgOrderItemIsFinallyDelivered AS MfgOrderItemIsFinallyDelivered,
  item.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  item.StorageLocation AS StorageLocation,
  item.Batch AS Batch,
  item.InventoryValuationType AS InventoryValuationType,
  item.GoodsRecipientName AS GoodsRecipientName,
  item.UnloadingPointName AS UnloadingPointName,
  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,
  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.BusinessArea AS BusinessArea,
  '0000' AS CompanyCode,
  cast(item.CostEstimate as pph_kalnr preserving type) AS CostEstimate,
  cast(price.InventoryPrice as fml_inventory_price) AS InventoryPrice,
  cast(price.MaterialPriceUnitQty as pph_peinh preserving type) AS MaterialPriceUnitQty,
  item.BaseUnit AS BaseUnit,
  cast(price.ValuationArea as bwkey preserving type) AS ValuationArea,
  cast('000' as fins_fiscalperiod preserving type) AS FiscalPeriod,
  cast('0000' as fis_gjahr_no_conv preserving type) AS FiscalYear,
  'X' AS LedgerValnCrcyRoleIsUsedInLogs,
  price.Currency AS CompanyCodeCurrency,
  cast($session.system_date as sydatum preserving type) AS CurrentDate,
  item._MfgOrderCategory AS _MfgOrderCategory,
  item._MfgOrderType AS _MfgOrderType,
  item._ProductionPlant AS _ProductionPlant,
  item._ProductionSupervisor AS _ProductionSupervisor,
  item._ProductionVersion AS _ProductionVersion,
  item._MRPPlant AS _MRPPlant,
  item._MRPArea AS _MRPArea,
  item._Material AS _Material,
  item._ProductionUnit AS _ProductionUnit,
  item._BaseUnit AS _BaseUnit,
  item._StorageLocation AS _StorageLocation,
  item._DeliveryCompletedIndicator AS _DeliveryCompletedIndicator,
  item._InventoryValuationType AS _InventoryValuationType,
  item._SalesOrder AS _SalesOrder,
  item._SalesOrderItem AS _SalesOrderItem,
  item._BusinessArea AS _BusinessArea
FROM P_MfgOrderItemAmount AS item
INNER JOIN I_InvtryPrcBasicByKeyDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _AlternativeUnit ON Product = _AlternativeUnit.Product AND ProductionUnit = _AlternativeUnit.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasic ON WBSElementInternalID = _WBSElementBasic.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON ProductionPlant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON MRPPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
;