ABAP- DataBase

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