atov_cmn_import_dep_preimports

DDL: ATOV_CMN_IMPORT_DEP_PREIMPORTS SQL: ATO_V_CMNDEP_PRE Type: view

Dependencies to Preimports

atov_cmn_import_dep_preimports is a CDS View that provides data about "Dependencies to Preimports" in SAP S/4HANA. It reads from 2 data sources (atov_changelist_minus_ignored, ato_changel_dept) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
atov_changelist_minus_ignored changelist_of_preimport inner
ato_changel_dept dependencies inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CMNDEP_PRE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Dependencies to Preimports view

Fields (2)

KeyFieldSource TableSource FieldDescription
version changelist collection_version
ato_client ato_changel_dept client 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CHANGELIST_MINUS_IGNORED",
"ATO_CHANGEL_DEPT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More