I_WORKFLOWTASKSTATUS

CDS View

Work item status

I_WORKFLOWTASKSTATUS is a CDS View in S/4HANA. Work item status. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_EHSWorkflowTaskStatusVH view from CONSUMPTION Workflow task status
C_LglCntntMTaskStatusVH view from CONSUMPTION Value Help for Task Status
I_WorkflowExternalStatus view from COMPOSITE Workflow Status
I_WorkflowTaskExternalStatus view from COMPOSITE Workflow Task Status 
@AbapCatalog : {
  sqlViewName: 'IWFTASKSTATUS',
  buffering.type: #NONE
}
@EndUserText.label: 'Work item status'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel : {
  usageType.dataClass: #CUSTOMIZING,
  usageType.serviceQuality: #A,
  usageType.sizeCategory: #S
}  
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@ObjectModel.representativeKey: 'WorkflowTaskStatus'
define view I_WorkflowTaskStatus
  as select from dd07l as DomainValue

  association [0..*] to I_WorkflowTaskStatusText as _Text on $projection.WorkflowTaskStatus = _Text.WorkflowTaskStatus

{
        @ObjectModel: { text.association: '_Text' }
  key left(DomainValue.domvalue_l, 10) as WorkflowTaskStatus,

      _Text
}

where
      DomainValue.domname  = 'SWW_WISTAT'
  and DomainValue.as4local = 'A'

Learn More