ATOV_COL_VER_IMP_VER_KEY

@AbapCatalog.sqlViewName: 'ATO_V_CV_IMPVK'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Collection Version Import Version Keys'

// depending on the use case ATOV_COL_VER_IMP_KEY might be better. In ATOV_COL_VER_IMP_KEY the latest Staus + Timestamp is included

define view ATOV_COL_VER_IMP_VER_KEY
  as select distinct from ato_col_versions as Collection_Version

    inner join            ato_cols         as Collection on Collection.collection_id = Collection_Version.collection_id
{

  key Collection_Version.collection_id,
  key Collection_Version.version as collection_version

}
where
  (
       Collection_Version.status    =  'I' // I:Imported

    or Collection_Version.status    =  'R' // R:Ready for Import => this might not be timestam = 0

   // all imported Collections should at least have a Ready for Import or an Imported enty


  )
  and  Collection.status            <> 'H' // Hidden

  and  Collection.category          <> 'T'
  and  Collection.client            = $session.client //Filter Collections by client