ATOV_COL_VERSION_LATEST_EXPORT

DDL: ATOV_COL_VERSION_LATEST_EXPORT SQL: ATO_V_LAT_EXP_V Type: view

Latest Exported Version of Collection

ATOV_COL_VERSION_LATEST_EXPORT is a CDS View that provides data about "Latest Exported Version of Collection" in SAP S/4HANA. It reads from 1 data source (ato_changelists).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
ato_changelists ato_changelists from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_LAT_EXP_V view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Latest Exported Version of Collection view 
@AbapCatalog.sqlViewName: 'ATO_V_LAT_EXP_V'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Latest Exported Version of Collection'
define view ATOV_COL_VERSION_LATEST_EXPORT
  as select from ato_changelists
{
  key collection_id,
      max( collection_version ) as latest_exported_version
}

where
  status = #ATO_CHANGELIST_STATUS.'ED'
group by
  collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CHANGELISTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More