I_CAWorkflowTaskURL

DDL: I_CAWORKFLOWTASKURL Type: view BASIC

Workflow work item URL

I_CAWorkflowTaskURL is a Basic CDS View that provides data about "Workflow work item URL" in SAP S/4HANA. It reads from 1 data source (swwwihead) and exposes 1 field with key field WorkflowTaskInternalID.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
swwwihead head from

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ICAWRKFLWTASKURL view
AbapCatalog.buffering.status #SWITCHED_OFF view
AbapCatalog.buffering.type #NONE view
EndUserText.label Workflow work item URL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID swwwihead wi_id 
@AbapCatalog : {
compiler.compareFilter: true,
preserveKey: true,
sqlViewName: 'ICAWRKFLWTASKURL',
  buffering.status: #SWITCHED_OFF,
  buffering.type: #NONE
  }
@EndUserText.label: 'Workflow work item URL'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view I_CAWorkflowTaskURL
  as select from    swwwihead      as head
    left outer to one join swp_url_config as WorkflowTaskURLConfig on WorkflowTaskURLConfig.id = 'MYINBOX'
{
  key head.wi_id as WorkflowTaskInternalID,
      case
        when WorkflowTaskURLConfig.flp_client is not initial // include parameter sap-client

        then cast( concat(WorkflowTaskURLConfig.protocol,
                     concat('://',

                       concat(WorkflowTaskURLConfig.host,
                         concat(':',
                           concat(WorkflowTaskURLConfig.port,
                             concat(WorkflowTaskURLConfig.flp_alias,
                               concat('?sap-client=',
                                 concat(WorkflowTaskURLConfig.flp_client,
                                   concat('&sap-ushell-config=headerless#CAWorkflowTask-displayTasks?scenarioId=SFICA&standaloneDetailDeep=true&/detail_deep/',
                                     concat(WorkflowTaskURLConfig.param,
                                       concat('/',
                                         concat(head.wi_id,
                                           concat('/TaskCollection(SAP__Origin=''',
                                             concat(WorkflowTaskURLConfig.param,
                                               concat(''',',
                                                 concat('InstanceID=''',
                                                   concat(head.wi_id, ''')'
                                                         )
                                                       )
                                                     )
                                                   )
                                                 )
                                               )
                                             )
                                           )
                                         )
                                       )
                                     )
                                   )
                                 )
                               )
                             )
                           )
                         )
             as swf_workflow_task_url )
        else cast( concat(WorkflowTaskURLConfig.protocol,
                     concat('://',

                       concat(WorkflowTaskURLConfig.host,
                         concat(':',
                           concat(WorkflowTaskURLConfig.port,
                             concat(WorkflowTaskURLConfig.flp_alias,
                               concat('?sap-ushell-config=headerless#CAWorkflowTask-displayTasks?scenarioId=SFICA&standaloneDetailDeep=true&/detail_deep/',
                                 concat(WorkflowTaskURLConfig.param,
                                   concat('/',
                                     concat(head.wi_id,
                                       concat('/TaskCollection(SAP__Origin=''',
                                         concat(WorkflowTaskURLConfig.param,
                                           concat(''',',
                                             concat('InstanceID=''',
                                               concat(head.wi_id, ''')'
                                                     )
                                                   )
                                                 )
                                               )
                                             )
                                           )
                                         )
                                       )
                                     )
                                   )
                                 )
                               )
                             )
                           )
                         )
             as swf_workflow_task_url )
      end        as WorkflowTaskURL

}
where
  head.wi_type = 'W' // Dialog Work Item; Represents a Single-Step Task

Learn More