Select Single with Full buffering

Former Member — Fri, 22 Jan 2016 13:48:15 GMT

Hi,

I know that when we use single buffering in a table, if we don't use select single then it'll bypass the buffer and directly hit database. But what will happen if we use select single with full buffering? Will it bypass the buffer?

Thanks,

Sarif

Re: Select Single with Full buffering

retired_member — Fri, 22 Jan 2016 14:03:08 GMT

See SAP Buffer -Restrictions ...

Only accessing a table with single buffering with a SELECT where the key is not fully specfied bybasses the buffer.

Using SELECT SINGLE for a fully buffered table does not bypass the buffer.

In fact, since 7.02 it is not the addition SINGLE but only the key specification that counts.

(see Modification 2, the documentation for single buffering is misleading and needs to be corrected - thanks to your question).

B.t.w., see also

topic Re: Select Single with Full buffering in Application Development and Automation Discussions

Select Single with Full buffering

Re: Select Single with Full buffering