Select Query On Internal Table in ABAP on HANA
In HANA-ABAP now it is possible to write select query and perform joining also.
Below post shows a simple use case of writing a simple select query on internal table.
SELECT * FROM spfli INTO TABLE @DATA(lt_spfli).
select * FROM @lt_spfli as lt_spfli_alias WHERE carrid = ‘AA’ INTO TABLE @DATA(lt_spfli_1).
In DB-SPFLI has 20 records.
The select on internal table shows matching records.
Select on internal table with where condition and other cases:
what if I need to use SUM(*) instead of count(*).. is it possible?
Yes it is possible to use the aggregate function(s) as well, but these are executed in DB level.