topic Re: data not getting saved in table properly in Application Development and Automation Discussions

data not getting saved in table properly

Former Member — Thu, 16 Jun 2011 15:14:33 GMT

Hi,

I am doing update and insert operation in my program. I have realised that SAP implicitly calls COMMIT when ever there is a change of screen. But my situation is bit strange, I have no change of screen.

*) The data is getting updated into table during night time when the traffic is low and it doesnt get entered during day time .

Can any one explain me what is actually happening underneath.

If i call a wait or commit statement after the database operation then the datas are getting inserted properly.

Please help me out explaining the situation.

Regards,

Tashi norbu

Re: data not getting saved in table properly

Former Member — Thu, 16 Jun 2011 15:19:34 GMT

Can you share the code of table update...

Re: data not getting saved in table properly

Former Member — Fri, 17 Jun 2011 06:10:50 GMT

Hi,

I think your case is related to Sap LUW, which has different way of treatment in comparison with a database LUW.

Check this link to see more:

http://help.sap.com/saphelp_nw04/helpdata/en/41/7af4bfa79e11d1950f0000e82de14a/content.htm

Best regards,

Paul

Edited by: paul the octopus on Jun 17, 2011 8:11 AM

Re: data not getting saved in table properly

Former Member — Sat, 18 Jun 2011 16:27:33 GMT

It is better to use commit work after updation or return an information message when data is updated

Re: data not getting saved in table properly

Former Member — Sun, 19 Jun 2011 13:08:29 GMT

Your problem is due to SAP LUW, but first tell me onething why are you directly trying to change DB you should use some BAPI or other SAP standard .

But still incase if your need is not met you can use a update function module to achieve the objective. If you provide me the exact details I may help you better as I have worked on quite a few issues like this.

cheers!!

Prasenjit Singh BIst