I_WorkflowTaskTitle

DDL: I_WORKFLOWTASKTITLE Type: view BASIC

Work item title

I_WorkflowTaskTitle is a Basic CDS View that provides data about "Work item title" in SAP S/4HANA. It reads from 4 data sources (swwwihead, swwwihead, swwwitext, swf_flex_text) and exposes 7 fields with key fields Language, WorkflowTaskInternalID, WorkflowTaskInternalID. It has 1 association to related views. It is exposed through 1 OData service (PLMI_PROCESS_ROUTE). It is used in 1 Fiori application: Process Routes.

4 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
swwwihead head union
swwwihead swwwihead inner
swwwitext swwwitext from
swf_flex_text text inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWFTASKTITLE view
AbapCatalog.buffering.type #NONE view
EndUserText.label Work item title view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L 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 (7)

KeyFieldSource TableSource FieldDescription
KEY Language swwwitext wi_lang
KEY WorkflowTaskInternalID swwwitext wi_id
WorkflowTaskName swwwitext wi_text
languasLanguage
KEY WorkflowTaskInternalID swwwihead wi_id
WorkflowTaskName
_Language _Language 
@AbapCatalog : {
 sqlViewName: 'IWFTASKTITLE',
 buffering.type: #NONE
}
@EndUserText.label: 'Work item title'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType : {
  dataClass: #CUSTOMIZING,
  serviceQuality: #A,
  sizeCategory: #L
}
define view I_WorkflowTaskTitle
  as select from swwwitext
    inner join   swwwihead on swwwitext.wi_id        = swwwihead.wi_id
                           and(
                             swwwihead.wi_text_id    = ''
                             or swwwihead.wi_text_id is null
                           )

  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language //_Language.Language


{
  key swwwitext.wi_lang as Language,
  key swwwitext.wi_id   as WorkflowTaskInternalID,
//      swwwitext.wi_text as WorkflowTaskName,   DDIC consistency problem

//      cast ( swwwitext.wi_text as swf_flex_text_text ) as WorkflowTaskName,  Internal Incident: 2270089447 

       swwwitext.wi_text  as WorkflowTaskName,
      
      _Language

}

union select from swwwihead     as head
  inner join      swf_flex_text as text on head.wi_text_id = text.id

association [0..1] to I_Language as _Language on $projection.Language = _Language.Language   //_Language.Language


{
  key text.langu as Language,
  key head.wi_id as WorkflowTaskInternalID,
//      text.text  as WorkflowTaskName,

        cast ( substring( text.text, 1, 120 ) as sww_witext ) as WorkflowTaskName,
        
      _Language
}

Learn More