I_ManufacturingOrderItem

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_ManufacturingOrderItem.
-- 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: IMFGORDERITEM

CREATE VIEW I_ManufacturingOrderItem AS
SELECT
  cast(item.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(item.OrderItem as manufacturingorderitem preserving type) AS ManufacturingOrderItem,
  cast(item.OrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(item.OrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  cast(item.OrderIsReleased as orderisreleased preserving type) AS OrderIsReleased,
  item.IsMarkedForDeletion AS IsMarkedForDeletion,
  cast(item.OrderItemIsNotRelevantForMRP as vdm_dnrel preserving type) AS OrderItemIsNotRelevantForMRP,
  item.Material AS Material,
  cast(item.Material as productnumber preserving type) AS Product,
  cast(head.MRPController as pph_dispo preserving type) AS MRPController,
  cast(head.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  item.SalesOrder AS SalesOrder,
  item.SalesOrderItem AS SalesOrderItem,
  item.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  item.WBSElementInternalID AS WBSElementInternalID,
  item.SettlementReservation AS SettlementReservation,
  item.SettlementReservationItem AS SettlementReservationItem,
  item.CoProductReservation AS CoProductReservation,
  item.CoProductReservationItem AS CoProductReservationItem,
  item.MaterialProcurementCategory AS MaterialProcurementCategory,
  item.MaterialProcurementType AS MaterialProcurementType,
  item.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  item.MfgOrderItemReplnmtElmntType AS MfgOrderItemReplnmtElmntType,
  cast(item.ProductConfiguration as product_configuration preserving type) AS ProductConfiguration,
  item.ObjectInternalID AS ObjectInternalID,
  head.ObjectInternalID AS ManufacturingObject,
  item.QuantityDistributionKey AS QuantityDistributionKey,
  item.EffectivityParameterVariant AS EffectivityParameterVariant,
  item.OriginalEffctyParameterVariant AS OriginalEffctyParameterVariant,
  item.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  item.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  item.IsCompletelyDelivered AS IsCompletelyDelivered,
  item.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  item.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  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(head.PlannedStartDate as mfgorderplannedstartdate preserving type) AS MfgOrderPlannedStartDate,
  cast(head.PlannedStartTime as mfgorderplannedstarttime preserving type) AS MfgOrderPlannedStartTime,
  cast(head.ScheduledBasicStartDate as mfgorderscheduledstartdate preserving type) AS MfgOrderScheduledStartDate,
  cast(head.ScheduledBasicStartTime as mfgorderscheduledstarttime preserving type) AS MfgOrderScheduledStartTime,
  cast(head.ActualStartDate as mfgorderactualstartdate preserving type) AS MfgOrderActualStartDate,
  cast(head.ActualStartTime as mfgorderactualstarttime preserving type) AS MfgOrderActualStartTime,
  cast(head.PlannedEndDate as mfgorderplannedenddate preserving type) AS MfgOrderPlannedEndDate,
  cast(head.PlannedEndTime as mfgorderplannedendtime preserving type) AS MfgOrderPlannedEndTime,
  cast(head.ScheduledBasicEndDate as mfgorderscheduledenddate preserving type) AS MfgOrderScheduledEndDate,
  cast(head.ScheduledBasicEndTime as mfgorderscheduledendtime preserving type) AS MfgOrderScheduledEndTime,
  cast(head.ConfirmedEndDate as mfgorderconfirmedenddate preserving type) AS MfgOrderConfirmedEndDate,
  cast(head.ConfirmedEndTime as mfgorderconfirmedendtime preserving type) AS MfgOrderConfirmedEndTime,
  cast(head.ActualDeliveryDate as mfgorderactualenddate preserving type) AS MfgOrderActualEndDate,
  cast(head.ScheduledReleaseDate as mfgorderscheduledreleasedate preserving type) AS MfgOrderScheduledReleaseDate,
  cast(head.ActualReleasedDate as mfgorderactualreleasedate preserving type) AS MfgOrderActualReleaseDate,
  cast(item.PlannedEndDate as mfgorderitemplannedenddate preserving type) AS MfgOrderItemPlannedEndDate,
  cast(item.ScheduledBasicEndDate as mfgorderitemscheduledenddate preserving type) AS MfgOrderItemScheduledEndDate,
  item.PlannedDeliveryDate AS MfgOrderItemPlndDeliveryDate,
  item.ActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  item.TotalCommitmentDate AS MfgOrderItemTotalCmtmtDate,
  item.ProductionUnit AS ProductionUnit,
  cast(item.ItemQuantity as co_psmng preserving type) AS MfgOrderItemPlannedTotalQty,
  cast(item.MfgOrderItemPlannedScrapQty as co_psamg preserving type) AS MfgOrderItemPlannedScrapQty,
  cast(item.ItemQuantity - item.MfgOrderItemPlannedScrapQty as plannedyieldquantity) AS MfgOrderItemPlannedYieldQty,
  cast(item.MfgOrderItemGoodsReceiptQty as co_wemng preserving type) AS MfgOrderItemGoodsReceiptQty,
  cast(item.MfgOrderItemActualDeviationQty as co_iamng preserving type) AS MfgOrderItemActualDeviationQty,
  cast(item.MfgOrderItemOpenYieldQty as openyieldquantity preserving type) AS MfgOrderItemOpenYieldQty,
  cast(head.OrderConfirmedYieldQty as co_igmng preserving type) AS MfgOrderConfirmedYieldQty,
  cast(head.OrderConfirmedScrapQty as co_iasmg preserving type) AS MfgOrderConfirmedScrapQty,
  cast(head.MfgOrderConfirmedReworkQty as rmnga preserving type) AS MfgOrderConfirmedReworkQty,
  cast(head.OrderConfirmedYieldQty + head.OrderConfirmedScrapQty + head.MfgOrderConfirmedReworkQty as pph_tmnga) AS MfgOrderConfirmedTotalQty,
  cast(head.OrderPlannedTotalQty as gamng preserving type) AS MfgOrderPlannedTotalQty,
  cast(head.OrderPlannedScrapQty as gasmg preserving type) AS MfgOrderPlannedScrapQty,
  item.PlannedOrder AS PlannedOrder,
  cast(item.PlndOrderPlannedStartDate as vdm_strmp preserving type) AS PlndOrderPlannedStartDate,
  cast(item.PlannedOrderOpeningDate as vdm_etrmp preserving type) AS PlannedOrderOpeningDate,
  item.BaseUnit AS BaseUnit,
  cast(item.OrderPlannedTotalQty as vdm_pgmng preserving type) AS PlndOrderPlannedTotalQty,
  cast(item.OrderPlannedScrapQty as vdm_pamng preserving type) AS PlndOrderPlannedScrapQty,
  item.BusinessArea AS BusinessArea,
  item.AccountAssignmentCategory AS AccountAssignmentCategory,
  head.Currency AS CompanyCodeCurrency,
  item.GoodsReceiptAmountInCoCodeCrcy AS GoodsReceiptAmountInCoCodeCrcy,
  head.MasterProductionOrder AS MasterProductionOrder,
  item._ProductionPlant AS _ProductionPlant,
  item._MRPPlant AS _MRPPlant,
  item._MRPArea AS _MRPArea,
  item._PlannedOrder AS _PlannedOrder,
  item._Material AS _Material,
  item._BaseUnit AS _BaseUnit,
  item._ProductionUnit AS _ProductionUnit,
  item._ProductionVersion AS _ProductionVersion,
  item._MatlProcurementCategory AS _MatlProcurementCategory,
  item._MatlProcurementType AS _MatlProcurementType,
  item._DeliveryCompletedIndicator AS _DeliveryCompletedIndicator,
  item._StorageLocation AS _StorageLocation,
  item._InventorySpecialStockType AS _InventorySpecialStockType,
  item._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
  item._InventoryValuationType AS _InventoryValuationType,
  item._InventoryUsabilityCode AS _InventoryUsabilityCode,
  item._SerialNumberProfile AS _SerialNumberProfile,
  item._ConsumptionPosting AS _ConsumptionPosting,
  item._SalesOrder AS _SalesOrder,
  item._SalesOrderItem AS _SalesOrderItem,
  item._SalesOrderScheduleLine AS _SalesOrderScheduleLine,
  item._WBSElement AS _WBSElement,
  item._WBSElementBasicData AS _WBSElementBasicData,
  item._WBSElementBasicData2 AS _WBSElementBasicData2,
  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._BusinessArea AS _BusinessArea,
  item._AccountAssignmentCategory AS _AccountAssignmentCategory,
  head._CompanyCode AS _CompanyCode
FROM I_OrderItem AS item
INNER JOIN I_LogisticsOrder AS head ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON ProductionPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON ProductionPlant = _ProductPlant.Plant AND Product = _ProductPlant.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlanningPlant ON PlanningPlant = _ProductPlanningPlant.Plant AND Product = _ProductPlanningPlant.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant2 ON ProductionPlant = _ProductPlant2.Plant AND Product = _ProductPlant2.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlanningPlant2 ON PlanningPlant = _ProductPlanningPlant2.Plant AND Product = _ProductPlanningPlant2.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON PlanningPlant = _ProductSupplyPlanning.Plant AND Product = _ProductSupplyPlanning.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageLocation AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND ProductionPlant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageLocationBasic AS _ProductStorageLocation2 ON Material = _ProductStorageLocation2.Product AND ProductionPlant = _ProductStorageLocation2.Plant AND StorageLocation = _ProductStorageLocation2.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Product = _ProductUnitsOfMeasure.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductMRPArea AS _ProductMRPArea ON Product = _ProductMRPArea.Product AND MRPArea = _ProductMRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantMRP AS _ProductPlantMRPArea ON Product = _ProductPlantMRPArea.Product AND ProductionPlant = _ProductPlantMRPArea.Plant AND MRPArea = _ProductPlantMRPArea.MRPArea  -- 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]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderItemSerialNumber AS _MfgOrderItemSrlNmbr ON ManufacturingOrder = _MfgOrderItemSrlNmbr.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItemSrlNmbr.ManufacturingOrderItem  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderItemLongText AS _MfgOrderItemLongText ON ManufacturingOrder = _MfgOrderItemLongText.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItemLongText.ManufacturingOrderItem  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _ProductionPlantText ON ProductionPlant = _ProductionPlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlanningPlantText ON PlanningPlant = _PlanningPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersionText ON Material = _ProductionVersionText.Material AND ProductionPlant = _ProductionVersionText.Plant AND ProductionVersion = _ProductionVersionText.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPAreaText ON MRPArea = _MRPAreaText.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementText ON WBSElementInternalID_2 = _WBSElementText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocationText ON ProductionPlant = _StorageLocationText.Plant AND StorageLocation = _StorageLocationText.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObjectHeader ON ManufacturingObject = _StatusObjectHeader.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObjectItem ON ObjectInternalID = _StatusObjectItem.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
;