Now you can SELECT from an internal table.

Really. I also didn’t know. I was told last week. You just have to use the new SQL syntax and assign an alias to the internal table. Like this:

DATA itbl TYPE STANDARD TABLE OF kna1.

SELECT * FROM @itbl AS customers
WHERE land1 = 'PT'
INTO TABLE @DATA(result).

How wonderful.

Thank you Pedro Correia Sequeira pela dica.

Thank you Rodney Topor for the photo.

Greetings from Abapinho.