Database Related

[Former Member]

Which Command flushes database Buffer???

[Former Member]

Hi,

By flushing buffer do you want to select the values from database, in that case you can use <b>BYPASSING BUFFER</b> addition with select statement.

EX :

select *

from vbak

into table itab bypassing buffer

where vbeln eq s_vbeln.

Hope this helps.

[Former Member]

if you are using SELECT in the programs,

then you can add up the command BYPASSING BUFFER,

to skip fetching values from the BUFFER and to goto the database for that.

Regards

srikanth

[Former Member]

Hi,

... BYPASSING BUFFER

Reads the data records directly from the database, even if thetable is in the SAP buffer

TABLES SPROD.

SELECT * FROM SPROD BYPASSING BUFFER

WHERE PRODUCER = 'BOE'.

WRITE: / SPROD-STREET, SPROD-NAME, SPROD-POSTCODE,

SPROD-CITY, SPROD-COUNTRY.

ENDSELECT.

Regards

amole

[Former Member]

Hello,

Use 'BYPASSING BUFFER' in the select query.

Regards,

Shehryar