atov_cmn_deps_to_custom_dev

DDL: ATOV_CMN_DEPS_TO_CUSTOM_DEV SQL: ATOV_CMN_CDDEP Type: view

Deps to Custom Dev Objects

atov_cmn_deps_to_custom_dev is a CDS View that provides data about "Deps to Custom Dev Objects" in SAP S/4HANA. It reads from 4 data sources (ato_changelists, ato_changelists, ato_changel_depk, ato_changel_depd).

4 data source(s)

Data Sources (4)

SourceAliasJoin Type
ato_changelists changelist inner
ato_changelists changelist inner
ato_changel_depk dependencies from
ato_changel_depd dependencies union

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATOV_CMN_CDDEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Deps to Custom Dev Objects view 
@AbapCatalog.sqlViewName: 'ATOV_CMN_CDDEP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Deps to Custom Dev Objects'
define view atov_cmn_deps_to_custom_dev
  // Extensibility => Custom Dev

  as select from ato_changel_depk as dependencies
    inner join   ato_changelists  as changelist on dependencies.changelist_id = changelist.changelist_id
{
  changelist.collection_id,
  changelist.collection_version,
  dependencies.depending_on_program_id,
  dependencies.depending_on_object_type,
  dependencies.depending_on_object_name
}

union

// BC/Custom Dev => Custom Dev

select from  ato_changel_depd as dependencies
  inner join ato_changelists  as changelist on dependencies.changelist_id = changelist.changelist_id
{
  changelist.collection_id,
  changelist.collection_version,
  dependencies.depending_on_program_id,
  dependencies.depending_on_object_type,
  dependencies.depending_on_object_name
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_CHANGELISTS",
"ATO_CHANGEL_DEPD",
"ATO_CHANGEL_DEPK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More