07-11-2007 2:43 PM
Hi experts,
A strange problem. I use a FM for DB updating of table EANL an EANLH, after the FM, data is updated to the table, but when the commit work is executed, the changes to table EANL is gone. Does any1 have any idea about this weird problem?
Points will be rewarded.
Thx in advance.
Vincent.
07-11-2007 3:00 PM
Hi Vincent,
Use COMMIT WORK only if you're using the new updated values in the program immediately. Otherwise, the statement is not needed as the data will be automaticallly commited.
If you're using BAPI to update use FM BAPI_TRANSACTION_COMMIT to commit the work.
Reward helpful answers.
Regards,
Siddhesh Sanghvi.
07-11-2007 2:51 PM
Sounds like the COMMIT WORK starts updates (Update V1, V2) which erase those of the module function used.
Which FM do you use?
Regards
07-11-2007 3:05 PM
07-11-2007 3:11 PM
Be sure there is no OSS note to apply in your system for this object (look at 946002)
Regards
07-11-2007 3:12 PM
hi
there is no need of using the commit statement in your program.
07-11-2007 3:00 PM
Hi Vincent,
Use COMMIT WORK only if you're using the new updated values in the program immediately. Otherwise, the statement is not needed as the data will be automaticallly commited.
If you're using BAPI to update use FM BAPI_TRANSACTION_COMMIT to commit the work.
Reward helpful answers.
Regards,
Siddhesh Sanghvi.