ABAP CDS on HANA-8

cds

Arithmetic expression in CDS View

 

 

Allowed Arithmetic operators in CDS view.

3.jpg

CDS View-

1


@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

2


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s