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

SAP Buffer - Single Record Buffering

Only those rows in the table are buffered that are actually accessed. This requires less space in the buffer than when using generic or full buffering. On the other hand, more administration work is required and significantly more direct database accesses.

If SELECT SINGLE is used to access a non-buffered row, an attempt is made to load the row. If the row is not found, this is noted in the buffer and the database is not accessed again the next time SELECT SINGLE is used.

Other versions: 7.31 | 7.40 | 7.54

Notes

• When using single record buffering, any Open SQL statements must respect the full primary key to prevent them from bypassing SAP buffering.

• Single record buffering is recommended for large tables from which single rows are often read using SELECT SINGLE. In smaller tables from which many rows are read, full buffering is usually preferred since this reduces the number of direct database accesses that need to be loaded.