topic Re: why dont we use Commit statement in Usrer exits? in Application Development and Automation Discussions

why dont we use Commit statement in Usrer exits?

Former Member — Wed, 11 Aug 2010 05:10:33 GMT

Hi,

I dont understand one thing that why dont we use commit statement in user exits, Please educate me on this.

Regards,

Kiran

Re: why dont we use Commit statement in Usrer exits?

SuhaSaha — Wed, 11 Aug 2010 05:23:43 GMT

Inside the User Exit you are in an SAP LUW & the COMMIT WORK will abruptly end the LUW which is not desirable.

Re: why dont we use Commit statement in Usrer exits?

Former Member — Wed, 11 Aug 2010 05:38:50 GMT

Since Exits are triggered in between standard SAP transactions which have their own commit that trigger at a specified point so You should be disturbing that hence explicit commit work shouldn't be used.

Re: why dont we use Commit statement in Usrer exits?

Former Member — Wed, 11 Aug 2010 06:32:23 GMT

Hi Kiran,

Normally , you shoud not specify COMMIT statement in any user exit , badi etc..

SAP has its own COMMIT statement while execuiting the standard transactions .

Addition of a COMMIT might lead to problems elsewhere .

Syntactitically, this is allowed. But its not advisable, because you never know, which reports are affected by this unexprected commit, because it commits all outstanding modifications and you do not know if a programmer needs to store something in addidtion to end a logical unit of work.

May it helps you.

Regards,

DS.

Re: why dont we use Commit statement in Usrer exits?

Former Member — Wed, 11 Aug 2010 06:52:26 GMT

Hi Kiran,

The flow is like this -

SAP Std transaction --> Event(SAVE) --> EXIT code --> Transaction complete(DB commit)

Here when we are in a user exit, SAP is yet to process the business transaction completly. SAP has it's own commit after the complete process.

Also SAP has provided us the exits to manage the transaction data. We should not play with the LUW. If we write commit in Exit, there could be some major table updates which may get commited and in case that there are errors after Exit, and the transaction is not completed , database inconsistency could arise.

Hope this helps.

Regards

Megha

Re: why dont we use Commit statement in Usrer exits?

Former Member — Wed, 11 Aug 2010 06:52:59 GMT

It violates LUW rule.

Thanks

Shantanu

Re: why dont we use Commit statement in Usrer exits?

kesavadas_thekkillath — Wed, 11 Aug 2010 10:19:57 GMT

Go through this link:[;