C_Workflowtask

DDL: C_WORKFLOWTASK SQL: CWORKFLOWTASK Type: view CONSUMPTION

DEPRECATED: Work item with text info

C_Workflowtask is a Consumption CDS View that provides data about "DEPRECATED: Work item with text info" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 22 fields with key field WorkflowTaskInternalID.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask I_WorkflowTask from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CWORKFLOWTASK view
EndUserText.label DEPRECATED: Work item with text info view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID
system_languageaslangendasLanguage
TaskLeadingObjectCategory
TaskLeadingObjectType
TaskLeadingObjectInstance
LanguageISOCodeendasLanguageISOCode
LanguageNameendasLanguageText
WorkflowTaskNameendasTaskName
WorkflowTaskType I_WorkflowTask WorkflowTaskType
TaskTypeText
TaskPriority I_WorkflowTask WorkflowTaskPriority
TaskPriorityText
TaskStatus I_WorkflowTask WorkflowTaskStatus
TaskStatusText
TaskCreateUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime
TaskCompletionUTCDateTime I_WorkflowTask WrkflwTskCompletionUTCDateTime
TopLevelTask I_WorkflowTask TopLevelWorkflowTask
ParentTask I_WorkflowTask ParentWorkflowTask
TaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser
TaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser
TaskDefinition I_WorkflowTask WorkflowTaskDefinition
TopLevelTaskDefinition I_WorkflowTask TopLevelWorkflowTaskDefinition 
@AbapCatalog.sqlViewName: 'CWORKFLOWTASK'
@EndUserText.label: 'DEPRECATED: Work item with text info'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
define view C_Workflowtask
  as select from I_WorkflowTask
{
  key WorkflowTaskInternalID                                                                                                                as WorkflowTaskInternalID,
      case when I_WorkflowTask._TaskTitle[1:Language=$session.system_language].WorkflowTaskName is null 
        then _WorkflowTaskTitleFallback.Language
        else cast( $session.system_language as lang )  
      end as Language,
      
      I_WorkflowTask._TaskApplicationLeadingObject.TechnicalWrkflwObjectCategory                                                            as TaskLeadingObjectCategory,
      I_WorkflowTask._TaskApplicationLeadingObject.TechnicalWrkflwObjectType                                                                as TaskLeadingObjectType,
      I_WorkflowTask._TaskApplicationLeadingObject.TechnicalWrkflwObject                                                                    as TaskLeadingObjectInstance,
      
      case when I_WorkflowTask._TaskTitle[1:Language=$session.system_language].WorkflowTaskName is null 
        then _WorkflowTaskTitleFallback.LanguageISOCode
        else I_WorkflowTask._TaskType._Text[1:Language=$session.system_language]._Language.LanguageISOCode
      end as LanguageISOCode,
      
      case when I_WorkflowTask._TaskTitle[1:Language=$session.system_language].WorkflowTaskName is null 
        then _WorkflowTaskTitleFallback.LanguageName
        else I_WorkflowTask._TaskType._Text[1:Language=$session.system_language]._Language._Text[1:Language=$session.system_language].LanguageName
      end as LanguageText,
      
      case when I_WorkflowTask._TaskTitle[1:Language=$session.system_language].WorkflowTaskName is null 
        then _WorkflowTaskTitleFallback.WorkflowTaskName
        else I_WorkflowTask._TaskTitle[1:Language=$session.system_language].WorkflowTaskName
      end as TaskName,
      
      I_WorkflowTask.WorkflowTaskType                                                                                                       as WorkflowTaskType,
      I_WorkflowTask._TaskType._Text[1:Language=$session.system_language].WorkflowTaskTypeDesc                                              as TaskTypeText,
      I_WorkflowTask.WorkflowTaskPriority                                                                                                   as TaskPriority,
      I_WorkflowTask._TaskPriority._Text[1:Language=$session.system_language].WorkflowTaskPriorityDesc                                      as TaskPriorityText,
      I_WorkflowTask.WorkflowTaskStatus                                                                                                     as TaskStatus,
      I_WorkflowTask._TaskStatus._Text[1:Language=$session.system_language].WorkflowTaskStatusDesc                                          as TaskStatusText,
      I_WorkflowTask.WrkflwTskCreationUTCDateTime                                                                                           as TaskCreateUTCDateTime,
      I_WorkflowTask.WrkflwTskCompletionUTCDateTime                                                                                         as TaskCompletionUTCDateTime,
      I_WorkflowTask.TopLevelWorkflowTask                                                                                                   as TopLevelTask,
      I_WorkflowTask.ParentWorkflowTask                                                                                                     as ParentTask,
      I_WorkflowTask.WorkflowTaskCreatedByUser                                                                                              as TaskCreatedByUser,
      I_WorkflowTask.WorkflowTaskCurrentUser                                                                                                as TaskCurrentUser,
      I_WorkflowTask.WorkflowTaskDefinition                                                                                                 as TaskDefinition,
      //      I_WorkflowTask._TaskDefinition._text[1:Language=$session.system_language].WorkflowTaskDefinitionDesc                                  as TaskDefinitionText,

      I_WorkflowTask.TopLevelWorkflowTaskDefinition                                                                                         as TopLevelTaskDefinition
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LANGUAGE",
"I_LANGUAGETEXT",
"I_WORKFLOWTASK",
"I_WORKFLOWTASKLEADINGAPPLOBJ",
"I_WORKFLOWTASKPRIORITY",
"I_WORKFLOWTASKPRIORITYTEXT",
"I_WORKFLOWTASKSTATUS",
"I_WORKFLOWTASKSTATUSTEXT",
"I_WORKFLOWTASKTITLE",
"I_WORKFLOWTASKTITLEFALLBACK",
"I_WORKFLOWTASKTYPE",
"I_WORKFLOWTASKTYPETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More