Module pool

[Former Member]

what do we mean by 'commit work ' in module pool programming?

[mahaboob_pathan · Accepted solution]

hi,

COMMIT WORK.

and

ROLLBACK WORK.

for confirming or undoing database updates. COMMIT WORK always concludes a database LUW and starts a new one. ROLLBACK WORK always undoes all changes back to the start of the database LUW.

These statements are part of the SAP transaction concept, and should only be used in this context.

As well as the COMMIT WORK and ROLLBACK WORK statements, there are other situations where data is implicitly written to the database or rolled back, and where database LUWs therefore begin and end.

Furthermore, the above statements also control SAP LUWs, which extend over several database LUWs.

The ABAP statements COMMIT WORK and ROLLBACK WORK only work like the corresponding Standard SQL statements if the entire application program is represented by a single implicit database LUW, that is, for example, in a single dialog step.

[Former Member]

Hi,

Executes a database commit and thus closes a Logical Unit of Work ( LUW) (see also Transaction Processing). This means that all database updates are made irrevocable and cannot be reversed with ROLLBACK WORK and all database locks are released.

COMMIT WORK also calls the subroutines specified by PERFORM ... ON COMMIT, executes asynchronously any update requests (see CALL FUNCTION ... IN UPDATE TASK) specified in these subroutines or started just before, processes the function modules specified in CALL FUNCTION ... IN BACKGROUND TASK, closes all open database cursors (see OPEN CURSOR) and resets the time slice counter to 0.

Regards,

Satish