topic Re: Commit statement in user exit in Application Development and Automation Discussions

Commit statement in user exit

Former Member — Wed, 30 Sep 2009 03:50:48 GMT

Hi All,

We found that while doing PGI , it takes some time to COMMIT the table VBUK. Due to which we are getting old values of VBUK-KOSTK field while executing select query at later point of time in the flow.

My question --

Can I use COMMIT WORK statement in user exit MV50AFZ1 --> FORM USEREXIT_SAVE_DOCUMENT so that all the related tables

get committed immediately.

Thanks

Saurabh

Re: Commit statement in user exit

Former Member — Wed, 30 Sep 2009 04:14:34 GMT

Hi,

Try using COMMIT WORK AND WAIT syntax

Edited by: Navitha Anwer on Sep 30, 2009 6:15 AM

Re: Commit statement in user exit

Former Member — Wed, 30 Sep 2009 04:21:24 GMT

Hi Saurabh ,

Normally , you shoud not specify COMMIT stmt 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 .

Thanks

Supriya

Re: Commit statement in user exit

Former Member — Wed, 30 Sep 2009 06:43:33 GMT

SAP does not permit you to use COMMIT work in User exit.

Regards, Sri

Re: Commit statement in user exit

rainer_hbenthal — Wed, 30 Sep 2009 07:52:37 GMT

Syntactitically, this is allowed. But its not advisable, cause you can never know, which reports are affected by this unexprected commit, cause 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.

Re: Commit statement in user exit

Former Member — Wed, 30 Sep 2009 12:37:04 GMT

thx.