Interview Questions

A table is bufferd. By select statement I don't want to get the data from table buffer. I want to get thae data from database. How?

SAP Reports,SAP DB,ALE, SAP Tables questions and answers


A table is bufferd. By select statement I don't want to get the data from table buffer. I want to get thae data from database. How?

If buffering is allowed for a table in the ABAP Dictionary, the SELECT statement always reads the data from the buffer in the database interface of the current application server. To read data directly from the database table instead of from the buffer, use the following:

SELECT... FROM *lt;tables> BYPASSING BUFFER. ..

This addition guarantees that the data you read is the most up to date. However, as a rule, only data that does not change frequently should be buffered, and using the buffer where appropriate improves performance. You should therefore only use this option where really necessary.

(Continued on next question...)

Other Interview Questions