Skip to content

ABAP Keyword Documentation →  ABAP Dictionary →  Classic Objects in ABAP Dictionary →  Database Tables →  Technical Attributes of Database Tables →  Table-Specific Technical Attributes of Database Tables 

SAP Buffering of Database Tables

It is possible to specify whether SAP buffering is active for a database table and also how it is performed.

Other versions: 7.31 | 7.40 | 7.54

Buffering permission

SAP buffering can be permitted for a database table as follows:

  • Buffering not allowed
SAP buffering is not performed for the table. Open SQL always accesses the current data of the data table directly. This setting also dictates that SAP buffering should also not be activated for this table in any other systems due to the way it is used.
  • Buffering allowed, but switched off
SAP buffering is not performed for the table when delivered. This setting dictates, however, that buffering is possible in principle and can be activated in other systems depending on how the table is used.
  • Buffering switched on
SAP buffering is performed for the table. If possible, Open SQL statements access the SAP buffer in the shared memory instead of accessing the table directly.


Note

Certain prerequisites, some dependent on the buffering type, must be met before Open SQL can access the SAP buffer instead of accessing the database table directly.

Buffering type

The buffering type determines which data is loaded from the table to the SAP buffer when a table entry is accessed and buffering is switched on. The possible buffering types are: