I_LglCntntMWorkflowTask

DDL: I_LGLCNTNTMWORKFLOWTASK SQL: ILGLCNTNMWT Type: view BASIC

Basic Workflow Task

I_LglCntntMWorkflowTask is a Basic CDS View that provides data about "Basic Workflow Task" in SAP S/4HANA. It reads from 1 data source (P_LglCntntMWorkflowTask) and exposes 17 fields with key field WorkflowTaskInternalID. It has 3 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
P_LglCntntMWorkflowTask P_LglCntntMWorkflowTask from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_WorkflowStepResult _WorkflowTaskStepResult $projection.TopLevelWorkflowTaskDefinition = _WorkflowTaskStepResult.WorkflowScenarioDefinition and $projection.WorkflowTaskDefinitionVersion = _WorkflowTaskStepResult.WorkflowScenarioDefinitionVers and $projection.WorkflowTaskStepType = _WorkflowTaskStepResult.WorkflowStepType and $projection.WorkflowTaskResult = _WorkflowTaskStepResult.WorkflowStepResult
[1..1] I_WorkflowTaskStatus _TaskStatus $projection.WorkflowTaskStatus = _TaskStatus.WorkflowTaskStatus
[0..1] I_WorkflowStepType _WorkflowStepType $projection.WorkflowTaskStepType = _WorkflowStepType.WorkflowStepType and $projection.TopLevelWorkflowTaskDefinition = _WorkflowStepType.WrkflwScen and $projection.WorkflowTaskDefinitionVersion = _WorkflowStepType.WrkflwScenVers

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ILGLCNTNMWT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic Workflow Task view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID
WorkflowTaskType WorkflowTaskType
WorkflowTaskStatus WorkflowTaskStatus
TopLevelWorkflowTask TopLevelWorkflowTask
WrkflwTskCreationUTCDateTime WrkflwTskCreationUTCDateTime
WrkflwTskCompletionUTCDateTime WrkflwTskCompletionUTCDateTime
WorkflowTaskCreatedByUser WorkflowTaskCreatedByUser
WorkflowTaskCurrentUser WorkflowTaskCurrentUser
WorkflowTaskDefinition WorkflowTaskDefinition
TopLevelWorkflowTaskDefinition TopLevelWorkflowTaskDefinition
WorkflowTaskStepType WorkflowTaskStepType
WorkflowTaskProcessorRole WorkflowTaskProcessorRole
WorkflowTaskDefinitionVersion WorkflowTaskDefinitionVersion
WorkflowTaskResult WorkflowTaskResult
_WorkflowTaskStepResult _WorkflowTaskStepResult
_WorkflowStepType _WorkflowStepType
_TaskStatus _TaskStatus 
@AbapCatalog.sqlViewName: 'ILGLCNTNMWT'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.dbHints:[{hint:'USE_HEX_PLAN'}]

@EndUserText.label: 'Basic Workflow Task'
define view I_LglCntntMWorkflowTask 
as select from P_LglCntntMWorkflowTask 


  association [0..1] to I_WorkflowStepResult        as _WorkflowTaskStepResult    on  $projection.TopLevelWorkflowTaskDefinition = _WorkflowTaskStepResult.WorkflowScenarioDefinition
                                                                                  and $projection.WorkflowTaskDefinitionVersion  = _WorkflowTaskStepResult.WorkflowScenarioDefinitionVers
                                                                                  and $projection.WorkflowTaskStepType           = _WorkflowTaskStepResult.WorkflowStepType
                                                                                  and $projection.WorkflowTaskResult             = _WorkflowTaskStepResult.WorkflowStepResult
  association [1..1] to I_WorkflowTaskStatus        as _TaskStatus                on  $projection.WorkflowTaskStatus = _TaskStatus.WorkflowTaskStatus
  association [0..1] to I_WorkflowStepType          as _WorkflowStepType          on  $projection.WorkflowTaskStepType           = _WorkflowStepType.WorkflowStepType
                                                                                  and $projection.TopLevelWorkflowTaskDefinition = _WorkflowStepType.WrkflwScen
                                                                                  and $projection.WorkflowTaskDefinitionVersion  = _WorkflowStepType.WrkflwScenVers
{
  key WorkflowTaskInternalID,
      WorkflowTaskType,
      WorkflowTaskStatus,
      TopLevelWorkflowTask,
      WrkflwTskCreationUTCDateTime,
      WrkflwTskCompletionUTCDateTime,
      WorkflowTaskCreatedByUser,
      WorkflowTaskCurrentUser,
      WorkflowTaskDefinition,
      TopLevelWorkflowTaskDefinition,
      WorkflowTaskStepType,
      WorkflowTaskProcessorRole,
      WorkflowTaskDefinitionVersion,
      WorkflowTaskResult,
      
      _WorkflowTaskStepResult ,
      _WorkflowStepType,
      _TaskStatus  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_LGLCNTNTMWORKFLOWTASK"
],
"ASSOCIATED":
[
"I_WORKFLOWSTEPRESULT",
"I_WORKFLOWSTEPTYPE",
"I_WORKFLOWTASKSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More