atov_col_deps_latest_col_ver

DDL: ATOV_COL_DEPS_LATEST_COL_VER SQL: ATO_V_COL_DEP Type: view

Dependencies on Coll Versions at Export

atov_col_deps_latest_col_ver is a CDS View that provides data about "Dependencies on Coll Versions at Export" in SAP S/4HANA. It reads from 3 data sources (ato_changelists, ato_changel_item, ato_col_items).

3 data source(s)

Data Sources (3)

SourceAliasJoin Type
ato_changelists Changelist inner
ato_changel_item ChangelistItem inner
ato_col_items Item inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_COL_DEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Dependencies on Coll Versions at Export view 
@AbapCatalog.sqlViewName: 'ATO_V_COL_DEP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Dependencies on Coll Versions at Export'
define view atov_col_deps_latest_col_ver

  as select distinct from ATOV_COL_VER_KEY_MAX as ColMaxVersion

    inner join            ato_col_items        as Item           on  ColMaxVersion.collection_id = Item.collection_id
                                                                 and Item.timestamp              = 0

    inner join            ato_changel_item     as ChangelistItem on  Item.item_type = ChangelistItem.item_type
                                                                 and Item.item_id   = ChangelistItem.item_id

    inner join            ato_changelists      as Changelist     on  ChangelistItem.changelist_id =  Changelist.changelist_id
                                                                 and (
                                                                    Changelist.changelist_type    =  ' '
                                                                    or Changelist.changelist_type =  'D'
                                                                    or Changelist.changelist_type =  'F'
                                                                  )
                                                                 and Changelist.status            =  'ED' // Only consider successfully exported Changelists

                                                                 and Changelist.collection_id     <> ColMaxVersion.collection_id

{

  key ColMaxVersion.collection_id,
  key ColMaxVersion.collection_version,
  key Changelist.collection_id           as depending_collection_id,
      max(Changelist.collection_version) as depending_collection_version

}
group by
  ColMaxVersion.collection_id,
  ColMaxVersion.collection_version,
  Changelist.collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_COL_VER_KEY_MAX",
"ATO_CHANGELISTS",
"ATO_CHANGEL_ITEM",
"ATO_COL_ITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More