ESH_LIMITATIONS_GRPBY

DDL: ESH_LIMITATIONS_GRPBY SQL: ESHGRPBY Type: view Package: S_ESH_APPS_TEST_CDS_VALIDATION

View with group by

ESH_LIMITATIONS_GRPBY is a CDS View that provides data about "View with group by" in SAP S/4HANA. It reads from 1 data source (adrp) and exposes 2 fields with key fields persnumber, date_from. Part of development package S_ESH_APPS_TEST_CDS_VALIDATION.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
adrp adrp from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ESHGRPBY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View with group by view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY persnumber persnumber
KEY date_from date_from 
@AbapCatalog.sqlViewName: 'ESHGRPBY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'View with group by'
define view ESH_LIMITATIONS_GRPBY as select from adrp{
  //adrp 

  key persnumber, 
  key date_from
}
group by persnumber, date_from
having persnumber = '00000000';

Learn More