topic Re: Update Function module on commit work in Application Development and Automation Discussions

Update Function module on commit work

Former Member — Tue, 20 Mar 2012 04:35:02 GMT

Hi Experts,

I have used the bundling technique using function modules to insert the data in the database table.To be more precise, I am using an update function module to insert the data in the DB table and calling the Commit work as soon as after calling the update function module.Also, i am using the select query to pull the data that i have saved and to display it on the screen.

But, some times although the data is saved the DB upon commit, the select query is failing to pull the same data.

I am not understanding what is happening.

Example Code.

call update function module

commit work.

select on the db table with the data saved ( at this point , some times select is failing i.e sy-subrc <> 0 )

display the result using ALV.

Thank in advance,

Ravi.

Re: Update Function module on commit work

SuhaSaha — Tue, 20 Mar 2012 05:08:08 GMT

Since you're not using local updates (SET UPDATE TASK LOCAL), using COMMIT WORK leads to an asynchronous update.

Since as per your requirement you need to have a synchronous update you've to use COMMIT WORK AND WAIT.

BR,

Suhas

Re: Update Function module on commit work

Former Member — Tue, 20 Mar 2012 05:21:41 GMT

Hi Ravi,

Please use FM: CONVERSION_EXIT_ALPHA_INPUT for all the key fields before saving into DB.

Regards/Ali