ATOV_ST_CURRENT_COL_VERSIONS

DDL: ATOV_ST_CURRENT_COL_VERSIONS SQL: ATO_V_ST_COLV Type: view Package: S_ATO_SYSTEM_TRANSFER

Current collection versions

ATOV_ST_CURRENT_COL_VERSIONS is a CDS View that provides data about "Current collection versions" in SAP S/4HANA. It reads from 2 data sources (ato_changelists, ATOV_ST_RELEVANT_ITEMS). Part of development package S_ATO_SYSTEM_TRANSFER.

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
ato_changelists changel inner
ATOV_ST_RELEVANT_ITEMS current_cl from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_ST_COLV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Current collection versions view 
@AbapCatalog.sqlViewName: 'ATO_V_ST_COLV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Current collection versions'

define view ATOV_ST_CURRENT_COL_VERSIONS
  as select from ATOV_ST_RELEVANT_ITEMS as current_cl
    inner join   ato_changelists        as changel on changel.changelist_id = current_cl.changelist_id

{
  key changel.collection_id           as collection_id,
      max(changel.collection_version) as collection_version
}
group by
  changel.collection_id

Learn More