Documentation View

We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

ABAPOPEN_CURSOR_MAINQUERY - OPEN CURSOR MAINQUERY

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.
SAP E-Book

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 )