ABAP CDS on HANA-6

Case Expression in CDS View

 

 

Create a CDS view and use below case expression.

---

@AbapCatalog.sqlViewName: ‘ZFLIGHT_VW’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: ‘Use of Case Expression in CDS view’
define view Zflight_Case_Exp

as select from spfli {
key spfli.carrid,
key spfli.connid,
       spfli.countryfr,
       spfli.countryto,
case
when distance >= 10000 then ‘Long Way Journey’
when distance >= 5000 and distance < 10000 then ‘Medium Way Journey’
else ‘Short Way journey’
end as journey_type
}

---

Output- Data Preview

SPFLI Table Entries

---