Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Insert statement with Commit work

Former Member
0 Likes
1,287

Dear all,

I have used insert statement for inserting the data into ztable ,I didnt used Commit work for commit the insertion , but the data is present in Ztable.

Is insert statement will work without Commit work. Please give the reason.

Thanks and Regards ,

Rajesh

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
956

HI,

If you don't do an explicit commit / rollback in your program, when you exit your program the system will do the commit for you - this is one example of an implicit commit. Implicit commits will be activated at other points also eg when you call a popup screen.

refer to this link...

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b64358411d1829f0000e829fbfe/content.htm

4 REPLIES 4
Read only

Former Member
0 Likes
957

HI,

If you don't do an explicit commit / rollback in your program, when you exit your program the system will do the commit for you - this is one example of an implicit commit. Implicit commits will be activated at other points also eg when you call a popup screen.

refer to this link...

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b64358411d1829f0000e829fbfe/content.htm

Read only

Former Member
0 Likes
956

Hi,

Insert statement will work without Commit work.

The main advantage of insert statement is insert data into database table as wel as Ztables also

Press F1 on insert statement u found all details of insert statement

How we can use insert statement with examples....

Read only

Former Member
0 Likes
956

Thanks .Well answered

Read only

Former Member
0 Likes
956

HI.

Acutally ,The INSERT statement is used to insert values into a single database table.No need Explicitly COMMIT WORK and ROLLBACK WORK .SAP already have done Implicitly commit work.

Regards.

Jay