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 - Full Buffering

When a row is read, all rows in the table or view are loaded to the SAP buffer. The buffered table or view is either entirely in the buffer or not at all. In the buffer, the buffered data records are sorted by the key of the table or view. Optimized access requires that the left-aligned part of the primary key or of the fields of a secondary index be as large as possible. If not, the buffer is scanned in a linear fashion.

If full buffering is switched on in a client-specific table or view, generic buffering using the client column as a generic key is performed internally.

Other versions: 7.31 | 7.40 | 7.54

Notes

• In a fully buffered table or view, access to nonexistent data is very fast (see Buffer Management).

• Full buffering should be used in small tables, such as customizing tables. In larger tables, full buffering is worthwhile only if large quantities of data are read frequently. Writes on fully buffered tables should be performed only rarely.

Example

The table T005 is fully buffered since it is small and accessed often by reads.