ATOV_COL_VER_EXP_ITEM_COUNTER

@AbapCatalog.sqlViewName: 'ATO_V_COLVE_ITMC'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: '# Items in exported Collection Versions'
define view ATOV_COL_VER_EXP_ITEM_COUNTER
  as
 select distinct from ATOV_CL_ITEM_EXP as Collection_Version_Item  // due to full and delta exports 

  // there is no need to get the max entry as both are exported at the same timestamp

{
  key collection_id,
  key collection_version,
  count( distinct item_id ) as number_of_items  
} 
where Collection_Version_Item.status = 'ED'
group by  collection_id, 
          collection_version
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CL_ITEM_EXP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/