ATOV_CART_COUNT_NEW

CDS View

Count new items in Hotfix

ATOV_CART_COUNT_NEW is a CDS View in S/4HANA. Count new items in Hotfix. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ATOV_CART_COUNT view left_outer Count Items in Hotfix

Fields (1)

KeyField CDS FieldsUsed in Views
number_of_new_items number_of_new_items 1 
@AbapCatalog.sqlViewName: 'ATO_V_CART_CNTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'Count new items in Hotfix'
define view ATOV_CART_COUNT_NEW
  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
    left outer 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
{
  key current_collection_version.collection_id,
      count (*) as number_of_new_items
}
where
  exported_items.item_id is null
group by
  current_collection_version.collection_id
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_CL_ITEM_EXP_CL_MAX",
"ATOV_COL_VER_KEY_MAX",
"ATO_COL_CART",
"ATO_ITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More