XBARSLAN

Incubation Hub

  • ANASAYFA
  • HAKKIMDA
  • PROJELER
29 Mayıs 2016  |  By xbarslan ABAP CDS, HANA CDS, SAP HANA

ABAP CDS – Aggregation

XBARSLAN code

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 
cds aggregation hana cds sap hana cds sqlscript sqlscript aggregation
Avatar

xbarslan

Related Articles:

  • XBARSLAN code
    ABAP CDS - Filtering
  • XBARSLAN code
    ABAP CDS - Extension

Leave Comment Cancel Reply

(will not be shared)

PrevABAP CDS Yaratma
NextABAP CDS – Arithmetic Casting

Sosyal

Twitter 229Followers

Etiketler

ABAP-OO abap cds ABAP Class Encapsulation ABAP class instance abap hana amdp badi analiz big data bilgi yönetimi cds Encapsulation Fiori Gateway hana hana cds Mobil Mobile mrp live badi mrp live enhancement Netweaver Object Oriented ABAP ODATA Open SAP OPENUI5 raporlama sap sap abap SAP Fiori SAP Fiori Nedir? SAP Frontend SAP Gateway sap hana amdp sap hana mrp live sap merak edilenler SAP Mobil SAP Mobile SAP Mobile SDK SAP Mobility SAP ODATA SAPUI5 SAP Uygulamaları sqlscript veri Xamarin İş hayatı
© copyright 2015 by xbarslan