ATOV_CART_COUNT_UNCHANGED

DDL: ATOV_CART_COUNT_UNCHANGED SQL: ATO_V_CART_CNTU Type: view

Count unchanged items in Hotfix

ATOV_CART_COUNT_UNCHANGED is a CDS View that provides data about "Count unchanged items in Hotfix" in SAP S/4HANA. It reads from 5 data sources (ato_col_cart, ATOV_COL_VER_KEY_MAX, ATOV_CL_ITEM_EXP_CL_MAX, ato_items, ato_changelists).

5 data source(s)

Data Sources (5)

SourceAliasJoin Type
ato_col_cart cart from
ATOV_COL_VER_KEY_MAX current_collection_version inner
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_CART_CNTU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Count unchanged items in Hotfix view 
@AbapCatalog.sqlViewName: 'ATO_V_CART_CNTU'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Count unchanged items in Hotfix'
define view ATOV_CART_COUNT_UNCHANGED
  as select from ato_col_cart            as cart
    inner join   ATOV_COL_VER_KEY_MAX    as current_collection_version on cart.collection_id = current_collection_version.collection_id
    inner join   ato_items               as item                       on  cart.item_type   = item.item_type
                                                                       and cart.item_id     = item.item_id
                                                                       and item.item_status = #ATO_ITEM_STATUS.'C'
                                                                       and item.timestamp   = 0
    inner join   ATOV_CL_ITEM_EXP_CL_MAX as exported_items             on  cart.item_type = exported_items.item_type
                                                                       and cart.item_id   = exported_items.item_id
    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 current_collection_version.collection_id,
      count (*) as number_of_unchanged_items
}
group by
  current_collection_version.collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CL_ITEM_EXP_CL_MAX",
"ATOV_COL_VER_KEY_MAX",
"ATO_CHANGELISTS",
"ATO_COL_CART",
"ATO_ITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More