ABAP Keyword Documentation →  ABAP - Short Reference 

FETCH - Short Reference

Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

FETCH NEXT CURSOR dbcur 
    { { INTO { {[CORRESPONDING FIELDS OF] wa} | (dobj1, dobj2, ...) } } 

    | { INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab 
   
                   [PACKAGE SIZE n] } }. 

Effect

Extracts lines from the resulting set of a database-cursor opened withOPENCURSOR.

Additions

• INTO wa
  Reads a line and assigns it to a work area wa.
• INTO (dobj1, dobj2, ...)
  Reads a line and assigns it to several data objects dobj1, dobj2, ...
• INTO|APPENDING TABLE itab
  Reads several lines and assigns them to an internal table itab resp. attaches them to the table.
• CORRESPONDING FIELDS OF
  Restricts the transport to homonymous components of the work areas wa resp. to the internal table itab.
• PACKAGE SIZE n
  Hands over the lines in pakages from n lines to the internal table itab.
• CREATING READER|LOCATOR FOR ... COLUMNS ...
  Specifies what type of LOB handle is created.