topic MODIFY and DELETE statement does not work... in Application Development and Automation Discussions

MODIFY and DELETE statement does not work...

aris_hidalgo — Fri, 09 May 2008 07:03:26 GMT

Hello Experts,

I am encountering a problem when using the MODIFY and DELETE statement in my

program because it seems that it does not work when I run the program. But if I check it in

debugging mode, it works. Below is my code:


LOOP AT lcl_data_def=>gt_zsalesorder ASSIGNING <fs_zsalesorder>.
      CALL FUNCTION 'ZSD_UPDATE_SO_PRICINGTYPE' DESTINATION lcl_data_def=>gv_destination
        EXPORTING
          im_vbeln   = <fs_zsalesorder>-object_id
        IMPORTING
          ex_icon    = lcl_data_def=>wa_status-icon
          ex_status  = lcl_data_def=>wa_status-status
          ex_message = lcl_data_def=>wa_status-message.

      APPEND lcl_data_def=>wa_status TO lcl_data_def=>gt_status.

      IF lcl_data_def=>wa_status-status = lc_s.
        <fs_zsalesorder>-flag = 'X'.
        MODIFY zsalesorder FROM <fs_zsalesorder>.
        COMMIT WORK AND WAIT.
      ENDIF.
      CLEAR lcl_data_def=>wa_status.
    ENDLOOP.
    DELETE zsalesorder FROM TABLE lcl_data_def=>gt_zsalesorder.
    COMMIT WORK AND WAIT.

Hope you can help me guys. Thank you and take care!

Re: MODIFY and DELETE statement does not work...

former_member188827 — Fri, 09 May 2008 07:09:01 GMT

try removing and wait addition from comit work statement abnd see if it works

Re: MODIFY and DELETE statement does not work...

aris_hidalgo — Fri, 09 May 2008 07:17:02 GMT

Hi,

I removed the AND WAIT addition and it still does not work.

Re: MODIFY and DELETE statement does not work...

former_member188827 — Fri, 09 May 2008 07:23:04 GMT

wat is the return code after modify statement in debugging and also after commit?

Re: MODIFY and DELETE statement does not work...

aris_hidalgo — Fri, 09 May 2008 07:28:12 GMT

Hi,

the value is '0'.

Thanks!

Re: MODIFY and DELETE statement does not work...

former_member188827 — Fri, 09 May 2008 07:31:12 GMT

this means dis is working...wat is actually happening? wen u check ur table zsalesorder in se11 does entry still exits after delete statement...

Re: MODIFY and DELETE statement does not work...

aris_hidalgo — Fri, 09 May 2008 07:37:39 GMT

Yup.

Re: MODIFY and DELETE statement does not work...

Former Member — Fri, 09 May 2008 08:14:37 GMT

please close your execution screen after execution and check in se11 (or)

goto to the pgmscreen from execution screen and then check in se11