atov_cmn_import_missing_items

DDL: ATOV_CMN_IMPORT_MISSING_ITEMS SQL: ATO_V_CMN_DEP_MI Type: view

Missing Extensibility Items

atov_cmn_import_missing_items is a CDS View that provides data about "Missing Extensibility Items" in SAP S/4HANA. It reads from 2 data sources (ATOV_CL_ITEM_IMPORTED, ato_changelists) and exposes 1 field.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
ATOV_CL_ITEM_IMPORTED imported_items left_outer
ato_changelists using_changelist left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CMN_DEP_MI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Missing Extensibility Items view

Fields (1)

KeyFieldSource TableSource FieldDescription
version ato_changelists collection_version 
@AbapCatalog.sqlViewName: 'ATO_V_CMN_DEP_MI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Missing Extensibility Items'
define view atov_cmn_import_missing_items
  as select distinct from ato_changel_depe           as dependencies
    left outer join       ato_changelists            as using_changelist on dependencies.changelist_id = using_changelist.changelist_id
    left outer join       ATOV_CL_ITEM_IMPORTED      as imported_items   on  dependencies.depending_on_item_type = imported_items.item_type
                                                                         and dependencies.depending_on_item_id   = imported_items.item_id
{
  using_changelist.collection_id,
  using_changelist.collection_version as version,
  dependencies.depending_on_item_type as missing_item_type,
  dependencies.depending_on_item_id   as missing_item_id
  // if we need the status: take the last exported_at which is imported and check with this the latest status of the collection_version

}
where
     imported_items.item_id is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CL_ITEM_IMPORTED",
"ATO_CHANGELISTS",
"ATO_CHANGEL_DEPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More