I_ProcessRouteTemplate

DDL: I_PROCESSROUTETEMPLATE SQL: IPROCESSROUTTMPL Type: view BASIC Package: VDM_PLMB_PR

Process route template

I_ProcessRouteTemplate is a Basic CDS View that provides data about "Process route template" in SAP S/4HANA. It reads from 2 data sources (srmwfsearch, srmwfpathgroup) and exposes 7 fields with key fields ProcessRouteActivityArea, ProcessRoute. It is exposed through 1 OData service (PLMI_PROCESS_ROUTE). Part of development package VDM_PLMB_PR.

2 data source(s) Exposed by 1 service(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
srmwfsearch ProcessRouteTemplate from
srmwfpathgroup ProcessRouteTmplGroup inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPROCESSROUTTMPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process route template view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

OData Services (1)

ServiceBindingVersionContractRelease
PLMI_PROCESS_ROUTE PLMI_PROCESS_ROUTE V2 C1 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ProcessRouteActivityArea srmwfsearch actarea
KEY ProcessRoute srmwfsearch pathid
ProcessRouteDescription srmwfsearch pathdesc
CreatedByUser srmwfsearch creator
CreationDate srmwfsearch creadate
CreationTime srmwfsearch creatime
obj_typeendasSrvProInfObjectType 
@AbapCatalog.sqlViewName: 'IPROCESSROUTTMPL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Process route template'
@ClientHandling.algorithm             : #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations : true
@ObjectModel.usageType.sizeCategory   : #L
@ObjectModel.usageType.serviceQuality : #B
@ObjectModel.usageType.dataClass      : #TRANSACTIONAL
@VDM.viewType                : #BASIC

define view I_ProcessRouteTemplate
  //with parameters p_ObjectType:/plmb/gos_object_type

  as select from           srmwfsearch      as ProcessRouteTemplate
    left outer to one join /plmb/pr_obj_rel as ProcessRouteObjAssignment on  ProcessRouteObjAssignment.actarea  = ProcessRouteTemplate.actarea
                                                                         and ProcessRouteObjAssignment.route_id = ProcessRouteTemplate.pathid
    inner join             srmwfpathgroup   as ProcessRouteTmplGroup     on  ProcessRouteTmplGroup.actarea = ProcessRouteTemplate.actarea
                                                                         and ProcessRouteTmplGroup.pathid  = ProcessRouteTemplate.pathid
{
      @UI.hidden: true
  key ProcessRouteTemplate.actarea  as ProcessRouteActivityArea,
  key ProcessRouteTemplate.pathid   as ProcessRoute,
      ProcessRouteTemplate.pathdesc as ProcessRouteDescription,
      ProcessRouteTemplate.creator  as CreatedByUser,
      ProcessRouteTemplate.creadate as CreationDate,
      ProcessRouteTemplate.creatime as CreationTime,
      @UI.hidden: true
      case
           when ProcessRouteObjAssignment.obj_type is null then 'EMPTY'
           else  ProcessRouteObjAssignment.obj_type
      end                           as SrvProInfObjectType

}
where
      ProcessRouteTemplate.tmplflag = 'X'
  and ProcessRouteTemplate.spras    = $session.system_language

Learn More