C_ProcessRouteTask

DDL: C_PROCESSROUTETASK Type: view_entity CONSUMPTION
24 Fields 1 Data Sources 1 Associations

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 24 fields with key fields ProcessRouteActivityArea, ProcessRoute, ProcessRouteTask, ProcessRouteTaskRowKey. It has 1 association to related views.

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

Fields (24)

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
ProcessRouteAgentDescription ProcessRouteAgentDescription Name
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,
  ProcessRouteAgentDescription,
  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