P_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 P_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: PMFGORDITEMAMT

CREATE VIEW P_MfgOrderItemAmount AS
SELECT
  item.ManufacturingOrder AS ManufacturingOrder,
  item.ManufacturingOrderItem AS ManufacturingOrderItem,
  item.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  item.ManufacturingOrderType AS ManufacturingOrderType,
  item.Material AS Material,
  item.ProductionPlant AS ProductionPlant,
  item.PlanningPlant 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 AS WBSElementInternalID,
  item.WBSElementInternalID_2 AS WBSElementInternalID_2,
  item.IsMarkedForDeletion AS MfgOrderIsToBeDeleted,
  item.IsCompletelyDelivered 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.BaseUnit AS BaseUnit,
  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,
  cost.CostEstimate AS CostEstimate,
  item._MfgOrder AS _MfgOrder,
  item._MfgOrderCategory AS _MfgOrderCategory,
  item._MfgOrderType AS _MfgOrderType,
  item._ProductionPlant AS _ProductionPlant,
  item._ProductionSupervisor AS _ProductionSupervisor,
  item._ProductionVersion AS _ProductionVersion,
  item._MRPController AS _MRPController,
  item._MRPPlant AS _MRPPlant,
  item._MRPArea AS _MRPArea,
  item._Material AS _Material,
  item._BaseUnit AS _BaseUnit,
  item._ProductionUnit AS _ProductionUnit,
  item._DeliveryCompletedIndicator AS _DeliveryCompletedIndicator,
  item._StorageLocation AS _StorageLocation,
  item._InventoryValuationType AS _InventoryValuationType,
  item._SalesOrder AS _SalesOrder,
  item._SalesOrderItem AS _SalesOrderItem,
  item._WBSElement AS _WBSElement,
  item._WBSElementBasicData2 AS _WBSElementBasicData2,
  item._BusinessArea AS _BusinessArea
FROM I_ManufacturingOrderItem AS item
INNER JOIN P_MfgOrderItemCost AS cost ON /* join condition not captured in parsed metadata */
;