Ansicht
Dokumentation
ABENABAP_SQL_LISTS_OBSOLETE - ABAP SQL LISTS OBSOLETE
CL_GUI_FRONTEND_SERVICES - Frontend Services Addresses (Business Address Services)This documentation is copyright by SAP AG.
Blank-Separated Lists
The following lists of an statement can still be specified with blanks as separators instead of commas, unless one of the strict modes of the syntax check applies from Release .
- In the statement SELECT.
- When columns or aggregation functions are specified in the SELECT list.
- When columns are specified after GROUP BY
- ... GROUP BY col1 col2 ...
- When columns are specified after ORDER BY
-
... ORDER BY ${col1$|a1$} $[ASCENDING$|DESCENDING$]
${col2$|a2$} $[ASCENDING$|DESCENDING$]
...
- In the statement UPDATE:
- When change expressions are specified after SET
- ... SET set_expression1 set_expression2 ...
These specifications are obsolete. Lists should always be separated by commas.
Example
SELECT statement with blank-separated lists.
SELECT carrid connid
FROM spfli
INTO (carrid, connid)
WHERE carrid = carrid AND
connid = connid
ORDER BY carrid connid.
Recommended format with comma-separated lists, which forces the use of the escape character @ in front of host variables.
SELECT carrid, connid
FROM spfli
WHERE carrid = @carrid AND
connid = @connid
ORDER BY carrid, connid
INTO (@carrid, @connid).
Fill RESBD Structure from EBP Component Structure SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 3234 Date: 20240505 Time: 050653 sap01-206 ( 31 ms )