I_ProcessRouteTaskAgent

DDL: I_PROCESSROUTETASKAGENT SQL: IPRTASKAGNTDESC Type: view BASIC

Process Route Task Agent Description

I_ProcessRouteTaskAgent is a Basic CDS View that provides data about "Process Route Task Agent Description" in SAP S/4HANA. It reads from 1 data source (srmpathorgt) and exposes 5 fields with key fields Language, ProcessRouteActivityArea, ProcessRouteAgentType. It has 2 associations 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
srmpathorgt Agent from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] srmpathorg AgentType $projection.ProcessRouteActivityArea = AgentType.actarea and $projection.ProcessRouteAgentType = AgentType.obj_type

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPRTASKAGNTDESC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Process Route Task Agent Description view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S 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 (5)

KeyFieldSource TableSource FieldDescription
KEY Language srmpathorgt spras Off. Language
KEY ProcessRouteActivityArea srmpathorgt actarea Activity Area
KEY ProcessRouteAgentType srmpathorgt obj_type Type
ProcessRouteAgentTypeDesc srmpathorgt objtype_desc User Type Text
_Language _Language

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_ProcessRouteTaskAgent.
-- 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: IPRTASKAGNTDESC

CREATE VIEW I_ProcessRouteTaskAgent AS
SELECT
  Agent.spras AS Language,
  Agent.actarea AS ProcessRouteActivityArea,
  Agent.obj_type AS ProcessRouteAgentType,
  Agent.objtype_desc AS ProcessRouteAgentTypeDesc
FROM srmpathorgt AS Agent
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN srmpathorg AS AgentType ON ProcessRouteActivityArea = AgentType.actarea AND ProcessRouteAgentType = AgentType.obj_type  -- association [1..1]
;