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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
@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

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

Meraklılar Gelsin

Sosyal

Twitter 247Followers

En Son Yazılanlar

sitist

SAP Inside Track İstanbul 2017 Developer Edition – Neler Yaptık?

Aralık 17th, 2017
Business mobile apps

İş hayatınızı kolaylaştıracak 6 uygulama

Mart 25th, 2017
SAP HANA MRP Live

SAP HANA MRP Live BADI Usage

Şubat 7th, 2017

Merak Edilen Konular

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