commit work

[Former Member]

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...

[Former Member]

try to use:

SET UPDATE TASK LOCAL.

and

commit work and wait.

[abdul_hakim]

Hi

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

[Former Member]

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.