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

---

 

转载于:https://www.cnblogs.com/yjyongil/p/10496567.html