I_OperationActivityWorklistTP

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_OperationActivityWorklistTP.
-- 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_OperationActivityWorklistTP AS
SELECT
  OperationActivityWorklist.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActivityWorklist.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActivityWorklist.UserID AS UserID,
  OperationActivityWorklist.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OperationActivityWorklist.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OperationActivityWorklist.ManufacturingOrder AS ManufacturingOrder,
  OperationActivityWorklist.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  OperationActivityWorklist.MfgOrderOperationText AS MfgOrderOperationText,
  OperationActivityWorklist.WorkCenter AS WorkCenter,
  OperationActivityWorklist.WorkCenterInternalID AS WorkCenterInternalID,
  OperationActivityWorklist.WorkCenterTypeCode AS WorkCenterTypeCode,
  OperationActivityWorklist.ProductionPlant AS ProductionPlant,
  OperationActivityWorklist.StatusAndActionSchema AS StatusAndActionSchema,
  OperationActivityWorklist.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  OperationActivityWorklist.SASStatusCategory AS SASStatusCategory,
  OperationActivityWorklist.ProductionUnit AS ProductionUnit,
  OperationActivityWorklist.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  OperationActivityWorklist.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  cast( 0 as mpe_ready_qty ) AS OperationExecutionAvailableQty,
  cast(0 as mpe_target_duration_quan) AS OpActyExpdExecutionDuration,
  cast(0 as mpe_target_labor_durn_quan) AS OpActyExpdExecutionLaborDurn,
  cast('' as durationunit) AS DurationUnit,
  OperationActivityWorklist.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OperationActivityWorklist.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  OperationActivityWorklist.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OperationActivityWorklist.OperationActivityNetwork AS OperationActivityNetwork,
  OperationActivityWorklist.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OperationActivityWorklist.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OperationActivityWorklist.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  OperationActivityWorklist.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  OperationActivityWorklist.NrOfOpActyUserAssignments AS NrOfOpActyUserAssignments,
  OperationActivityWorklist.NrOfOpActyTeamAssignments AS NrOfOpActyTeamAssignments,
  OperationActivityWorklist.RespyMgmtTeamID AS RespyMgmtTeamID,
  OperationActivityWorklist.OrderInternalID AS OrderInternalID,
  OperationActivityWorklist.OrderOperationInternalID AS OrderOperationInternalID,
  OperationActivityWorklist.OperationActivity AS OperationActivity,
  OperationActivityWorklist.OperationActyVersionCounter AS OperationActyVersionCounter,
  cast( 0 as mpe_hold_nmbr ) AS ProductionHold,
  OperationActivityWorklist.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  OperationActivityWorklist.OpLtstSchedldExecEndDteTme AS OpLtstSchedldExecEndDteTme,
  OperationActivityWorklist.OpActualExecutionStartDateTime AS OpActualExecutionStartDateTime,
  OperationActivityWorklist.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  OperationActivityWorklist.MfgOpActyExecutionPriority AS MfgOpActyExecutionPriority,
  OperationActivityWorklist._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OperationActivityWorklist._User AS _User,
  OperationActivityWorklist._MfgOrder AS _MfgOrder,
  OperationActivityWorklist._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OperationActivityWorklist._OperationActivityNetwork AS _OperationActivityNetwork,
  OperationActivityWorklist._SASSchema AS _SASSchema,
  OperationActivityWorklist._UnitOfMeasure AS _UnitOfMeasure,
  OperationActivityWorklist._SASStatus AS _SASStatus,
  OperationActivityWorklist._ProductionPlant AS _ProductionPlant,
  OperationActivityWorklist._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  OperationActivityWorklist._WorkCenterType AS _WorkCenterType,
  OperationActivityWorklist._OpActyUserAssgmt AS _OpActyUserAssgmt,
  OperationActivityWorklist._OperationActivityText AS _OperationActivityText
FROM P_OperationActivityWorklist AS OperationActivityWorklist
LEFT OUTER JOIN I_OpActyRespyMgmtTeamAssgmt AS _OpActyRespyMgmtTeamAssgmt ON OpActyNtwkInstance = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN E_OperationActivity AS _Extension ON OperationActivity = _Extension.OperationActivity AND OperationActyVersionCounter = _Extension.OperationActyVersionCounter  -- association [0..1]
;