atov_cmn_import_dep_preimports

@AbapCatalog.sqlViewName: 'ATO_V_CMNDEP_PRE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Dependencies to Preimports'
define view atov_cmn_import_dep_preimports
  as select distinct from atov_changelist_minus_ignored as changelist
    inner join   ato_changel_dept              as dependencies            on changelist.transport = dependencies.request
    inner join   atov_changelist_minus_ignored as changelist_of_preimport on  dependencies.changelist_id     = changelist_of_preimport.changelist_id
                                                                          and changelist_of_preimport.status = #ATO_CHANGELIST_STATUS.'PI'                                                             
{
  changelist.collection_id                   as collection_id,
  changelist.collection_version              as version,
  changelist_of_preimport.collection_id      as depending_on_collection_id,
  changelist_of_preimport.collection_version as depending_on_version,
  dependencies.client                        as ato_client
}