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
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  cast(ManufacturingOrder as aufnr preserving type) AS ManufacturingOrder,
  ManufacturingOrderOperation,
  MfgOrderOperationText,
  _OrderOperation.Language AS Language,
  _OrderOperation.OperationHasLongText AS OperationHasLongText,
  cast (case _MfgOrderBasic.SerialNumberAssgmtProfile when '' then '' else 'X' end as boolean preserving type ) AS SerialNmbrAssgmtProfileIsAssgd,
  ManufacturingOrderSubOperation,
  _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,
  cast(_MfgOrderBasic.ProdnProcgIsFlexible as mpe_procg_flexibility_ind preserving type) AS ProdnProcgIsFlexible,
  _MfgOrderBasic.MfgOrderIsProductReworkOrder AS MfgOrderIsProductReworkOrder,
  _MfgOrderBasic._ProdnProcgFlexibilityIndTxt[1: Language=$session.system_language].ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  ManufacturingOrderSequence,
  ProductionPlant,
  WorkCenterInternalID,
  WorkCenter,
  WorkCenterTypeCode,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionSupervisor,
  MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  NumberOfConfirmationSlips,
  OperationImportance,
  NumberOfTimeTickets,
  cast(OperationControlProfile as steus preserving type) AS OperationControlProfile,
  OperationIsClosed,
  OperationIsTechlyCompleted,
  OperationIsDelivered,
  OperationIsPartiallyDelivered,
  OperationIsPartiallyConfirmed,
  OperationIsPrinted,
  OperationIsReleased,
  OperationIsCreated,
  OperationIsScheduled,
  OperationIsConfirmed,
  OperationIsDeleted,
  OpPlannedTotalQuantity,
  OpTotalConfirmedYieldQty,
  OperationReferenceQuantity,
  OpPlannedScrapQuantity,
  OperationConfirmedReworkQty,
  OpTotalConfirmedScrapQty,
  OperationUnit,
  _OrderOperation.GoodsRecipientName AS GoodsRecipientName,
  _OrderOperation.UnloadingPointName AS UnloadingPointName,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  OperationExecutionEndIsLate,
  OperationExecutionStartIsLate,
  OperationYieldDeviationQty,
  PlannedCurrentStrtDateDvtnDurn,
  PlannedActualStartDateDvtnDurn,
  PlannedCurrentEndDateDvtnDurn,
  PlannedActualEndDateDvtnDurn,
  cast(PlannedCurrentStrtDateDvtnDurn as abap.fltp)/ 86400.00 AS OperationStartDeviationDays,
  cast(PlannedCurrentEndDateDvtnDurn as abap.fltp)/ 86400.00 AS PlannedEndDateDvtnInDays,
  ProductConfiguration,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  SetupOpActyNtwkInstance,
  ProduceOpActyNtwkInstance,
  TeardownOpActyNtwkInstance,
  _MfgOrderBasic.ManufacturingObject AS ManufacturingObject,
  case when _MfgOrderBasic._InspectionLot.InspectionLotOrigin = '03' or _MfgOrderBasic._InspectionLot.InspectionLotOrigin = '04' 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._Material AS _Material
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_MfgOrder AS _MfgOrderBasic ON ManufacturingOrder = _MfgOrderBasic.ManufacturingOrder AND ProductionSupervisor = _MfgOrderBasic.ProductionSupervisor AND _MfgOrderBasic.ManufacturingOrderCategory = '10' AND OrderInternalBillOfOperations = _MfgOrderBasic.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN E_OrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;