general....

[Former Member]

Hi,

A table is buffered. By select statement i dont want to get

the data from table buffer. i want to get the data from

database. how?

Thx in adv,

Reg,

Suresh Kumar.V

[Former Member]

you can use

SELECT * FROM SPPROD INTO WA_SPPROD BYPASSING BUFFER WHERE PRODUCER = 'BOE'.

like this

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

[Former Member]

Hi,

Use the BYPASSING BUFFER addition..

SELECT * FROM ZTABLE BYPASSING BUFFER
             INTO TABLE T_ZTABLE
             

Thanks,

Naren

[Former Member]

hi Suresh,

Use<b> BYPASSING BUFFER</b> statement

SELECT * FROM <TABLE> BYPASSING BUFFER WHERE .... .

Refer

[Former Member]

Hi,

Normally we will use this by passing buffer for T tables to optimize the fetching.

Use statement BYPASSING BUFFER in the select statement.

Eg:

SELECT persg " Employee group

persk " Employee sub group

trfkz " ES grouping for collective agreement provision

FROM t503

BYPASSING BUFFER

INTO TABLE i_t503.

Regards,

Priyanka.

[Former Member]

Hi,

You can use the BYPASSING BUFFER addition in the seelect statement,

Reward points if it is helpful.

'

Regards,

Sangeetha.a