topic Re: Commit Work in Application Development and Automation Discussions

Commit Work

Former Member — Tue, 15 May 2007 11:10:00 GMT

Hi All,

In a program .. why we are useing Commit Work..

what its purpose..

can any one explain clearly.

regards,

Re: Commit Work

Former Member — Tue, 15 May 2007 11:11:19 GMT

Hi,

This statement will apply any outstanding database updates and wait until they have actually been put on the database before proceeding to the next statement.

An ordinary commit work will initiate the process to update the databases in a separate task and will press on in your abap.

COMMIT WORK: ( Asynchronous)

Your program does not wait for any acknowledgement. it just start executing the next statment after COMMIT WORK.

Regards

Nilesh

Re: Commit Work

Former Member — Tue, 15 May 2007 11:12:50 GMT

Once you give commit in the program after DML or DDL operations on the database table then they will be effected to database table. If you dont give commit statement the changes will be effected to database table once you come out of the program.

Regards

Haritha.

Re: Commit Work

Former Member — Tue, 15 May 2007 11:19:06 GMT

Hi Haritha,

i am writing below code...pls.veryfy..

SELECT PERNR

STAT2

FROM PA0000

INTO TABLE IT_PA0000

WHERE PERNR IN S_PERNR AND

ENDDA GE S_DATE-LOW AND

BEGDA LE S_DATE-HIGH AND

STAT2 IN S_STAT2.

IF SY-SUBRC EQ 0.

COMMIT WORK.

SORT IT_PA0000 BY PERNR.

DELETE ADJACENT DUPLICATES FROM IT_PA0000.

ENDIF.

Here i used commit work ..what happend??

rgds,

Re: Commit Work

Former Member — Tue, 15 May 2007 11:25:53 GMT

Hi,

Here this statement is NOT required.

COMMIT WORK is mostly used when you do some DB operations such as inserting new entries in the DB table.

This is to be used after processing of BAPI.

Regards,

Atish

Re: Commit Work

Former Member — Tue, 15 May 2007 11:28:49 GMT

Hi,

Commit is used to save the records in the database...

See in SAP there will be Header data and Footer data..

Header will contain like data,Customer name,Address etc.,

Footer data will have if any materials is coming from the customer ..it will have more than one data,like one customer cansend more than one material...

Here when we insert the header data it will store in DB,after tht while u storing the footer data u cancel everything means the data saved in the header table also want to deleted....

So here COMMIT plays its role..when footer data is added and saved means finally commit will work...Otherwise the rollback will be called and every thing will be deleted

REWARD if useful

Re: Commit Work

Former Member — Tue, 15 May 2007 11:29:01 GMT

whenever u make changes in the database table we use commit statment.. so that the changes will be reflected in the table.

for example if u use insert, modify , update , delete syntax we have to use commit statement.

select statment wont modify the table it just fetches data from table so there is no need of this statement here.

Re: Commit Work

former_member198270 — Tue, 15 May 2007 11:30:25 GMT

Hi Vijay ,

The Commit Work executes a database commit and thus closes a Logical Unit of Work ( LUW).

The updates and insert in a DB are rolled back in case the program abruptly terminates.

In case of successful completion, the Commit work is called.

When u explicitly mention Commit, Commit work is called then n then n u see the entry in the DB.

The reason u dont see entry in the DB sometimes is probably due to abrupt end of program as a result of which the transactions are rolled back.

Reward points if helpful.

Regards,

Amber S

Re: Commit Work

Former Member — Tue, 15 May 2007 11:37:32 GMT

Hi Vijay,

To apply the changes made to the runtime objects of persistent classes to the actual persistent objects in the database, execute the COMMIT WORK statement

Commit work is used when you code directly in ABAP and make changes in the database and want to commit the database.

Commit work can be used when you trigger a workflow event by using Function module (swe_event_create) in your program.

Regards,

Hemant