I_ProcessRouteTask

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_ProcessRouteTask.
-- 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: IPROCESSROUTTASK

CREATE VIEW I_ProcessRouteTask AS
SELECT
  ProcessRouteTask.actarea AS ProcessRouteActivityArea,
  ProcessRouteTask.pathid AS ProcessRoute,
  ProcessRouteTask.posid AS ProcessRouteTask,
  ProcessRouteTask.creadate AS ProcessRouteTaskCreationDate,
  ProcessRouteTask.creatime AS ProcessRouteTaskCreationTime,
  cast( substring( ProcessRouteTask.agent, 3, 12) as /plmb/pr_agent) AS ProcessRouteAgent,
  cast( ProcessRouteTask.agent as /plmb/pr_agent_type ) AS ProcessRouteAgentType,
  ProcessRouteTask.activity AS ProcessRouteActivity,
  ProcessRouteTask.posid_led AS ProcessRouteLatestEndDate,
  ProcessRouteTask.posid_let AS ProcessRouteLatestEndTime,
  ProcessRouteTask.duedays AS ProcessRouteProcgTimeInDays,
  ProcessRouteTask.posid_wiid AS WorkflowTaskInternalID,
  ProcessRouteTask.creator AS WorkflowTaskCreatedByUser,
  ProcessRouteTask.delflag AS ProcessRouteTaskIsDeleted,
  ProcessRouteTask.stoppath AS ProcessRouteTaskCancelIsAllwd,
  cast ( ProcessRouteTask.pospast as char1 ) AS ProcessRouteTaskStatus,
  ProcessRouteTask.posauth AS ProcessRouteTaskAuthznLevel,
  ProcessRouteTask.enddate AS ProcessRouteTaskExecutionDate,
  ProcessRouteTask.endtime AS ProcessRouteTaskExecutionTime,
  ProcessRouteTask.actagent AS ProcessRouteCurrentAgent,
  _ProcessRouteTaskBackgroundSrv.ProcessRouteTaskBackgroundSrvc AS ProcessRouteTaskBackgroundSrvc
FROM srmwfpthps AS ProcessRouteTask
LEFT OUTER JOIN I_ProcessRoute AS _ProcessRoute ON _ProcessRoute.ProcessRouteActivityArea = ProcessRouteActivityArea AND _ProcessRoute.ProcessRoute = ProcessRoute  -- association [1..1]
LEFT OUTER JOIN I_ProcessRouteTaskBgSrvc AS _ProcessRouteTaskBackgroundSrv ON _ProcessRouteTaskBackgroundSrv.ProcessRouteActivityArea = ProcessRouteActivityArea AND _ProcessRouteTaskBackgroundSrv.ProcessRoute = ProcessRoute AND _ProcessRouteTaskBackgroundSrv.ProcessRouteTask = ProcessRouteTask  -- association [0..1]
LEFT OUTER JOIN I_WorkflowTask AS _WorkflowTask ON WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProcessRouteTaskAgent AS _ProcessRouteTaskAgentType ON _ProcessRouteTaskAgentType.ProcessRouteActivityArea = ProcessRouteActivityArea AND _ProcessRouteTaskAgentType.ProcessRouteAgentType = ProcessRouteAgentType  -- association [0..*]
;