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

SAP Buffer - Restrictions

Only transparent tables and pooled tables can be buffered. Buffering is not possible for cluster tables. There is no special restriction of the key length of the table when buffering, which means that keys in buffered tables can be up to 900 bytes long.

The following Open SQL statements bypass the SAP buffer implicitly and access the database tables directly, since the operation in question can only be executed on the database and not in the SAP buffer:


Bypassing the SAP buffer using the additions above should be noted for access to buffered database tables or views for performance reasons. To bypass the SAP buffer in the statement SELECT explicitly, the addition BYPASSING BUFFER should always be used. It is not enough to rely on the implicit behavior of the additions above.