atov_cmn_import_missing_tr_dep

DDL: ATOV_CMN_IMPORT_MISSING_TR_DEP SQL: ATO_V_CMN_DEP_MT Type: view Package: S_ATO_COMMON_IMPORT

Missing dependent transports

atov_cmn_import_missing_tr_dep is a CDS View that provides data about "Missing dependent transports" in SAP S/4HANA. It reads from 5 data sources (ATOV_COL_VER_KEY, ato_changel_dept, ato_changelists, atov_versions_to_import, ato_changelists) and exposes 1 field. Part of development package S_ATO_COMMON_IMPORT.

5 data source(s) 1 fields

Data Sources (5)

SourceAliasJoin Type
ATOV_COL_VER_KEY collection_versions from
ato_changel_dept dependencies inner
ato_changelists dependent_changelists left_outer
atov_versions_to_import import_versions inner
ato_changelists using_changelist inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CMN_DEP_MT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Missing dependent transports view

Fields (1)

KeyFieldSource TableSource FieldDescription
version ATOV_COL_VER_KEY collection_version 
@AbapCatalog.sqlViewName: 'ATO_V_CMN_DEP_MT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Missing dependent transports'
define view atov_cmn_import_missing_tr_dep
  as select from    ATOV_COL_VER_KEY        as collection_versions
    inner join      atov_versions_to_import as import_versions       on  collection_versions.collection_id      = import_versions.collection_id
                                                                     and collection_versions.collection_version = import_versions.collection_version
    inner join      ato_changelists         as using_changelist      on  import_versions.collection_id      = using_changelist.collection_id
                                                                     and import_versions.collection_version = using_changelist.collection_version
    inner join      ato_changel_dept        as dependencies          on using_changelist.changelist_id = dependencies.changelist_id
    left outer join ato_changelists         as dependent_changelists on dependencies.request = dependent_changelists.transport
{

  collection_versions.collection_id          as collection_id,
  collection_versions.collection_version     as version,
  max( using_changelist.collection_version ) as mediating_version,
  dependencies.request                       as missing_transport
}
where
  dependent_changelists.changelist_id is null // Only select those transports that have no changelist assigned yet

group by
  collection_versions.collection_id,
  collection_versions.collection_version,
  dependencies.request

Learn More