I_ProductionOrderPRT

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_ProductionOrderPRT.
-- 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.

CREATE VIEW I_ProductionOrderPRT AS
SELECT
  prt.OrderInternalBillOfOperations AS OrderInternalID,
  prt.OrderProdnRsceToolInternalID AS OrderProdnRsceToolInternalID,
  prt.IsDeleted AS IsDeleted,
  prt.CreationDate AS CreationDate,
  prt.CreatedByUser AS CreatedByUser,
  prt.LastChangeDate AS LastChangeDate,
  prt.LastChangedByUser AS LastChangedByUser,
  prt.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  prt.ProdnRsceToolHasLongText AS ProdnRsceToolHasLongText,
  prt.Language AS LongTextLanguage,
  prt.ProductionResourceType AS ProductionResourceType,
  prt.ProductionResourceInternalID AS ProductionResourceInternalID,
  cast(prt._ProdnRsceToolByInternalKey.ProductionResourceTool as pph_fhmnr preserving type) AS ProductionResourceTool,
  prt._ProdnRsceToolByInternalKey.ProdnRsceToolCategory_2 AS ProdnRsceToolCategory,
  prt.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  prt.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  prt.ObjectInternalID AS ObjectInternalID,
  prt.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  cast(prt.OrderID as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(opr.Sequence as vdm_prodnordersequence preserving type) AS ProductionOrderSequence,
  cast(opr.Operation_2 as vdm_prodnorderoperation preserving type) AS ProductionOrderOperation,
  cast(prt.OrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  cast(prt.Plant as pwwrk preserving type) AS ProductionPlant,
  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.ProdnRsceToolTotQtyCalcFormula AS ProdnRsceToolTotQtyCalcFormula,
  prt.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  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._ProdnRsceToolControlProfile AS _ProdnRsceToolControlProfile,
  prt._ProductionResourceType AS _ProductionResourceType,
  prt._ProdnRsceToolByInternalKey AS _ProdnRsceToolByInternalKey,
  prt._ProdnRsceToolMasterData AS _ProdnRsceToolMasterData,
  prt._CreatedByUser AS _CreatedByUser,
  prt._LastChangedByUser AS _LastChangedByUser,
  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
FROM I_OrderProdnResourceTool AS prt
INNER JOIN I_OrderOperationBasic AS opr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionOrderInternalID AS _ProductionOrderInternal ON OrderInternalID = _ProductionOrderInternal.ProductionOrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderType AS _ProductionOrderType ON ProductionOrderType = _ProductionOrderType.ProductionOrderType  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory ON ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderHeader ON ProductionOrder = _ProductionOrderHeader.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderSequence AS _ProductionOrderSequence ON ProductionOrder = _ProductionOrderSequence.ProductionOrder AND ProductionOrderSequence = _ProductionOrderSequence.ProductionOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderPRTLongText AS _LongText ON /* condition not available in parsed metadata */  -- association [0..*]
;