topic Re: Database Related in Application Development and Automation Discussions

Database Related

Former Member — Fri, 15 Sep 2006 10:22:48 GMT

Which Command flushes database Buffer???

Former Member — Fri, 15 Sep 2006 10:24:46 GMT

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 — Fri, 15 Sep 2006 10:26:32 GMT

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 — Fri, 15 Sep 2006 10:48:24 GMT

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 — Fri, 15 Sep 2006 11:34:03 GMT

Hello,

Use 'BYPASSING BUFFER' in the select query.

Regards,

Shehryar