ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Overview →  ABAP SQL - Table Buffering → 

Table Buffering - Buffering Types

There are three buffering types that can be configured for a database table or database view in the ABAP Dictionary:


If generic buffering or full buffering is activated, and the database table or view is specified statically in an ABAP SQL statement, the secondary indexes of the table are not ignored when the data is read from the table buffer. If single record buffering is used, only the primary index is read. A secondary index defined in ABAP Dictionary is evaluated regardless of whether the index was created on the database.

Table Buffering - Single Record Buffering
Table Buffering - Generic Buffering
Table Buffering - Full Buffering