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