P_DOCLATESTWORKFLOW

DDL: P_DOCLATESTWORKFLOW SQL: PDOCLATESTWF Type: view BASIC

P_DOCLATESTWORKFLOW is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (vbkpf, sww_wi2obj) and exposes 2 fields with key field ObjectKey.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
vbkpf _doc from
sww_wi2obj _obj inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDOCLATESTWF 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
VDM.viewType #BASIC view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ObjectKey sww_wi2obj instid
ReleaseDateTime 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SWW_WI2OBJ",
"VBKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More