Skip to content

ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP Database Accesses →  Open SQL →  Open SQL - Overview →  Open SQL - SAP Buffering 

SAP Buffer - Buffer Management

Other versions: 7.31 | 7.40 | 7.54

Storage in the Memory

SAP buffering takes place in the shared memory of each application server. The SAP buffer consists of a central management structure, an alphabetical directory of tables, and a data area. The individual areas of a generically buffered table or database view are managed as individual fully buffered tables. The buffered data is saved in the data area as internal tables. The data area is managed using SAP Memory Management.

When a buffered table or view is accessed using Open SQL, a search first takes place for the name of the table in the table directory and then a binary search takes place for the data.

In both single record buffering and in generic buffering, information about nonexistent rows in a table or view is also saved. The first time a nonexistent row is read, the key values of the primary key or generic key are loaded into the associated data area with an (otherwise empty) row and an appropriate flag. The next time an attempt is made to read this row, the buffer already indicates that this row does not exist.


Note

The management of single record buffering is not quite as efficient as generic or full buffering. In single record buffering, the rows are loaded into the internal table in the data area one by one. In generic buffering and full buffering, all data of a table or view is loaded in a single step and sorted on the database.

Buffer Monitor

The buffer monitor is an SAP Memory Management tool (transaction ST02) used, among other things, to analyze the SAP buffer of the current application server. This includes tasks such as:

  • Displaying the buffer load on the application server over the last few days
  • Displaying and modifying the associated profile parameters
  • Displaying detailed information about the table buffer
  • Displaying table statistics for analyzing the effectiveness of a buffer. The displayed values are useful when optimizing the associated profile parameters and when detecting expensively buffered tables.

For more information, see the

SAP NetWeaver documentation in SAP Help Portal.