I_DocLatestWorkflow

DDL: I_DOCLATESTWORKFLOW SQL: IDOCLATESTWF Type: view BASIC

one document to latest workflow

I_DocLatestWorkflow is a Basic CDS View that provides data about "one document to latest workflow" in SAP S/4HANA. It reads from 3 data sources (P_DOCLATESTWORKFLOW, sww_wi2obj, swwwihead) and exposes 4 fields with key field ObjectKey.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
P_DOCLATESTWORKFLOW _latestWorkflow from
sww_wi2obj _wi2obj inner
swwwihead _wihead inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IDOCLATESTWF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label one document to latest workflow view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ObjectKey instid
Workflow sww_wi2obj top_wi_id
ReleaseDateTime sww_wi2obj crea_tmp
JournalEntryWorkflowStatus swwwihead wi_stat 
@AbapCatalog.sqlViewName: 'IDOCLATESTWF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'one document to latest workflow'
@VDM.viewType: #BASIC
define view I_DocLatestWorkflow
  as select from P_DOCLATESTWORKFLOW as _latestWorkflow
    inner join   sww_wi2obj          as _wi2obj on  _wi2obj.instid   = _latestWorkflow.ObjectKey
                                                and _wi2obj.crea_tmp = _latestWorkflow.ReleaseDateTime
  /* changed by i337033 2020-01-02
     enable currency adjustement workflow*/
    inner join   swwwihead           as _wihead on _wi2obj.wi_id = _wihead.wi_id
  /* changed end */
{
  key instid            as ObjectKey,
      _wi2obj.top_wi_id as Workflow,
      _wi2obj.crea_tmp  as ReleaseDateTime,
      _wihead.wi_stat   as JournalEntryWorkflowStatus
}
where
  (
       _wi2obj.wi_rh_task = 'WS02800046'
    /* changed by i337033 2020-01-02
       enable currency adjustement workflow*/
    or _wi2obj.wi_rh_task = 'WS78500019'
  )
  and  _wi2obj.wi_reltype = '01' //only select leading object

/* changed end */

Learn More