Implicit commit

[Shizofrenik]

Hi, experts.
Can someone explain how does the Implicit Database Commit works.

There is no any dialogs steps or other items, which are simmillar with documentation, why data are comes into db?

REPORT  ZVA_EX31.
data : ls_mara type mara.
ls_mara-matnr = '000'.
insert INTO mara VALUES ls_mara.

[Sandra_Rossi · Accepted solution]

The implicit database commit happens when SE38 screen is displayed after program execution.

By the way, do an SQL trace (ST05) and you'll see the database commits.

[Shizofrenik · Accepted solution]

why it come into db even if i run it as background task?

[Sandra_Rossi · Accepted solution]

Generally speaking, the implicit database commit happens when the memory context is rolled out of a workprocess. You can find the answer also in the ABAP documentation (https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abendb_commit.htm#@@I...)

[RaymondGiuseppi · Accepted solution]

Read online documentation on Explicit Database Commits.

[attila_laczko]

Hi Shizofrenik,

wenn the programm ends, than will produce an Implicit Commit on the Database. That means, you have not an explicit Commit with the Command "COMMIT WORK [AND WAIT]" executed (the addition in the brackets means a synchronous executet commit: the Programm waits on tha Database. Otherwise is a asynchronous Commit and the Programm ends, while the Database is on "working").

I can mention, that in your programm the event START-OF-SELECTION is missing 😉

Congrats,

Attila