Ansicht
Dokumentation

ABENOPEN_SQL_LISTS_OBSOLETE - OPEN SQL LISTS OBSOLETE

BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
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 7.40, SP05.

• In the statement SELECT.

• When columns or aggregation functions are specified in the SELECT list.
  
  ... ${col_spec1 $[AS a1$] col_spec2 $[AS a2$] ... $}

• 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 formats are obsolete. Lists should always be separated by commas.

Example

SELECT statement with comma-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 force the use of the escape character @ before host variables.

SELECT carrid, connid
       FROM spfli
       WHERE carrid = @carrid AND
             connid = @connid
       ORDER BY carrid, connid
       INTO (@carrid, @connid).

General Data in Customer Master   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 3202 Date: 20240426 Time: 121700     sap01-206 ( 28 ms )