Re : Open Sql query with case statement.
Currently I am looking into open sql statement in abap for hana
I wrote the below query but in debugging the values are populated as below
WHEN 'AC' THEN 'Canada Airlines'
WHEN 'LH' THEN 'Lufthansa Airlines'
END AS carrier_name_long,
SUM( sflight~price ) AS total_price
GROUP BY carrid
into table @DATA(lt_result).
IF lt_result IS NOT INITIAL.
DESCRIBE TABLE lt_result LINES sy-tfill.
WRITE : / sy-tfill.
Please find the attached screen shot
Thanks in advance.