atov_cl_missing_outdated_dep

DDL: ATOV_CL_MISSING_OUTDATED_DEP SQL: ATO_V_CL_MOD Type: view

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 6 data sources and exposes 2 fields.

6 data source(s) 2 fields

Data Sources (6)

SourceAliasJoin Type
ato_changel_item cl_item_of_dep inner
ato_changelists cl_of_dep inner
ato_col_versions col_ver inner
ATOV_COL_ITEM_IMPORT_STATUS dep_item_import left_outer
ATOV_COL_VER_KEY latest_col_ver 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      ato_changelists             as cl_of_dep       on  cl_of_dep.exported_at =  latest_dep_item_export.latest_export_of_dep_on_items
                                                                   and cl_of_dep.status      <> #ATO_CHANGELIST_STATUS.'I'
    inner join      ato_changel_item            as cl_item_of_dep  on  cl_item_of_dep.changelist_id = cl_of_dep.changelist_id
                                                                   and 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
    inner join      ATOV_COL_VER_KEY            as latest_col_ver  on  latest_col_ver.collection_id      = cl_of_dep.collection_id
                                                                   and latest_col_ver.collection_version = cl_of_dep.collection_version
    inner join      ato_col_versions            as col_ver         on  col_ver.collection_id = latest_col_ver.collection_id
                                                                   and col_ver.version       = latest_col_ver.collection_version
                                                                   and col_ver.timestamp     = latest_col_ver.timestamp
                                                                   and col_ver.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.col_version_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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CL_ITEM_DEP_LATEST_EXP",
"ATOV_COL_ITEM_IMPORT_STATUS",
"ATOV_COL_VER_KEY",
"ATO_CHANGELISTS",
"ATO_CHANGEL_ITEM",
"ATO_COL_VERSIONS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More