atov_cmn_import_extensblt_deps

DDL: ATOV_CMN_IMPORT_EXTENSBLT_DEPS SQL: ATO_V_CMN_DEP_EX Type: view

Dependencies on Extensibility Objects

atov_cmn_import_extensblt_deps is a CDS View that provides data about "Dependencies on Extensibility Objects" in SAP S/4HANA. It reads from 4 data sources (ato_changel_item, ato_changel_depe, atov_changelist_minus_ignored, atov_changelist_minus_ignored) and exposes 1 field.

4 data source(s) 1 fields

Data Sources (4)

SourceAliasJoin Type
ato_changel_item changelist_of_dep_item inner
ato_changel_depe dependencies from
atov_changelist_minus_ignored dependent_changelists inner
atov_changelist_minus_ignored using_changelist inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CMN_DEP_EX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Dependencies on Extensibility Objects view

Fields (1)

KeyFieldSource TableSource FieldDescription
version atov_changelist_minus_ignored collection_version 
@AbapCatalog.sqlViewName: 'ATO_V_CMN_DEP_EX'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Dependencies on Extensibility Objects'
define view atov_cmn_import_extensblt_deps
  as select from ato_changel_depe              as dependencies
    inner join   atov_changelist_minus_ignored as using_changelist       on dependencies.changelist_id = using_changelist.changelist_id
    inner join   ato_changel_item              as changelist_of_dep_item on  dependencies.depending_on_item_type = changelist_of_dep_item.item_type
                                                                         and dependencies.depending_on_item_id   = changelist_of_dep_item.item_id
    inner join   atov_changelist_minus_ignored as dependent_changelists  on  changelist_of_dep_item.changelist_id =  dependent_changelists.changelist_id
                                                                         and using_changelist.exported_at         >= dependent_changelists.exported_at
{

  using_changelist.collection_id                  as collection_id,
  using_changelist.collection_version             as version,
  dependent_changelists.collection_id             as depending_on_collection_id,
  max( dependent_changelists.collection_version ) as depending_on_version
}
where
  changelist_of_dep_item.item_lifecycle_action <> #ATO_ITEM_LIFECYCLE_ACTION.'D'
group by
  using_changelist.collection_id,
  using_changelist.collection_version,
  dependent_changelists.collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CHANGELIST_MINUS_IGNORED",
"ATO_CHANGEL_DEPE",
"ATO_CHANGEL_ITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More