Use of CASE Statement in HANA SQL Script

June 3, 2020 coderobbot AMDP, HANA, HANA SQL Script One comment

Case Statement use in HANA SQL Script

A simple use of CASE statement used in SELECT statement to derive additional computed field/column.

Lets’s look at the SPFLI records. It has a field called FLTYPE(Flight Type). It can be scheduled(‘ ‘) or Charted(X). Based on this field we will derive on more computed field.

Here we have a AMDP procedure with data selection from SPFLI table.

Now look to the first SELECT statement that fills in the table: LT_SPFLI . It has all the fields from SPFLI table with one more computed field called as FLCATEGORY whose value is filled in the CASE statement performed on the field FLTYPE.