Select Query On Internal Table in ABAP

light111Select 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.

1


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.

23

4

The select on internal table shows matching records.

5

More cases:

Select on internal table with where condition and other cases:

6

 

7

8

9


 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s