Did you know that, if you SAP is recent enough, you can use complex ABAP expressions in the middle of SQL commands?
Like this, for example:
SELECT name1 FROM kna1 WHERE kunnr = @( VALUE kunnr( itbl[ vbeln = i_vbeln ]-kunnr OPTIONAL ) ) INTO result.
SAP calls them host expressions and says they can be used in several places in the SQL command. Even in the
Thank you Manuel Andrade for the tip.
Foto: Egisto Sani.
Greetings from Abapinho.