Ansicht
Dokumentation

ABAPOPEN_CURSOR_MAINQUERY - OPEN CURSOR MAINQUERY

ABAPOPEN_CURSOR_MAINQUERY - OPEN CURSOR MAINQUERY

General Material Data   BAL_S_LOG - Application Log: Log header data  
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.






rdisp/max_wprun_time - Maximum work process run time   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 2420 Date: 20240329 Time: 002516     sap01-206 ( 33 ms )