P_DOCLATESTWORKFLOW

CDS View

one document to latest workflow

P_DOCLATESTWORKFLOW is a CDS View in S/4HANA. one document to latest workflow. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DocLatestWorkflow view from BASIC one document to latest workflow 
@AbapCatalog.sqlViewName: 'PDOCLATESTWF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private:true
define view P_DOCLATESTWORKFLOW
  as select from vbkpf      as _doc
    inner join   sww_wi2obj as _obj on _doc.awkey = _obj.instid
{
  key _obj.instid        as ObjectKey,
      max(_obj.crea_tmp) as ReleaseDateTime
}

where
       _obj.wi_id      =    _obj.top_wi_id

  /* changed by i337033 2020-01-02
     enable currency adjustement workflow*/
  and  _obj.wi_reltype =    '01' //only select leading object

  //  and typeid     = 'CL_FDC_ACCDOC_VER'

  and(
       _obj.wi_rh_task =    'WS02800046'
    //currency adjustement workflow id

    or _obj.wi_rh_task =    'WS78500019'
  )
  and  _doc.tcode      like 'FBDC_P%'
  and  _doc.ausbk      =    _doc.bukrs
/* changed end */
group by
  _obj.instid

Learn More