P_LGLCNTNTMWORKFLOWTASK

CDS View

Private View for Workflow Task

P_LGLCNTNTMWORKFLOWTASK is a CDS View in S/4HANA. Private View for Workflow Task. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_LglCntntMWorkflowTask view from BASIC Basic Workflow Task 
@AbapCatalog.sqlViewName: 'PLCMWFLTSK'
@VDM.viewType: #BASIC
@VDM.private:true
@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: 'Private View for Workflow Task'
define view P_LglCntntMWorkflowTask
  as select from swwwihead as head
  association [0..1] to P_LglCntntMWorkflowTaskResult as _WorkflowTaskResult     on  $projection.TopLevelWorkflowTask   = _WorkflowTaskResult.WorkflowInternalID
                                                                                 and $projection.WorkflowTaskInternalID = _WorkflowTaskResult.WorkflowTaskInternalID
{
  key head.wi_id       as WorkflowTaskInternalID,
      wi_type          as WorkflowTaskType,
      wi_stat          as WorkflowTaskStatus,
      top_wi_id        as TopLevelWorkflowTask,
      crea_tmp         as WrkflwTskCreationUTCDateTime,
      wi_aed_timestamp as WrkflwTskCompletionUTCDateTime,
      wi_cruser        as WorkflowTaskCreatedByUser,
      wi_aagent        as WorkflowTaskCurrentUser,
      wi_rh_task       as WorkflowTaskDefinition,
      top_task         as TopLevelWorkflowTaskDefinition,
      step_id          as WorkflowTaskStepType,
      agent_rule_id    as WorkflowTaskProcessorRole,
      case
        when wi_chckwi is initial and wi_type <> 'F' then '0000'
        else cast( substring(def_guid, 25, 4) as swd_versio )
      end              as WorkflowTaskDefinitionVersion,
       
      _WorkflowTaskResult.WorkflowTaskResult 
      
}
where
     wi_type = 'W'
  or wi_type = 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_LGLCNTNTMWORKFLOWTASKRESULT",
"SWWWIHEAD"
],
"ASSOCIATED":
[
"P_LGLCNTNTMWORKFLOWTASKRESULT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More