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).
Thank you Pedro Correia Sequeira pela dica.
Thank you Rodney Topor for the photo.
Greetings from Abapinho.