atov_cmn_import_prev_item_ver

@AbapCatalog.sqlViewName: 'ATO_V_CDPIV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'EXT Deps Due to Prev Item Version'
define view atov_cmn_import_prev_item_ver
// Extensibility Dependencies to Previous Item Versions

  as select from ato_changel_item              as changelist_item
    inner join   atov_changelist_minus_ignored as changelist           on changelist_item.changelist_id = changelist.changelist_id
    inner join   ato_changel_item              as prev_changelist_item on  changelist_item.item_type = prev_changelist_item.item_type
                                                                       and changelist_item.item_id   = prev_changelist_item.item_id
    inner join   atov_changelist_minus_ignored as prev_changelist      on  prev_changelist_item.changelist_id =  prev_changelist.changelist_id
                                                                       and changelist.collection_id           <> prev_changelist.collection_id // Previous versions are included automatically

                                                                       and changelist.exported_at             >  prev_changelist.exported_at // Do not add dependency to newer transports

{
  changelist.collection_id                  as collection_id,
  changelist.collection_version             as version,
  prev_changelist.collection_id             as depending_on_collection_id,
  max( prev_changelist.collection_version ) as depending_on_version
}
where changelist.collection_type      = #ATO_COLLECTION_TYPE.'E' and // Extensibility

      prev_changelist.collection_type = #ATO_COLLECTION_TYPE.'E'
group by
  changelist.collection_id,
  changelist.collection_version,
  prev_changelist.collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CHANGELIST_MINUS_IGNORED",
"ATO_CHANGEL_ITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/