topic Re: ABAP- DataBase in Application Development and Automation Discussions

ABAP- DataBase

harsha_s — Wed, 14 Jan 2009 13:45:24 GMT

Hello,

Am executing below ABAP code in eCATT editor and is fetching WorkItem Id from the table SDOE00D00000.

But the problem is , when i execute the script for the first time, it gets me the old data and when i execute for the second time, it fetches the latest data from the table.

Can anyone kindly help me to resolve my issue ? .

How can i refresh the table SDOE00D00000 before fetching the content from the table to my work area ?.

ABAP.

tables : SDOE00D00000.

data : It_t1 type table of SDOE00D00000,

WA_T1 like SDOE00D00000.

REFRESH It_t1 FROM TABLE SDOE00D00000 .

SELECT SINGLE * FROM SDOE00D00000 INTO WA_T1 where C1 = V_WORK_ITEM_ID_MAIN.

WA_T2 = WA_T1.

ENDABAP.

regards

harsha

Re: ABAP- DataBase

andrea_galluccio2 — Wed, 14 Jan 2009 16:48:13 GMT

Hi,

try to use the switch 'BYPASS BUFFER' of the select (help on the select to know more).

If the table is buffered, the select will read data directly from the database and not from the buffer.

Hope it helps

Bye

Andrea

Re: ABAP- DataBase

Vny12 — Mon, 19 Jan 2009 06:00:24 GMT

Hi harsha,

resetting the RFC is as good as refreshing the table.

SO please use command RESCON before you try to fetch.

RESCON will reset the connection.

regards

vinay