ATOV_COL_VER_COUNT_NOTES

DDL: ATOV_COL_VER_COUNT_NOTES SQL: ATO_V_CV_CN Type: view

Count notes of collection version

ATOV_COL_VER_COUNT_NOTES is a CDS View that provides data about "Count notes of collection version" in SAP S/4HANA. It reads from 1 data source (ATOV_COL_NOTES) and exposes 1 field.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
ATOV_COL_NOTES Note from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ATO_V_CV_CN view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Count notes of collection version view

Fields (1)

KeyFieldSource TableSource FieldDescription
no_of_notes 
@AbapCatalog.sqlViewName: 'ATO_V_CV_CN'
@ClientHandling:{ type: #INHERITED, algorithm: #SESSION_VARIABLE }
@EndUserText.label: 'Count notes of collection version'
define view ATOV_COL_VER_COUNT_NOTES as 

  select from ATOV_COL_NOTES as Note 
  {
    key Note.collection_id,
    key Note.collection_version,
    count(*) as no_of_notes
  
  }
  group by
    Note.collection_id,
    Note.collection_version
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ATOV_COL_NOTES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More