I_MfgOrdOperationPRTWithStatus

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_MfgOrdOperationPRTWithStatus.
-- 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_MfgOrdOperationPRTWithStatus AS
SELECT
  prt.MfgOrderInternalID AS MfgOrderInternalID,
  prt.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  prt.IsDeleted AS IsDeleted,
  prt.CreationDate AS CreationDate,
  prt.CreatedByUser AS CreatedByUser,
  prt.LastChangeDate AS LastChangeDate,
  prt.LastChangedByUser AS LastChangedByUser,
  prt.MfgOrderOpProdnRsceToolText AS MfgOrderOpProdnRsceToolText,
  prt.Language AS Language,
  stat.OrderOperationPRTIsCreated AS OrderOperationPRTIsCreated,
  stat.OrderOperationPRTIsReleased AS OrderOperationPRTIsReleased,
  stat.OrderOperationPRTIsPrinted AS OrderOperationPRTIsPrinted,
  stat.OrderOperationPRTIsDeleted AS OrderOperationPRTIsDeleted,
  stat.OrdOperationPRTIsNotAvailable AS OrdOperationPRTIsNotAvailable,
  prt.ProductionResourceType AS ProductionResourceType,
  prt.ProductionResourceInternalID AS ProductionResourceInternalID,
  prt.ProductionResourceTool AS ProductionResourceTool,
  prt.ProdnRsceToolCategory_2 AS ProdnRsceToolCategory,
  prt.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  prt.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  prt.OrderOperationInternalID AS OrderOperationInternalID,
  prt.ManufacturingOrder AS ManufacturingOrder,
  prt.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  prt.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation,
  prt.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  prt.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  prt.ManufacturingOrderType AS ManufacturingOrderType,
  prt.ProductionPlant AS ProductionPlant,
  prt.OperationControlProfile 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._MfgOrderInternalID AS _MfgOrderInternalID,
  prt._MfgOrder AS _MfgOrder,
  prt._MfgOrderSequence2 AS _MfgOrderSequence,
  prt._MfgOrderOperation AS _MfgOrderOperation,
  prt._MfgOrderOperationBySemKey AS _MfgOrderOperationBySemKey,
  prt._MfgOrderCategory AS _MfgOrderCategory,
  prt._MfgOrderType AS _MfgOrderType,
  prt._ProductionPlant AS _ProductionPlant,
  prt._OperationControlProfile AS _OperationControlProfile,
  prt._ProdnRsceToolControlProfile AS _ProdnRsceToolControlProfile,
  prt._ProductionResourceType AS _ProductionResourceType,
  prt._ProdnRsceToolByInternalKey AS _ProdnRsceToolByInternalKey,
  prt._ProdnRsceToolMasterData AS _ProdnRsceToolMasterData,
  prt._ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory,
  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,
  stat._PRTIsCreatedCode AS _PRTIsCreatedCode,
  stat._PRTIsReleasedCode AS _PRTIsReleasedCode,
  stat._PRTIsPrintedCode AS _PRTIsPrintedCode,
  stat._PRTIsDeletedCode AS _PRTIsDeletedCode,
  stat._PRTIsNotAvailableCode AS _PRTIsNotAvailableCode
FROM I_MfgOrderOperationPRT AS prt
INNER JOIN P_OrderOpPRTStatusBasicAggrgn AS stat ON /* join condition not captured in parsed metadata */
;