Ansicht
Dokumentation

ABAPOPEN_CURSOR_SHORTREF - OPEN CURSOR SHORTREF

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

OPEN CURSOR

Reference

Syntax

OPEN CURSOR [WITH HOLD] dbcur FOR
  SELECT ...
         FROM ...
         [[FOR ALL ENTRIES IN itab] WHERE sql_cond]
         [GROUP BY ...] [HAVING sql_cond]
         [ORDER BY ...].

Effect

statement. Opens a database cursor for the selection defined using SELECT and associates a cursor variable dbcur with this database cursor.

Additions

• WITH +cte
  Introduces a common table expression+cte.

• WITH HOLD
  Leaves the cursor open in the case of an explicitly triggered database commit or database rollback.

• $[FIELDS$] ...
  Defines a selection set.

• FROM ...
  Specifies the database tables.

• $[FOR ALL ENTRIES IN itab$] WHERE sql_cond
  Specifies a condition for the result set.

• GROUP BY ... $[HAVING sql_cond$]
  Groups rows and sets a condition on the grouped rows.

• ORDER BY ...
  Sorts the result set.

• OFFSET, UP TO
  Restricts the result set.

• BYPASSING BUFFER, CONNECTION
  ABAP-specific additions.
  Sorts the result set.
  

• OFFSET, UP TO
  Restricts the result set.
  

• BYPASSING BUFFER, CONNECTION
  ABAP-specific additions.

CL_GUI_FRONTEND_SERVICES - Frontend Services   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 3274 Date: 20240517 Time: 104406     sap01-206 ( 30 ms )