Skip to content

ABAP Keyword Documentation →  ABAP - Quick Reference 

OPEN CURSOR - Quick reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax


OPEN CURSOR [WITH HOLD] @dbcur FOR 
  [WITH
    +cte1 AS subquery[,
    +cte2 AS subquery
    ...]]
  SELECT { ...
           FROM ... }
       | { FROM ...
           FIELDS ... }
         [[FOR ALL ENTRIES IN itab] WHERE sql_cond]
         [GROUP BY ...] [HAVING sql_cond]
         [ORDER BY ...]
         [UP TO n ROWS]
         [OFFSET o]
         [BYPASSING BUFFER]
         [CONNECTION con|(con_syntax)].

Effect

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

Additions