I_ADM_WORKFLOWTASK_BASE

DDL: I_ADM_WORKFLOWTASK_BASE Type: view BASIC
16 Fields 1 Data Sources 4 Associations

Workflow work items

I_ADM_WORKFLOWTASK_BASE is a Basic CDS View that provides data about "Workflow work items" in SAP S/4HANA. It reads from 1 data source (swwwihead) and exposes 16 fields with key field WorkflowTaskInternalID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
swwwihead head from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_WorkflowTaskResult _WorkflowTaskResult $projection.TopLevelWorkflowTask = _WorkflowTaskResult.WorkflowInternalID and $projection.WorkflowTaskInternalID = _WorkflowTaskResult.WorkflowTaskInternalID
[0..*] I_WorkflowTaskTitle _TaskTitle $projection.WorkflowTaskInternalID = _TaskTitle.WorkflowTaskInternalID
[0..1] I_WorkflowStepResult _WorkflowTaskStepResult $projection.TopLevelWorkflowTaskDefinition = _WorkflowTaskStepResult.WorkflowScenarioDefinition and $projection.WorkflowTaskDefinitionVersion = _WorkflowTaskStepResult.WorkflowScenarioDefinitionVers and $projection.WorkflowTaskStepType = _WorkflowTaskStepResult.WorkflowStepType and $projection.workflowtaskresult = _WorkflowTaskStepResult.WorkflowStepResult
[0..1] I_WorkflowTaskTitleFallback _WorkflowTaskTitleFallback $projection.WorkflowTaskInternalID = _WorkflowTaskTitleFallback.WorkflowTaskInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IADMWRKFLWTASKB view
AbapCatalog.buffering.type #NONE view
AbapCatalog.dbHints.hint USE_HEX_PLAN view
EndUserText.label Workflow work items 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 (16)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID swwwihead wi_id WorkItem ID
WorkflowTaskType swwwihead wi_type Type
WorkflowTaskStatus swwwihead wi_stat Status
WrkflwTskCreationUTCDateTime swwwihead crea_tmp Created On
WrkflwTskCompletionUTCDateTime swwwihead wi_aed_timestamp Completed
TopLevelWorkflowTask swwwihead top_wi_id Top Level Workflow
WorkflowTaskCurrentUser swwwihead wi_aagent Agent
TopLevelWorkflowTaskDefinition swwwihead top_task Top Task
WorkflowTaskStepType swwwihead step_id WF Step ID
WorkflowTaskProcessorRole swwwihead agent_rule_id Agent Rule Id
WorkflowTaskNameFallBack _WorkflowTaskTitleFallback WorkflowTaskName
WorkflowTaskResult _WorkflowTaskResult WorkflowTaskResult
_TaskTitle _TaskTitle
_WorkflowTaskStepResult _WorkflowTaskStepResult
_WorkflowTaskTitleFallback _WorkflowTaskTitleFallback
TaskTitelFallbackLanguage _WorkflowTaskTitleFallback Language Report Text Language

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 I_ADM_WORKFLOWTASK_BASE.
-- 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.

CREATE VIEW I_ADM_WORKFLOWTASK_BASE AS
SELECT
  head.wi_id AS WorkflowTaskInternalID,
  head.wi_type AS WorkflowTaskType,
  head.wi_stat AS WorkflowTaskStatus,
  head.crea_tmp AS WrkflwTskCreationUTCDateTime,
  head.wi_aed_timestamp AS WrkflwTskCompletionUTCDateTime,
  head.top_wi_id AS TopLevelWorkflowTask,
  head.wi_aagent AS WorkflowTaskCurrentUser,
  head.top_task AS TopLevelWorkflowTaskDefinition,
  head.step_id AS WorkflowTaskStepType,
  head.agent_rule_id AS WorkflowTaskProcessorRole,
  _WorkflowTaskTitleFallback.WorkflowTaskName AS WorkflowTaskNameFallBack,
  _WorkflowTaskResult.WorkflowTaskResult AS WorkflowTaskResult,
  _WorkflowTaskTitleFallback.Language AS TaskTitelFallbackLanguage
FROM swwwihead AS head
LEFT OUTER JOIN I_WorkflowTaskResult AS _WorkflowTaskResult ON TopLevelWorkflowTask = _WorkflowTaskResult.WorkflowInternalID AND WorkflowTaskInternalID = _WorkflowTaskResult.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkflowTaskTitle AS _TaskTitle ON WorkflowTaskInternalID = _TaskTitle.WorkflowTaskInternalID  -- association [0..*]
LEFT OUTER JOIN I_WorkflowStepResult AS _WorkflowTaskStepResult ON TopLevelWorkflowTaskDefinition = _WorkflowTaskStepResult.WorkflowScenarioDefinition AND WorkflowTaskDefinitionVersion = _WorkflowTaskStepResult.WorkflowScenarioDefinitionVers AND WorkflowTaskStepType = _WorkflowTaskStepResult.WorkflowStepType AND workflowtaskresult = _WorkflowTaskStepResult.WorkflowStepResult  -- association [0..1]
LEFT OUTER JOIN I_WorkflowTaskTitleFallback AS _WorkflowTaskTitleFallback ON WorkflowTaskInternalID = _WorkflowTaskTitleFallback.WorkflowTaskInternalID  -- association [0..1]
;

Learn More