ATOV_ST_ITEM_LATEST_IMP_CHANGL

DDL: ATOV_ST_ITEM_LATEST_IMP_CHANGL SQL: ATO_V_ST_ITLICL Type: view

Latest imported changelist of an item

ATOV_ST_ITEM_LATEST_IMP_CHANGL is a CDS View that provides data about "Latest imported changelist of an item" in SAP S/4HANA. It reads from 2 data sources (ato_changel_item, ato_changelists) and exposes 2 fields with key fields item_type, item_id.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
ato_changel_item item from
ato_changelists list inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_ITLICL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Latest imported changelist of an item view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY item_type ato_changel_item item_type
KEY item_id ato_changel_item item_id 
@AbapCatalog.sqlViewName: 'ATO_V_ST_ITLICL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Latest imported changelist of an item'

define view ATOV_ST_ITEM_LATEST_IMP_CHANGL
  as select from ato_changel_item as item
    inner join   ato_changelists  as list on list.changelist_id = item.changelist_id
{

  key item.item_type           as item_type,
  key item.item_id             as item_id,
      max (list.changelist_id) as changelist_id

}
where
  (
       list.status          = #ATO_CHANGELIST_STATUS.'ID'
    or list.status          = #ATO_CHANGELIST_STATUS.'PI'
  )
  or   list.changelist_type = #ATO_CHANGELIST_TYPE.'M' // Migration


group by
  item.item_type,
  item.item_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CHANGELISTS",
"ATO_CHANGEL_ITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More