atov_cl_missing_outdated_dep

DDL: ATOV_CL_MISSING_OUTDATED_DEP SQL: ATO_V_CL_MOD Type: view Package: S_ATO_COL_CORE

Missing Dep On Items from Outdated CLs

atov_cl_missing_outdated_dep is a CDS View that provides data about "Missing Dep On Items from Outdated CLs" in SAP S/4HANA. It reads from 4 data sources (atov_cl_item_base, ATOV_COL_ITEM_IMPORT_STATUS, ato_col_v_status, atov_cl_item_dep_latest_exp) and exposes 2 fields. Part of development package S_ATO_COL_CORE.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
atov_cl_item_base cl_item_of_dep inner
ATOV_COL_ITEM_IMPORT_STATUS dep_item_import left_outer
ato_col_v_status import_status inner
atov_cl_item_dep_latest_exp latest_dep_item_export from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CL_MOD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Missing Dep On Items from Outdated CLs view

Fields (2)

KeyFieldSource TableSource FieldDescription
item_type atov_cl_item_dep_latest_exp item_type
item_id atov_cl_item_dep_latest_exp item_id 
@AbapCatalog.sqlViewName: 'ATO_V_CL_MOD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Missing Dep On Items from Outdated CLs'
define view atov_cl_missing_outdated_dep
  as select from    atov_cl_item_dep_latest_exp as latest_dep_item_export

    inner join      atov_cl_item_base           as cl_item_of_dep  on  cl_item_of_dep.item_type   = latest_dep_item_export.depending_on_item_type
                                                                   and cl_item_of_dep.item_id     = latest_dep_item_export.depending_on_item_id
                                                                   and cl_item_of_dep.exported_at = latest_dep_item_export.latest_export_of_dep_on_items

    inner join      ato_col_v_status            as import_status   on  import_status.collection_id = cl_item_of_dep.collection_id
                                                                   and import_status.version       = cl_item_of_dep.collection_version
                                                                   and import_status.status_schema = #ato_collection_status_schema.'I'
                                                                   and import_status.status        = #ato_collection_status.'O'
    left outer join ATOV_COL_ITEM_IMPORT_STATUS as dep_item_import on  dep_item_import.item_type     = latest_dep_item_export.depending_on_item_type
                                                                   and dep_item_import.item_id       = latest_dep_item_export.depending_on_item_id
                                                                   and dep_item_import.exported_at   > latest_dep_item_export.latest_export_of_dep_on_items
                                                                   and dep_item_import.import_status = #ATO_COLLECTION_STATUS.'I'
{
  latest_dep_item_export.changelist_id,
  latest_dep_item_export.item_type,
  latest_dep_item_export.item_id,
  latest_dep_item_export.depending_on_item_type,
  latest_dep_item_export.depending_on_item_id,
  cl_item_of_dep.item_last_notification as depending_on_last_notification
}
where
  dep_item_import.item_id is null

Learn More