Commit Work Update Problem

[Former Member]

Hi,

I am facing a problem while commit to the Ztable.

Out of 90 times running of the program it is not commiting 1 or 2 times and it is not happing dailly also.And the senario where it is not commiting those cases are same as other where the program is running fine.

I have checked sm13 also and it is not showing any update problems through my Tcode.Is there any other Tcode where i can see the successful/unsuccessful update to the database.Transaction is a Z transaction.

I am doing :

CALL TRANSACTION 'VL01NO' USING it_bdcdata MODE lv_mode

UPDATE 'S'

MESSAGES INTO it_bdcmsgcoll.

READ TABLE it_bdcmsgcoll INTO wa_bdcmsgcoll WITH KEY msgtyp = 'S'

msgid = 'VL'

msgnr = '311'.

IF sy-subrc EQ 0. "Get the Delivery No

UPDATE zsd_order SET delivery_no = wa_bdcmsgcoll-msgv2

WHERE <<Condition>.

IF sy-subrc EQ 0.

COMMIT WORK AND WAIT.

ENDIF.

Thanks

[Sandeep_Panghal]

HI,

Watch out for TX SM13 , here you can see the status of your update work processes.

Rgds,

Sandeep

[Former Member]

HI.

use the Options statement in the call Transaction.

1. ... MODE mode

2. ... UPDATE upd

3. ... OPTIONS FROM opt

4. ... MESSAGES INTO itab

Fill the folowing fileds Options structure type CTU_PARAMS

DISMODE Processing mode for batch input processing. Values as for the MODE addition.

UPMODE Processing mode for batch input processing. Values as for the UPDATE addition.

RACOMMIT = 'X'

Selection as to whether the COMMIT WORK statement terminates batch input processing or not. Values: " " (COMMIT WORK terminates processing), "X" ( COMMIT WORK does not terminate processing).