topic Re: How to refresh DataBase Tables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-refresh-database-tables/m-p/5031824#M1170458 <HTML><HEAD></HEAD><BODY><P>Hi Harsha,</P><P> I dont think your thread is related to eCATTs, hence this thread is moved to ABAP general forum.</P><P></P><P>Kindly post your threads in an appropriate forum to get fast response.</P><P></P><P>Thanks and Kind Regards</P><P>-</P><HR originaltext="----------------------------------------" /><P>Mohan</P></BODY></HTML> Thu, 15 Jan 2009 08:18:25 GMT former_member131788 2009-01-15T08:18:25Z How to refresh DataBase Tables https://community.sap.com/t5/application-development-and-automation-discussions/how-to-refresh-database-tables/m-p/5031823#M1170457 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>The below ABAP code is fetching WorkItem Id from the table SDOE00D00000.</P><P></P><P>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.</P><P></P><P>Can anyone kindly help me to resolve my issue ? </P><P></P><P>ABAP.</P><P></P><P>tables : SDOE00D00000.</P><P></P><P>data : It_t1 type table of SDOE00D00000,</P><P> WA_T1 like SDOE00D00000.</P><P></P><P> REFRESH It_t1 FROM TABLE SDOE00D00000 .</P><P></P><P> SELECT SINGLE * FROM SDOE00D00000 INTO WA_T1 where C1 = V_WORK_ITEM_ID_MAIN.</P><P></P><P> WA_T2 = WA_T1.</P><P></P><P></P><P>ENDABAP.</P><P></P><P>regards</P><P>harsha</P></BODY></HTML> Wed, 14 Jan 2009 00:40:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-refresh-database-tables/m-p/5031823#M1170457 harsha_s 2009-01-14T00:40:09Z Re: How to refresh DataBase Tables https://community.sap.com/t5/application-development-and-automation-discussions/how-to-refresh-database-tables/m-p/5031824#M1170458 <HTML><HEAD></HEAD><BODY><P>Hi Harsha,</P><P> I dont think your thread is related to eCATTs, hence this thread is moved to ABAP general forum.</P><P></P><P>Kindly post your threads in an appropriate forum to get fast response.</P><P></P><P>Thanks and Kind Regards</P><P>-</P><HR originaltext="----------------------------------------" /><P>Mohan</P></BODY></HTML> Thu, 15 Jan 2009 08:18:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-refresh-database-tables/m-p/5031824#M1170458 former_member131788 2009-01-15T08:18:25Z