ABAP CDS – Aggregation 

ABAP CDS Aggregation ile ilgili kod.

Ön koşullar

1. ABAP CDS yaratma
2. SAP EPM

Senaryo

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

ABAP CDS Kodu

@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