I_MfgOrderOperationPRT

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_MfgOrderOperationPRT.
-- 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: IPPMFGORDOPPRT

CREATE VIEW I_MfgOrderOperationPRT AS
SELECT
  prt.OrderInternalBillOfOperations AS MfgOrderInternalID,
  prt.OrderProdnRsceToolInternalID AS MfgOrderOpProdnRsceToolIntID,
  prt.IsDeleted AS IsDeleted,
  prt.CreationDate AS CreationDate,
  prt.CreatedByUser AS CreatedByUser,
  prt.LastChangeDate AS LastChangeDate,
  prt.LastChangedByUser AS LastChangedByUser,
  prt.OrderProdnRsceToolText AS MfgOrderOpProdnRsceToolText,
  prt.Language AS Language,
  prt.ProductionResourceType AS ProductionResourceType,
  prt.ProductionResourceInternalID AS ProductionResourceInternalID,
  cast(prt._ProdnRsceToolByInternalKey.ProductionResourceTool as pph_fhmnr preserving type) AS ProductionResourceTool,
  prt._ProdnRsceToolByInternalKey.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  prt._ProdnRsceToolByInternalKey.ProdnRsceToolCategory_2 AS ProdnRsceToolCategory_2,
  prt.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  prt.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  prt.ObjectInternalID AS ObjectInternalID,
  prt.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  cast(prt.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(opr.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  cast(opr.Operation as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  opr.Operation_2 AS ManufacturingOrderOperation_2,
  opr.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  cast(prt.OrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(prt.OrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  cast(prt.Plant as pwwrk preserving type) AS ProductionPlant,
  cast(opr.OperationControlProfile as pph_steus preserving type) AS OperationControlProfile,
  prt.BillOfOperationsType AS BillOfOperationsType,
  prt.BillOfOperationsGroup AS BillOfOperationsGroup,
  prt.EarliestSchedldUsageStartDate AS EarliestSchedldUsageStartDate,
  prt.EarliestSchedldUsageStartTime AS EarliestSchedldUsageStartTime,
  prt.EarliestSchedldUsageEndDate AS EarliestSchedldUsageEndDate,
  prt.EarliestSchedldUsageEndTime AS EarliestSchedldUsageEndTime,
  prt.LatestSchedldUsageStartDate AS LatestSchedldUsageStartDate,
  prt.LatestSchedldUsageStartTime AS LatestSchedldUsageStartTime,
  prt.LatestSchedldUsageEndDate AS LatestSchedldUsageEndDate,
  prt.LatestSchedldUsageEndTime AS LatestSchedldUsageEndTime,
  prt.ActualUsageStartDate AS ActualUsageStartDate,
  prt.ActualUsageStartTime AS ActualUsageStartTime,
  prt.ActualUsageEndDate AS ActualUsageEndDate,
  prt.ActualUsageEndTime AS ActualUsageEndTime,
  prt.ProdnRsceToolUsageDurnUnit AS ProdnRsceToolUsageDurnUnit,
  prt.ProdnRsceToolUsageDuration AS ProdnRsceToolUsageDuration,
  prt.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  prt.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  prt.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  prt.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  prt.ConfirmedProdnRsceToolQtyUnit AS ConfirmedProdnRsceToolQtyUnit,
  prt.ConfirmedProdnRsceToolQty AS ConfirmedProdnRsceToolQty,
  prt.RemainingProdnRsceToolQtyUnit AS RemainingProdnRsceToolQtyUnit,
  prt.RemainingProdnRsceToolQty AS RemainingProdnRsceToolQty,
  prt.ProdnRsceToolUsageQuantityUnit AS ProdnRsceToolUsageQuantityUnit,
  prt.ProdnRsceToolUsageQuantity AS ProdnRsceToolUsageQuantity,
  prt.PlndProdnRsceToolUsageQtyUnit AS PlndProdnRsceToolUsageQtyUnit,
  prt.PlannedProdnRsceToolUsageQty AS PlannedProdnRsceToolUsageQty,
  prt.ConfdProdnRsceToolUsageQtyUnit AS ConfdProdnRsceToolUsageQtyUnit,
  prt.ConfirmedProdnRsceToolUsageQty AS ConfirmedProdnRsceToolUsageQty,
  prt.RmngProdnRsceToolUsageQtyUnit AS RmngProdnRsceToolUsageQtyUnit,
  prt.RemainingProdnRsceToolUsageQty AS RemainingProdnRsceToolUsageQty,
  prt.ProdnRsceToolTotQtyCalcFormula AS ProdnRsceToolTotQtyCalcFormula,
  prt.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  prt._ProdnRsceToolControlProfile AS _ProdnRsceToolControlProfile,
  prt._ProductionResourceType AS _ProductionResourceType,
  prt._ProdnRsceToolByInternalKey AS _ProdnRsceToolByInternalKey,
  prt._ProdnRsceToolMasterData AS _ProdnRsceToolMasterData,
  prt._CreatedByUser AS _CreatedByUser,
  prt._LastChangedByUser AS _LastChangedByUser,
  prt._Language AS _Language,
  prt._BillOfOperationsType AS _BillOfOperationsType,
  prt._BillOfOperationsGroup AS _BillOfOperationsGroup,
  prt._ProdnRsceToolUsageDurnUnit AS _ProdnRsceToolUsageDurnUnit,
  prt._ProdnRsceToolStdWorkQtyUnit AS _ProdnRsceToolStdWorkQtyUnit,
  prt._PlannedProdnRsceToolQtyUnit AS _PlannedProdnRsceToolQtyUnit,
  prt._ConfirmedProdnRsceToolQtyUnit AS _ConfirmedProdnRsceToolQtyUnit,
  prt._RemainingProdnRsceToolQtyUnit AS _RemainingProdnRsceToolQtyUnit,
  prt._ProdnRsceToolUsageQtyUnit AS _ProdnRsceToolUsageQtyUnit,
  prt._PlndProdnRsceToolUsageQtyUnit AS _PlndProdnRsceToolUsageQtyUnit,
  prt._ConfdProdnRsceToolUsgeQtyUnit AS _ConfdProdnRsceToolUsgeQtyUnit,
  prt._RmngProdnRsceToolUsageQtyUnit AS _RmngProdnRsceToolUsageQtyUnit,
  prt._StatusObject AS _StatusObject,
  prt._DocumentProdnRsceTool AS _DocumentProdnRsceTool,
  prt._EquipmentProdnRsceTool AS _EquipmentProdnRsceTool,
  prt._MaterialProdnRsceTool AS _MaterialProdnRsceTool,
  prt._MiscProdnRsceTool AS _MiscProdnRsceTool,
  prt._MsrgPointProdnRsceTool AS _MsrgPointProdnRsceTool
FROM I_OrderProdnResourceTool AS prt
INNER JOIN I_OrderOperationBasic AS opr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderInternalID AS _MfgOrderInternalID ON MfgOrderInternalID = _MfgOrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder2 ON ManufacturingOrder = _MfgOrder2.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _MfgOrderSequence2 ON ManufacturingOrder = _MfgOrderSequence2.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence2.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _MfgOrderOperation ON MfgOrderInternalID = _MfgOrderOperation.MfgOrderInternalID AND OrderOperationInternalID = _MfgOrderOperation.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemanKey AS _MfgOrderOperationBySemanKey ON ManufacturingOrder = _MfgOrderOperationBySemanKey.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationBySemanKey.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperationBySemanKey.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemKey AS _MfgOrderOperationBySemKey ON ManufacturingOrder = _MfgOrderOperationBySemKey.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationBySemKey.ManufacturingOrderSequence AND ManufacturingOrderOperation_2 = _MfgOrderOperationBySemKey.ManufacturingOrderOperation  -- association [1..1]
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_ProdnRsceToolCategory AS _ProdnRsceToolCategory ON ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory_2 ON ProdnRsceToolCategory_2 = _ProdnRsceToolCategory_2.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
;