I_ChgRecordProcessRouteDEX

DDL: I_CHGRECORDPROCESSROUTEDEX Type: view_entity BASIC
18 Fields 1 Data Sources 2 Associations

Change Record Process Route

I_ChgRecordProcessRouteDEX (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

ChangeRecordProcessRoute · Product Lifecycle Management

I_ChgRecordProcessRouteDEX is a Basic CDS View that provides data about "Change Record Process Route" in SAP S/4HANA. It reads from 1 data source (I_ProcessRouteObjAssignment) and exposes 18 fields with key fields ProcessRouteActivityArea, ProcessRoute. It has 2 associations to related views.

SAP Help Documentation

CategoryChange Record
Purpose
This CDS view helps to retrieve process route information for change records. Note This CDS view is released to provide data extraction for SAP Business Data Cloud data products only, and any other use is not supported.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: S_SRMPATH1 (SRM - Process Route)

Structure
Important Fields Important fields in this view include the following: Field Name Description ProcessRouteActivityArea Activity Area ProcessRoute Process Route ID

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessProduct Lifecycle Management
Application ComponentPLM-CR
CapabilitiesData Source for Data Extraction
PackageProduct Lifecycle Management for SAP S/4HANA Cloud Private Edition
Description This CDS view helps to retrieve process route information for change records.

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ProcessRouteObjAssignment ProcessRouteObjAssignment from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProcessRoute _ProcessRoute $projection.ProcessRouteActivityArea = _ProcessRoute.ProcessRouteActivityArea and $projection.ProcessRoute = _ProcessRoute.ProcessRoute
[0..1] I_ProcessRouteSAPObjectTypeMap _ProcessRouteSAPObjectTypeMap ProcessRouteObjAssignment.SrvProInfObjectType = _ProcessRouteSAPObjectTypeMap.SrvProInfObjectType

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Change Record Process Route view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #BASIC view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name ChangeRecordProcessRoute view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProcessRouteActivityArea I_ProcessRouteObjAssignment ProcessRouteActivityArea Activity Area
KEY ProcessRoute I_ProcessRouteObjAssignment ProcessRoute Process Route ID
ProcessRouteStatus _ProcessRoute ProcessRouteStatus Process Route Status
CreatedByUser _ProcessRoute CreatedByUser Name of Process Route Creator
CreationDate _ProcessRoute CreationDate Date Process Route Created
CreationTime _ProcessRoute CreationTime Time Process Route Created
FactoryCalendar _ProcessRoute FactoryCalendar Factory Calendar
ProcessRouteDescription _ProcessRoute ProcessRouteDescription Description of Process Route
FactoryCalendarName _ProcessRoute FactoryCalendarName Factory Calendar Text
ProcRteDdlnRecipientIsInitr _ProcessRoute ProcRteDdlnRecipientIsInitr Initiator is Recipient of Appointment Monitoring
ProcRteDdlnRcpntIsCurProcsr _ProcessRoute ProcRteDdlnRcpntIsCurProcsr Current Processor is Recipient of Appointment Monitoring
ProcRteDdlnRcpntIsNextProcsr _ProcessRoute ProcRteDdlnRcpntIsNextProcsr Subsequent Processors are Recipients of Appt. Monitoring
ProcRteDdlnOtherRcpntCode _ProcessRoute ProcRteDdlnAddlProcsrStsCode Are additional processors defined?
WorkflowWorkItem Process Route Workflow ID
CreatedByUserName _ProcessRoute CreatedByUserName Created by Username
ProcessRouteStatusDescription _ProcessRoute ProcessRouteStatusDescription
SAPObjectTechnicalID I_ProcessRouteObjAssignment SrvProInfObject Transaction ID
SAPObjectType _ProcessRouteSAPObjectTypeMap SAPObjectType SAP Object Type

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_ChgRecordProcessRouteDEX.
-- 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 I_ChgRecordProcessRouteDEX AS
SELECT
  ProcessRouteObjAssignment.ProcessRouteActivityArea AS ProcessRouteActivityArea,
  ProcessRouteObjAssignment.ProcessRoute AS ProcessRoute,
  _ProcessRoute.ProcessRouteStatus AS ProcessRouteStatus,
  _ProcessRoute.CreatedByUser AS CreatedByUser,
  _ProcessRoute.CreationDate AS CreationDate,
  _ProcessRoute.CreationTime AS CreationTime,
  _ProcessRoute.FactoryCalendar AS FactoryCalendar,
  _ProcessRoute.ProcessRouteDescription AS ProcessRouteDescription,
  _ProcessRoute.FactoryCalendarName AS FactoryCalendarName,
  _ProcessRoute.ProcRteDdlnRecipientIsInitr AS ProcRteDdlnRecipientIsInitr,
  _ProcessRoute.ProcRteDdlnRcpntIsCurProcsr AS ProcRteDdlnRcpntIsCurProcsr,
  _ProcessRoute.ProcRteDdlnRcpntIsNextProcsr AS ProcRteDdlnRcpntIsNextProcsr,
  _ProcessRoute.ProcRteDdlnAddlProcsrStsCode AS ProcRteDdlnOtherRcpntCode,
  cast ( _ProcessRoute.WorkflowInternalID as process_route_workflow_id ) AS WorkflowWorkItem,
  _ProcessRoute.CreatedByUserName AS CreatedByUserName,
  _ProcessRoute.ProcessRouteStatusDescription AS ProcessRouteStatusDescription,
  ProcessRouteObjAssignment.SrvProInfObject AS SAPObjectTechnicalID,
  _ProcessRouteSAPObjectTypeMap.SAPObjectType AS SAPObjectType
FROM I_ProcessRouteObjAssignment AS ProcessRouteObjAssignment
LEFT OUTER JOIN I_ProcessRoute AS _ProcessRoute ON ProcessRouteActivityArea = _ProcessRoute.ProcessRouteActivityArea AND ProcessRoute = _ProcessRoute.ProcessRoute  -- association [0..1]
LEFT OUTER JOIN I_ProcessRouteSAPObjectTypeMap AS _ProcessRouteSAPObjectTypeMap ON ProcessRouteObjAssignment.SrvProInfObjectType = _ProcessRouteSAPObjectTypeMap.SrvProInfObjectType  -- association [0..1]
;

Learn More