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:
SELECT with FOR
ALL ENTRIES in accesses to a table or view with generic buffering if the requirement to specify
the generic area exactly (as specified above) is violated. The condition after FOR ALL ENTRIES cannot produce an OR relationship between multiple generic areas.
After the invalidation of an entry in the buffer using a write statement, the next five reads that
should have accessed the entry bypass the buffer of the current application server by default. The next
read performed on the changed entry reloads it into the buffer and removes the invalidation. The number of reads that bypass the buffer before the reload is specified in the
profile parameter zcsa/sync_reload_c.
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.