I_ProcessRoute

DDL: I_PROCESSROUTE SQL: IPROCESSROUTE Type: view BASIC Package: VDM_PLMB_PR
25 Fields 1 Data Sources 8 Associations

Process Route

I_ProcessRoute is a Basic CDS View that provides data about "Process Route" in SAP S/4HANA. It reads from 1 data source (srmwfpath) and exposes 25 fields with key fields ProcessRouteActivityArea, ProcessRoute. It has 8 associations to related views. Part of development package VDM_PLMB_PR.

Data Sources (1)

SourceAliasJoin Type
srmwfpath ProcessRoute from

Associations (8)

CardinalityTargetAliasCondition
[0..*] I_ProcessRouteTask _ProcessRouteTask $projection.ProcessRouteActivityArea = _ProcessRouteTask.ProcessRouteActivityArea and $projection.ProcessRoute = _ProcessRouteTask.ProcessRoute
[0..1] I_ProcessRouteObjAssignment _ProcessRouteObjAssignment $projection.ProcessRouteActivityArea = _ProcessRouteObjAssignment.ProcessRouteActivityArea and $projection.ProcessRoute = _ProcessRouteObjAssignment.ProcessRoute
[0..*] I_ProcessRouteDdlnRecipient _ProcessRouteDdlnRecipient $projection.ProcessRouteActivityArea = _ProcessRouteDdlnRecipient.ProcessRouteActivityArea and $projection.ProcessRoute = _ProcessRouteDdlnRecipient.ProcessRoute
[0..*] I_ProcessRouteDescription _ProcessRouteDescription $projection.ProcessRouteActivityArea = _ProcessRouteDescription.ProcessRouteActivityArea and $projection.ProcessRoute = _ProcessRouteDescription.ProcessRoute
[0..*] I_FactoryCalendarText _FactoryCalendarName $projection.FactoryCalendar = _FactoryCalendarName.FactoryCalendar
[0..1] I_User _UserDescription $projection.CreatedByUser = _UserDescription.UserID
[0..*] I_ProcessRouteStatusText _ProcessRouteStatusText $projection.ProcessRouteStatus = _ProcessRouteStatusText.ProcessRouteStatus
[0..1] I_User _UserTerminatorDescription $projection.CompletedByUser = _UserTerminatorDescription.UserID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPROCESSROUTE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
EndUserText.label Process Route view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProcessRouteActivityArea srmwfpath actarea Activity Area
KEY ProcessRoute srmwfpath pathid Route ID
ProcessRouteStatus srmwfpath status Workflow Status
CreatedByUser srmwfpath creator User ID
CreationDate srmwfpath creadate Creation Date
CreationTime srmwfpath creatime Creation Time
FactoryCalendar srmwfpath facca Factory Cal. ID
ProcRteDdlnRecipientIsInitr srmwfpath deadl_init Initiator
ProcRteDdlnRcpntIsCurProcsr srmwfpath deadl_actual Current Proc.
ProcRteDdlnRcpntIsNextProcsr srmwfpath deadl_next Next processors
ProcRteDdlnAddlProcsrStsCode srmwfpath deadl_more Other...
WorkflowInternalID srmwfpath wiid Wfl. Work Item ID
CreatedByUserName _UserDescription UserDescription Full Name
ProcessRouteDescription
FactoryCalendarName
CompletedByUser srmwfpath terminator Ended By
UserDisplayName _UserTerminatorDescription UserDescription Full Name
_ProcessRouteTask _ProcessRouteTask
_ProcessRouteObjAssignment _ProcessRouteObjAssignment
_ProcessRouteDdlnRecipient _ProcessRouteDdlnRecipient
_ProcessRouteDescription _ProcessRouteDescription
_ProcessRouteStatusText _ProcessRouteStatusText
_UserDescription _UserDescription
_UserTerminatorDescription _UserTerminatorDescription
_FactoryCalendarName _FactoryCalendarName

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_ProcessRoute.
-- 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: IPROCESSROUTE

CREATE VIEW I_ProcessRoute AS
SELECT
  ProcessRoute.actarea AS ProcessRouteActivityArea,
  ProcessRoute.pathid AS ProcessRoute,
  ProcessRoute.status AS ProcessRouteStatus,
  ProcessRoute.creator AS CreatedByUser,
  ProcessRoute.creadate AS CreationDate,
  ProcessRoute.creatime AS CreationTime,
  ProcessRoute.facca AS FactoryCalendar,
  ProcessRoute.deadl_init AS ProcRteDdlnRecipientIsInitr,
  ProcessRoute.deadl_actual AS ProcRteDdlnRcpntIsCurProcsr,
  ProcessRoute.deadl_next AS ProcRteDdlnRcpntIsNextProcsr,
  ProcessRoute.deadl_more AS ProcRteDdlnAddlProcsrStsCode,
  ProcessRoute.wiid AS WorkflowInternalID,
  _UserDescription.UserDescription AS CreatedByUserName,
  _ProcessRouteDescription[1:Language = $session.system_language].ProcessRouteDescription AS ProcessRouteDescription,
  _FactoryCalendarName[1:Language = $session.system_language].FactoryCalendarName AS FactoryCalendarName,
  ProcessRoute.terminator AS CompletedByUser,
  _UserTerminatorDescription.UserDescription AS UserDisplayName
FROM srmwfpath AS ProcessRoute
LEFT OUTER JOIN I_ProcessRouteTask AS _ProcessRouteTask ON ProcessRouteActivityArea = _ProcessRouteTask.ProcessRouteActivityArea AND ProcessRoute = _ProcessRouteTask.ProcessRoute  -- association [0..*]
LEFT OUTER JOIN I_ProcessRouteObjAssignment AS _ProcessRouteObjAssignment ON ProcessRouteActivityArea = _ProcessRouteObjAssignment.ProcessRouteActivityArea AND ProcessRoute = _ProcessRouteObjAssignment.ProcessRoute  -- association [0..1]
LEFT OUTER JOIN I_ProcessRouteDdlnRecipient AS _ProcessRouteDdlnRecipient ON ProcessRouteActivityArea = _ProcessRouteDdlnRecipient.ProcessRouteActivityArea AND ProcessRoute = _ProcessRouteDdlnRecipient.ProcessRoute  -- association [0..*]
LEFT OUTER JOIN I_ProcessRouteDescription AS _ProcessRouteDescription ON ProcessRouteActivityArea = _ProcessRouteDescription.ProcessRouteActivityArea AND ProcessRoute = _ProcessRouteDescription.ProcessRoute  -- association [0..*]
LEFT OUTER JOIN I_FactoryCalendarText AS _FactoryCalendarName ON FactoryCalendar = _FactoryCalendarName.FactoryCalendar  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserDescription ON CreatedByUser = _UserDescription.UserID  -- association [0..1]
LEFT OUTER JOIN I_ProcessRouteStatusText AS _ProcessRouteStatusText ON ProcessRouteStatus = _ProcessRouteStatusText.ProcessRouteStatus  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserTerminatorDescription ON CompletedByUser = _UserTerminatorDescription.UserID  -- association [0..1]
;

Learn More