• The first thing to notice is the comma-separated field list after the keyword SELECT. With the new syntax, lists after additions ORDER BY and GROUP BY become comma-separated too.
• The second difference is the “@” symbol for escaping so-called host variables. The ABAP language is considered the host of the embedded Open SQL, so the host variable means the ABAP variable or constant inside the Open SQL statement. Every host variable must be escaped with a preceding “@” sign at every position in the statement.
•This new syntax is a prerequisite for more sophisticated expressions in the SELECT clause.
• The INTO clause no longer has to precede the WHERE clause but can follow it.
• The FROM clause can now be the first, followed by the column list starting with the explicit keyword FIELDS. This increases the readability and supportability of SELECT statements.
Please share with your ABAP friends and follow us.
If you want to dive deeper, visit our course https://lnkd.in/d42HfjDh
Comments