ABAP CDS on HANA-8

Arithmetic expression in CDS View

 

 

Allowed Arithmetic operators in CDS view.

CDS View-

---

@AbapCatalog.sqlViewName: ‘ZFLIGHT_VW’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: ‘Flight View with Aggregation Operation’

define view Zflight_View
as select from sflight as s
{
key s.carrid,
key s.connid,
key s.fldate,
s.price,
s.currency,
s.seatsmax – s.seatsocc as Avai_Seats_in_Economy_Class,
s.seatsmax_b – s.seatsocc_b as Avai_Seats_in_Business_Class,
s.seatsmax_f – s.seatsocc_f as Avai_Seats_in_First_Class
} 

---

Data Preview

---