ATOV_COL_COUNT_VERSION

DDL: ATOV_COL_COUNT_VERSION SQL: ATO_V_C_CV Type: view

Count versions of collections

ATOV_COL_COUNT_VERSION is a CDS View that provides data about "Count versions of collections" in SAP S/4HANA. It reads from 1 data source (ATOV_COL_VER_BASE).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
ATOV_COL_VER_BASE Collection_Version from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_C_CV view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Count versions of collections view 
@AbapCatalog.sqlViewName: 'ATO_V_C_CV'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'Count versions of collections'
define view ATOV_COL_COUNT_VERSION as 

  select from ATOV_COL_VER_BASE as Collection_Version 
  {
    key Collection_Version.collection_id,
    count(*) as no_of_version
  }
  group by
    Collection_Version.collection_id             
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_COL_VER_BASE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More