ABAP CDS - Aggregation

ABAP CDS Aggregation ile ilgili kod.

Ön koşullar

Müşteri ve para birimi bazında toplam satış siparişi tutarlarını gösteren rapor.

@AbapCatalog.sqlViewName: 'ZZXB_V_AGG'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Aggregation CDS örneği'

define view zzxb_cdsv_aggregation as

select from snwd_so as so

inner join snwd_bpa as bpa

on so.buyer_guid = bpa.node_key

{

// Key fields

key bpa.company_name,

key so.currency_code,

// Aggregation

sum( so.gross_amount ) as total_gross_amount

}

group by bpa.company_name,

so.currency_code