I_WORKFLOWTASKCOUNT
Exposes the number of tasks
I_WORKFLOWTASKCOUNT is a CDS View in S/4HANA. Exposes the number of tasks. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_WorkflowStatusOverview | view | left_outer | COMPOSITE | Workflow |
@AbapCatalog.sqlViewName: 'IWRKFLWTSKCNT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Exposes the number of tasks'
define view I_WorkflowTaskCount
as select from swwwihead
{
key top_wi_id as WorkflowInternalID,
wi_stat as WorkflowTaskExternalStatus,
count( * ) as NumberOfWorkflowDialogTasks
}
where
wi_type = 'W'
group by
top_wi_id,
wi_stat
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SWWWIHEAD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/