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.