topic Re: Executing subroutine after commit work, not on commit work in Application Development and Automation Discussions

Executing subroutine after commit work, not on commit work

manou_manou — Thu, 04 Aug 2005 10:17:36 GMT

Hi All,

I want to execute my sub-routine after commit work, not on commit work.

If any one have answer please mail me at emmanuelevy@gmail.com

Re: Executing subroutine after commit work, not on commit work

Former Member — Thu, 04 Aug 2005 10:24:46 GMT

Hi,

use the addition ON COMMIT in the perform.

PERFORM sub_form ON COMMIT.

Re: Executing subroutine after commit work, not on commit work

manou_manou — Thu, 04 Aug 2005 10:48:29 GMT

thanks ,

yes i know but i need AFTER the commit not BEFORE

Re: Executing subroutine after commit work, not on commit work

christian_wohlfahrt — Thu, 04 Aug 2005 10:55:21 GMT

Hi,

in which context do you want to do something? I guess, it's not a Z-report, that would be simple.

But it's also not every commit in system. There is no general answer (at least I don't know any), but there might be several options in a special case.

Regards,

Christian

Re: Executing subroutine after commit work, not on commit work

Vinod_Chandran — Thu, 04 Aug 2005 10:57:23 GMT

Hi,

You can use the level (LEVEL idx) with perform on commit.

Give a high value like 99. This will ensure that your subroutine will be the last one which will be executed from the commit queue.

But this will be still in the commit work not after.

Thanks

Vinod

Re: Executing subroutine after commit work, not on commit work

ChristianFi — Thu, 04 Aug 2005 11:45:07 GMT

Not sure if this helps you but this event is fired, when commit work is fired.

Christian

report test.

class lcl_event_handler definition.
 public section.

    class-methods: on_commit_finished
         for event COMMIT_FINISHED
           of CL_OS_TRANSACTION_END_NOTIFIER.
endclass.

set handler lcl_event_handler=>on_commit_finished.

commit work.

class lcl_event_handler implementation.
 method on_commit_finished.
  break-point.
 endmethod.

endclass.

But check also oss note 704577

Re: Executing subroutine after commit work, not on commit work

manou_manou — Thu, 04 Aug 2005 12:33:11 GMT

thanks for your answer , but i have a user exit before the commit of sap standard .

and there aren't user exit after .

it's about transaction vl32n . i need to use batch input after the commit .

Re: Executing subroutine after commit work, not on commit work

ChristianFi — Thu, 04 Aug 2005 12:59:34 GMT

so I guess you would like to perform the routne after to avoid lock conflicts.

I am not sure about that transaction but since you are talking of batch input why not scheduling the BI (via Job scheduling - there are a couple of Function modules to achieve that rather easily) with some kind of delay to avoid these conflicts.

Christian