ATOV_CART_COUNT

DDL: ATOV_CART_COUNT SQL: ATO_V_CART_CNTI Type: view

Count Items in Hotfix

ATOV_CART_COUNT is a CDS View that provides data about "Count Items in Hotfix" in SAP S/4HANA. It reads from 5 data sources (ATOV_CART_COUNT_CHANGED, ato_cols, ATOV_CART_COUNT_DELETED, ATOV_CART_COUNT_NEW, ATOV_CART_COUNT_UNCHANGED).

5 data source(s)

Data Sources (5)

SourceAliasJoin Type
ATOV_CART_COUNT_CHANGED changed_items left_outer
ato_cols collection from
ATOV_CART_COUNT_DELETED deleted_items left_outer
ATOV_CART_COUNT_NEW new_items left_outer
ATOV_CART_COUNT_UNCHANGED unchanged_items left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CART_CNTI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Count Items in Hotfix view 
@AbapCatalog.sqlViewName: 'ATO_V_CART_CNTI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Count Items in Hotfix'
define view ATOV_CART_COUNT
  as select from    ato_cols                  as collection
    left outer join ATOV_CART_COUNT_CHANGED   as changed_items   on collection.collection_id = changed_items.collection_id
    left outer join ATOV_CART_COUNT_UNCHANGED as unchanged_items on collection.collection_id = unchanged_items.collection_id
    left outer join ATOV_CART_COUNT_NEW       as new_items       on collection.collection_id = new_items.collection_id
    left outer join ATOV_CART_COUNT_DELETED   as deleted_items   on collection.collection_id = deleted_items.collection_id
{
  key collection.collection_id,
      changed_items.number_of_changed_items,
      unchanged_items.number_of_unchanged_items,
      new_items.number_of_new_items,
      deleted_items.number_of_deleted_items
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CART_COUNT_CHANGED",
"ATOV_CART_COUNT_DELETED",
"ATOV_CART_COUNT_NEW",
"ATOV_CART_COUNT_UNCHANGED",
"ATO_COLS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More