topic Re: commit work in Application Development and Automation Discussions

commit work

Former Member — Wed, 02 Jul 2008 13:43:10 GMT

i modified a record but it is taking more time to get updated

in database..i used commit work with in perform..is that correct... but that is also not working...please help me out such that my record should get updated immediately...

Re: commit work

Former Member — Wed, 02 Jul 2008 13:56:15 GMT

try to use:

SET UPDATE TASK LOCAL.

and

commit work and wait.

Re: commit work

abdul_hakim — Wed, 02 Jul 2008 13:59:08 GMT

If you want to update immediately use database inline update.

ie jus use your UPDATE or MODIFY statements.

If you want to bundle ur updates use PERFORM ON COMMIT or CALL FUNCTION IN UPDATE TASK. techniques.

Cheers,

Hakim

Re: commit work

Former Member — Wed, 02 Jul 2008 14:57:28 GMT

Assuming you are trying to update a Y or Z table, you have couple of options -

[1]. Set up table maint generator and write a bdc program with call transaction to sm30 for that table update. {Recommended]. If this update is from many places, write a function module with the sm30 bdc.

[2]. Use Enqueue and Dequeue syntax encapsulating your update statement.

In normal circumstances, you will never need to update an SAP table , that is a table not starting with Y or Z.

For SAP tables the only approved way [according to me] is to pass on the requisite values in the temp structures at the appropriate point in the user-exit/badi where one is provided. That is if it is not a BDC.