C_ProcessRouteTask

DDL: C_PROCESSROUTETASK Type: view_entity CONSUMPTION
23 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Process Route Task Consumption View

C_ProcessRouteTask is a Consumption CDS View that provides data about "Process Route Task Consumption View" in SAP S/4HANA. It reads from 1 data source (I_ProcessRouteTaskTP) and exposes 23 fields with key fields ProcessRouteActivityArea, ProcessRoute, ProcessRouteTask, ProcessRouteTaskRowKey. It has 1 association to related views. It is exposed through 1 OData service (PLMI_PROCESS_ROUTE). It is used in 1 Fiori application: Process Routes.

Data Sources (1)

SourceAliasJoin Type
I_ProcessRouteTaskTP I_ProcessRouteTaskTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ProcessRouteObjectActivityVH _ProcessRouteObjectActivityVH _ProcessRouteObjectActivityVH.ProcessRouteActivityArea = $projection.ProcessRouteActivityArea and _ProcessRouteObjectActivityVH.ProcessRouteActivity = $projection.ProcessRouteActivity

Annotations (8)

NameValueLevelField
EndUserText.label Process Route Task Consumption View view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view

OData Services (1)

ServiceBindingVersionContractRelease
PLMI_PROCESS_ROUTE PLMI_PROCESS_ROUTE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5070 Process Routes Transactional, Reuse Component Process Routes is a reusable application component to provide workflow capabilities including parallel tasks, sequential tasks, ad-hoc tasks, and background tasks which can be loaded automatically into consumer apps based on business rule framework.

Process Routes

Business Role: Development Manager - Discrete Industries

Users can manage process route tasks of the change record; setting processing times or deadlines, priorities and the recipients (agents) to each. Tasks can be parallel or sequential and can be added ad-hoc or via a template, executed by the user or in the background. Users can configure the change record to use the new advanced process route (based on BRFplus) for a change record type by selecting the Proc.Route checkbox in Customizing activity Define Engineering Change Record Types. In this case, no SAP Business Workflow scenario is required, as that is related to the simple workflow. Process route based on BRFplus will use the workflow template defined via Global Process Route Templates Workbench application. Power users can create global templates which can be used across change record types and transported across the landscape. Templates can have parallel or sequential tasks, either executed in the background or by the user.

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ProcessRouteActivityArea ProcessRouteActivityArea
KEY ProcessRoute ProcessRoute
KEY ProcessRouteTask ProcessRouteTask
KEY ProcessRouteTaskRowKey ProcessRouteTaskRowKey
WorkflowTaskInternalID WorkflowTaskInternalID Work Item ID
ProcessRouteLatestEndDate ProcessRouteLatestEndDate
ProcessRouteLatestEndTime ProcessRouteLatestEndTime
ProcessRouteProcgTimeInDays ProcessRouteProcgTimeInDays
ProcessRouteCurrentAgent ProcessRouteCurrentAgent
ProcessRouteTaskIsDeleted ProcessRouteTaskIsDeleted
ProcessRouteTaskStatus ProcessRouteTaskStatus
ProcessRouteAgent ProcessRouteAgent
ProcessRouteAgentType ProcessRouteAgentType
ProcessRouteActivity ProcessRouteActivity
WorkflowTaskPriority WorkflowTaskPriority
ProcessRouteTaskBackgroundSrvc ProcessRouteTaskBackgroundSrvc
ProcessRouteTaskNodeType ProcessRouteTaskNodeType
SrvProInfObjectType
SAPObjectType
_WorkflowTask _WorkflowTask
_ProcessRouteTaskAgentType _ProcessRouteTaskAgentType
_ProcessRouteTaskBackgroundSrv _ProcessRouteTaskBackgroundSrv
_ProcessRouteObjectActivityVH _ProcessRouteObjectActivityVH

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 C_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.

CREATE VIEW C_ProcessRouteTask AS
SELECT
  ProcessRouteActivityArea,
  ProcessRoute,
  ProcessRouteTask,
  ProcessRouteTaskRowKey,
  WorkflowTaskInternalID,
  ProcessRouteLatestEndDate,
  ProcessRouteLatestEndTime,
  ProcessRouteProcgTimeInDays,
  ProcessRouteCurrentAgent,
  ProcessRouteTaskIsDeleted,
  ProcessRouteTaskStatus,
  ProcessRouteAgent,
  ProcessRouteAgentType,
  ProcessRouteActivity,
  WorkflowTaskPriority,
  ProcessRouteTaskBackgroundSrvc,
  ProcessRouteTaskNodeType,
  _ProcessRoute._ProcRouteObjAssignment.SrvProInfObjectType AS SrvProInfObjectType,
  _ProcessRoute._ProcRouteObjAssignment.SAPObjectType AS SAPObjectType
FROM I_ProcessRouteTaskTP
LEFT OUTER JOIN C_ProcessRouteObjectActivityVH AS _ProcessRouteObjectActivityVH ON _ProcessRouteObjectActivityVH.ProcessRouteActivityArea = ProcessRouteActivityArea AND _ProcessRouteObjectActivityVH.ProcessRouteActivity = ProcessRouteActivity  -- association [0..*]
;

Learn More