Select Query On Internal Table in ABAP

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.

More cases:

Select on internal table with where condition and other cases: