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 ?.
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.