topic Problem with updatin Ztable while blocking PGI in Application Development and Automation Discussions

Problem with updatin Ztable while blocking PGI

Former Member — Thu, 09 Dec 2010 09:19:41 GMT

Hi all,

My requirement is as follows: When ever user tries to do PGI using VL02N or VL06G I need to block them depending on some criteria and update the Ztable with the delivery no and blocked date.

I am able to block the PGI by using the user exit USEREXIT_SAVE_DOCUMENT_PREPARE and giving an error message saying PGI blocked for so ans so reason.

*- Update table ZDE_GI_BLOCKED with blocked deliveries
    PERFORM update_gi_blocked USING lt_gi_blocked.
IF sy-ucomm = 'WABU'.
      MESSAGE text-e01 TYPE 'E' .
    ELSEIF sy-ucomm = 'WABU_T'.
*      lv_var1 = 'B'.
*      case lv_var1.
*        when 'A'.
          MESSAGE text-e01 TYPE 'S' DISPLAY LIKE 'E'.
ENDIF.

But the problem is if we are ung VL06G the Ztable is not being updated whereas for VL02N it is being updated.

I think as we are in userexit writing commit statement is prohibited.

Kindly give your suggestions.

Thanks,

Aravind

Re: Problem with updatin Ztable while blocking PGI

Former Member — Thu, 09 Dec 2010 15:43:33 GMT

You're correct in that we don't want COMMIT WORK in userexits, due to pushing the update queues to the database before SAP has finished constructing all the updates. This can have undesirable results, obviously.

Question: have you debugged your VL06G to be certain you're entering this exit coding? If so, perhaps you could post your update subroutine instead of the message processing....Apparently the message aren't the problem, so not sure why you posted that instead of the contents of the perform just above the message routine.

Re: Problem with updatin Ztable while blocking PGI

Former Member — Sun, 12 Dec 2010 07:15:59 GMT

Hi,

Thanks for your reply.

Yes I have debugged and my code is going into that user exit.

I have called the function module in new task and comittted. This is the remedy I could find.

Re: Problem with updatin Ztable while blocking PGI

Former Member — Sun, 12 Dec 2010 07:16:24 GMT

solved by myself