Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP- DataBase

harsha_s
Explorer
0 Kudos

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

2 REPLIES 2

andrea_galluccio2
Contributor
0 Kudos

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

Vny12
Employee
Employee
0 Kudos

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