C_Workflowtask

DDL: C_WORKFLOWTASK SQL: CWORKFLOWTASK Type: view CONSUMPTION
22 Fields 1 Data Sources

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.

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 Work Item ID
system_languageaslangendasLanguage
TaskLeadingObjectCategory
TaskLeadingObjectType
TaskLeadingObjectInstance
LanguageISOCodeendasLanguageISOCode
LanguageNameendasLanguageText
WorkflowTaskNameendasTaskName
WorkflowTaskType I_WorkflowTask WorkflowTaskType Type
TaskTypeText
TaskPriority I_WorkflowTask WorkflowTaskPriority Priority
TaskPriorityText
TaskStatus I_WorkflowTask WorkflowTaskStatus Status
TaskStatusText
TaskCreateUTCDateTime I_WorkflowTask WrkflwTskCreationUTCDateTime Created On
TaskCompletionUTCDateTime I_WorkflowTask WrkflwTskCompletionUTCDateTime Completed
TopLevelTask I_WorkflowTask TopLevelWorkflowTask Top Level Workflow
ParentTask I_WorkflowTask ParentWorkflowTask Workflow
TaskCreatedByUser I_WorkflowTask WorkflowTaskCreatedByUser Creator
TaskCurrentUser I_WorkflowTask WorkflowTaskCurrentUser Agent
TaskDefinition I_WorkflowTask WorkflowTaskDefinition Task
TopLevelTaskDefinition I_WorkflowTask TopLevelWorkflowTaskDefinition Top Task

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Workflowtask.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CWORKFLOWTASK

CREATE VIEW C_Workflowtask AS
SELECT
  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 AS system_languageaslangendasLanguage,
  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 AS LanguageISOCodeendasLanguageISOCode,
  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 AS LanguageNameendasLanguageText,
  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 AS WorkflowTaskNameendasTaskName,
  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.TopLevelWorkflowTaskDefinition AS TopLevelTaskDefinition
FROM I_WorkflowTask
;

Learn More