ATOV_CL_EXP_MAX

DDL: ATOV_CL_EXP_MAX SQL: ATO_V_CL_EMAX Type: view

Collection Version max Exported At

ATOV_CL_EXP_MAX is a CDS View that provides data about "Collection Version max Exported At" in SAP S/4HANA. It reads from 1 data source (ato_changelists) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
ato_changelists ChangeList from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CL_EMAX view
ClientHandling.type #CLIENT_INDEPENDENT view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Collection Version max Exported At view

Fields (1)

KeyFieldSource TableSource FieldDescription
exported_at 
@AbapCatalog.sqlViewName: 'ATO_V_CL_EMAX'
@ClientHandling:{ type: #CLIENT_INDEPENDENT  }
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Collection Version max Exported At'
define view ATOV_CL_EXP_MAX as select from ato_changelists as ChangeList
  {
    ChangeList.collection_id, 
    ChangeList.collection_version, 
    max(ChangeList.exported_at) as exported_at  
} group by collection_id, collection_version
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CHANGELISTS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More