Ansicht
Dokumentation

ABAPOPEN_CURSOR_SHORTREF - OPEN CURSOR SHORTREF

Vendor Master (General Section)   CL_GUI_FRONTEND_SERVICES - Frontend Services  
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.

Fill RESBD Structure from EBP Component Structure   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 3274 Date: 20240419 Time: 210042     sap01-206 ( 30 ms )