ATOV_COL_EXP_NUM_UNCHNGED_ITMS

DDL: ATOV_COL_EXP_NUM_UNCHNGED_ITMS SQL: ATO_V_E_UCHD_ITM Type: view Package: S_ATO_COL_CORE

Count of unchanged items in collection ver

ATOV_COL_EXP_NUM_UNCHNGED_ITMS is a CDS View that provides data about "Count of unchanged items in collection ver" in SAP S/4HANA. It reads from 4 data sources (ato_col_items, ATOV_CL_ITEM_EXP_CL_MAX, ato_items, ato_changelists). Part of development package S_ATO_COL_CORE.

4 data source(s)

Data Sources (4)

SourceAliasJoin Type
ato_col_items col_item from
ATOV_CL_ITEM_EXP_CL_MAX exported_items inner
ato_items item inner
ato_changelists latest_changelist inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_E_UCHD_ITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Count of unchanged items in collection ver view 
@AbapCatalog.sqlViewName: 'ATO_V_E_UCHD_ITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Count of unchanged items in collection ver'
define view ATOV_COL_EXP_NUM_UNCHNGED_ITMS
    as select from   ato_col_items               as col_item               
    inner join   ATOV_CL_ITEM_EXP_CL_MAX as exported_items             on  col_item.item_type = exported_items.item_type
                                                                       and col_item.item_id   = exported_items.item_id
    inner join   ato_items               as item                       on  col_item.item_type   = item.item_type
                                                                       and col_item.item_id     = item.item_id
                                                                       and item.item_status = #ATO_ITEM_STATUS.'C'
                                                                       and item.timestamp   = 0
                                                                       
                                                                       
    inner join   ato_changelists         as latest_changelist          on  exported_items.last_exported_changelist_id = latest_changelist.changelist_id
                                                                       and item.last_notification                     < latest_changelist.exported_at
                                                                       
{
  key col_item.collection_id,
      count (*) as number_of_unchanged_items
}
where col_item.timestamp = 0
group by
  col_item.collection_id

Learn More