I_ManageOperationsTP

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_ManageOperationsTP.
-- 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: IMPEMANOPERTP

CREATE VIEW I_ManageOperationsTP AS
SELECT
  _OrderOperation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _OrderOperation.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  cast(_OrderOperation.ManufacturingOrder as aufnr preserving type) AS ManufacturingOrder,
  _OrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  cast (case _MfgOrderBasic.SerialNumberProfile when '' then '' else 'X' end as boolean preserving type ) AS SerialNmbrAssgmtProfileIsAssgd,
  _MfgOrderBasic._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  _MfgOrderBasic.Material AS Material,
  _MfgOrderBasic.Batch AS Batch,
  _MfgOrderBasic.SalesOrder AS SalesOrder,
  _MfgOrderBasic.SalesOrderItem AS SalesOrderItem,
  _IsFlexible.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  _IsFlexible._ProdnProcgFlexibilityIndTxt.ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  _OrderOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  _OrderOperation.ProductionPlant AS ProductionPlant,
  _OrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  _OrderOperation.WorkCenter AS WorkCenter,
  _OrderOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  _OrderOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  _OrderOperation.ManufacturingOrderType AS ManufacturingOrderType,
  _OrderOperation.ProductionSupervisor AS ProductionSupervisor,
  _OrderOperation.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  _OrderOperation.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  _OrderOperation.OperationImportance AS OperationImportance,
  _OrderOperation.NumberOfTimeTickets AS NumberOfTimeTickets,
  cast(_OrderOperation.OperationControlProfile as steus preserving type) AS OperationControlProfile,
  _OrderOperation.OperationIsClosed AS OperationIsClosed,
  _OrderOperation.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
  _OrderOperation.OperationIsDelivered AS OperationIsDelivered,
  _OrderOperation.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  _OrderOperation.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  _OrderOperation.OperationIsPrinted AS OperationIsPrinted,
  _OrderOperation.OperationIsReleased AS OperationIsReleased,
  _OrderOperation.OperationIsCreated AS OperationIsCreated,
  _OrderOperation.OperationIsScheduled AS OperationIsScheduled,
  _OrderOperation.OperationIsConfirmed AS OperationIsConfirmed,
  _OrderOperation.OperationIsDeleted AS OperationIsDeleted,
  _OrderOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  _OrderOperation.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  _OrderOperation.OperationReferenceQuantity AS OperationReferenceQuantity,
  _OrderOperation.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  _OrderOperation.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  _OrderOperation.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  _OrderOperation.OperationUnit AS OperationUnit,
  _OrderOperation.GoodsRecipientName AS GoodsRecipientName,
  _OrderOperation.UnloadingPointName AS UnloadingPointName,
  _OrderOperation.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _OrderOperation.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _OrderOperation.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _OrderOperation.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _OrderOperation.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _OrderOperation.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  _OrderOperation.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _OrderOperation.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  _OrderOperation.OperationExecutionEndIsLate AS OperationExecutionEndIsLate,
  _OrderOperation.OperationExecutionStartIsLate AS OperationExecutionStartIsLate,
  _OrderOperation.OperationYieldDeviationQty AS OperationYieldDeviationQty,
  _OrderOperation.PlannedCurrentStrtDateDvtnDurn AS PlannedCurrentStrtDateDvtnDurn,
  _OrderOperation.PlannedActualStartDateDvtnDurn AS PlannedActualStartDateDvtnDurn,
  _OrderOperation.PlannedCurrentEndDateDvtnDurn AS PlannedCurrentEndDateDvtnDurn,
  _OrderOperation.PlannedActualEndDateDvtnDurn AS PlannedActualEndDateDvtnDurn,
  case when _OrderOperation.OperationExecutionEndIsLate = 'X' and _OrderOperation.OperationIsConfirmed = '' and _OrderOperation.OperationIsPartiallyConfirmed = 'X' and _OrderOperation.PlannedCurrentEndDateDvtnDurn > 0 then cast(_OrderOperation.PlannedCurrentEndDateDvtnDurn as abap.fltp) / 3600.00 when _OrderOperation.OperationExecutionEndIsLate = 'X' then cast(_OrderOperation.PlannedActualEndDateDvtnDurn as abap.fltp) / 3600.00 else 0 end as ExecutionEndLatenessInHours AS 00else0endasExecutionEndLatenessInHours,
  case when _OrderOperation.OperationExecutionStartIsLate = 'X' and _OrderOperation.OperationIsPartiallyConfirmed = '' and _OrderOperation.OperationIsReleased = 'X' and _OrderOperation.OperationIsConfirmed = '' and _OrderOperation.PlannedCurrentStrtDateDvtnDurn > 0 then (cast(_OrderOperation.PlannedCurrentStrtDateDvtnDurn as abap.fltp) / 60.00) when _OrderOperation.OperationExecutionStartIsLate = 'X' then (cast(_OrderOperation.PlannedActualStartDateDvtnDurn as abap.fltp) / 60.00) else 0 end as ExecutionStartLatenessInMins AS 00else0endasExecutionStartLatenessInMins,
  cast(_OrderOperation.PlannedCurrentStrtDateDvtnDurn as abap.fltp)/ 86400.00 AS OperationStartDeviationDays,
  cast(_OrderOperation.PlannedCurrentEndDateDvtnDurn as abap.fltp)/ 86400.00 AS PlannedEndDateDvtnInDays,
  _OrderOperation.ProductConfiguration AS ProductConfiguration,
  _OrderOperation.BillOfOperationsType AS BillOfOperationsType,
  _OrderOperation.BillOfOperationsGroup AS BillOfOperationsGroup,
  _OrderOperation.BillOfOperationsVariant AS BillOfOperationsVariant,
  _OrderOperation.BillOfOperationsVersion AS BillOfOperationsVersion,
  _OrderOperation.SetupOpActyNtwkInstance AS SetupOpActyNtwkInstance,
  _OrderOperation.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  _OrderOperation.TeardownOpActyNtwkInstance AS TeardownOpActyNtwkInstance,
  _MfgOrderBasic.ObjectInternalID AS ManufacturingObject,
  case _MfgOrderBasic._InspectionLot.InspectionLotType when '03' then _MfgOrderBasic.InspectionLot else ' ' end as InspectionLot AS InspectionLotelseendasInspectionLot,
  _MfgOrderBasic.EffectivityParameterVariant AS EffectivityParameterVariant,
  _MfgOrderBasic._BillOfOperations._BillOfOperationsVersionType.BOOVersionChangeRecordIsRqd AS BOOVersionChangeRecordIsRqd,
  _MfgOrderBasic.MasterProductionOrder AS MasterProductionOrder,
  _MfgOrderBasic.ProductSeasonYear AS ProductSeasonYear,
  _MfgOrderBasic.ProductSeason AS ProductSeason,
  _MfgOrderBasic.ProductCollection AS ProductCollection,
  _MfgOrderBasic.ProductTheme AS ProductTheme,
  _MfgOrderBasic.StockSegment AS StockSegment,
  _MfgOrderBasic.Reservation AS Reservation,
  _MfgOrderBasic.ProductionUnit AS ProductionUnit,
  _AORListDistinct.OrderInternalID AS OrderInternalID,
  _OrderOperation._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  _OrderOperation._ProductionPlant AS _ProductionPlant,
  _OrderOperation._OperationUnit AS _OperationUnit,
  _MfgOrderBasic._Material AS _Material,
  _OrderOperation._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  _OrderOperation._MfgOrderSequence AS _MfgOrderSequence,
  _OrderOperation._MfgOrderCategory AS _MfgOrderCategory,
  _OrderOperation._MfgOrderType AS _MfgOrderType,
  _OrderOperation._ProductionSupervisor AS _ProductionSupervisor,
  _OrderOperation._WorkCenter AS _WorkCenter,
  _OrderOperation._WorkCenterType AS _WorkCenterType,
  _OrderOperation._MRPController AS _MRPController
FROM I_MfgOrderOperationDelay AS _OrderOperation
INNER JOIN P_MfgOperationsList AS _AORListDistinct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionRoutingVersion AS _ProductionRoutingVersion ON BillOfOperationsType = _ProductionRoutingVersion.BillOfOperationsType AND BillOfOperationsGroup = _ProductionRoutingVersion.BillOfOperationsGroup AND BillOfOperationsVariant = _ProductionRoutingVersion.BillOfOperationsVariant AND BillOfOperationsVersion = _ProductionRoutingVersion.BillOfOperationsVersion  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrderBasic ON _MfgOrderBasic.ManufacturingOrderCategory = '10' AND _AORListDistinct.OrderInternalID = _MfgOrderBasic.MfgOrderInternalID  -- association [1..1]
LEFT OUTER JOIN P_ProdnProcgIsFlexible AS _IsFlexible ON _AORListDistinct.OrderInternalID = _IsFlexible.MfgOrderInternalID  -- association [0..1]
LEFT OUTER JOIN E_OrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;