ABAPOPEN_CURSOR_MAINQUERY - OPEN CURSOR MAINQUERY

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

OPEN CURSOR, mainquery_clauses

... ${ FROM source
      FIELDS select_clause $}
  $| ${ select_clause
      FROM source $}
    $[$[FOR ALL ENTRIES IN itab$]
      WHERE sql_cond$]
    $[GROUP BY group$] $[HAVING group_cond$]
    $[ORDER BY sort_key$]
    $[db_hints$] ...

Effect

Possible clauses and additions of the main query after OPEN CURSOR. All the same clauses are possible as for a standalone SELECT statement except for SINGLE. The clauses define the result set, which can be accessed using the FETCH statement. The result set is regarded as having multiple rows.

The addition FOR ALL ENTRIES cannot be used if common table expressions are defined using WITH.

Example

OPEN CURSOR statement with all possible clauses.

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 2420 Date: 20230207 Time: 083257     sap01-206 ( 36 ms )