C_ProcessRouteTaskPriority

DDL: C_PROCESSROUTETASKPRIORITY SQL: CPRTASKPRIORITY Type: view CONSUMPTION

Process Route Task Priority

C_ProcessRouteTaskPriority is a Consumption CDS View that provides data about "Process Route Task Priority" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field WorkflowTaskPriority.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l FixedValue from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPRTASKPRIORITY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Process Route Task Priority view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskPriority
WorkflowTaskPriorityDesc ValueText ddtext 
@AbapCatalog.sqlViewName: 'CPRTASKPRIORITY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Process Route  Task Priority'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel : { resultSet.sizeCategory: #XS }
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true

//define view C_ProcessRouteTaskPriority

//  as select from I_WorkflowTaskPriority

//{

//      @ObjectModel.text.element: ['WorkflowTaskPriorityDesc']

//  key cast ( WorkflowTaskPriority  as sww_prio  )                           as WorkflowTaskPriority,

//      @Semantics.text: true

//      _Text[1:Language = $session.system_language].WorkflowTaskPriorityDesc as WorkflowTaskPriorityDesc

//}

//where WorkflowTaskPriority = '2' or

//      WorkflowTaskPriority = '4' or

//      WorkflowTaskPriority = '5' or

//      WorkflowTaskPriority = '6'

define view C_ProcessRouteTaskPriority
  as select from           dd07l as FixedValue
    left outer to one join dd07t as ValueText on  FixedValue.domname    = ValueText.domname
                                              and FixedValue.domvalue_l = ValueText.domvalue_l
                                              and FixedValue.as4local   = ValueText.as4local
{
      @ObjectModel.text.element: ['WorkflowTaskPriorityDesc']
  key cast ( FixedValue.domvalue_l  as sww_prio  ) as WorkflowTaskPriority,
      @Semantics.text: true
      ValueText.ddtext                             as WorkflowTaskPriorityDesc
}
where
      FixedValue.as4local  = 'A' -- Active
  and FixedValue.domname   = '/PLMB/PR_TASK_PRIORITY'
  and ValueText.ddlanguage = $session.system_language

Learn More