Atov_Col_Cart_Count_Items

DDL: ATOV_COL_CART_COUNT_ITEMS SQL: ATO_V_CART_CNT Type: view

Number of Items in Collection Cart

Atov_Col_Cart_Count_Items is a CDS View that provides data about "Number of Items in Collection Cart" in SAP S/4HANA. It reads from 1 data source (ato_col_cart) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
ato_col_cart ato_col_cart from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CART_CNT view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Number of Items in Collection Cart view

Fields (1)

KeyFieldSource TableSource FieldDescription
num_items 
@AbapCatalog.sqlViewName: 'ATO_V_CART_CNT'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Number of Items in Collection Cart'
define view Atov_Col_Cart_Count_Items as
select from ato_col_cart
{
  key collection_id,
  count(*) as num_items
}
group by
  collection_id; 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATO_COL_CART"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More