topic Re: delete rows from internal table giving dump in Application Development and Automation Discussions

delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 07:44:09 GMT

Hi All,

im trying to delete rows from my internal table using the below logic but its giving a dump.

Pls help.

LOOP at itabINTO wa.

    lv_int = strlen( wa ).

    lv_int = lv_int - 3.

    IF wa+lv_int(3) = 'XYZ'.

      DELETE itab FROM wa.

    ENDIF.

ENDLOOP.

Thanks & regards,

Faiz

Re: delete rows from internal table giving dump

Abhijit74 — Thu, 21 Mar 2013 07:53:57 GMT

Hello,

Do not delete within a loop. Take a flag field into your internal table. set flag for the record which you want to delete. Delete outside the loop, Delete the records where flag = 'X'.

Thanks,

Abhijit

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 07:58:29 GMT

Hi Faizur,

Dont use DELETE statement with in LOOP.

u can use below code.

take one field into ur Internal Table.

Like field DEL

data : lv_tabix type sytabix.

LOOP at itabINTO wa.
lv_tabix = sy-tabix.
    lv_int = strlen( wa ).

    lv_int = lv_int - 3.

    IF wa+lv_int(3) = 'XYZ'.

      now wa-del = 'X'.

modify itab from wa index l v_tabix.

ENDIF.

ENDLOOP.

DELETE ITAB WHERE DEL = 'X'.

It will work properly.

Thanks

tarak

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 08:02:06 GMT

hi,

the reason for the dump is because of this statement only..

LOOP at itabINTO wa.

    lv_int = strlen( wa ).

    lv_int = lv_int - 3.

    IF wa+lv_int(3) = 'XYZ'.

      DELETE itab FROM wa.

    ENDIF.

ENDLOOP.

lv_int = strlen( wa ). lv_int = lv_int - 3. this statement wont work definitely ..

wa must be a character type data object , i mean data type( C, N, D, T or STRING)

otherwise strlen wont work..

thanks,

Mathan R.

Re: delete rows from internal table giving dump

RaymondGiuseppi — Thu, 21 Mar 2013 08:04:53 GMT

Remove the "from WA". It is interpreted as a FROM idx1 [TO idx2] option and should have raised a CONVT_NO_NUMBER

Regards,

Raymond

Re: delete rows from internal table giving dump

reachdebopriya — Thu, 21 Mar 2013 08:05:18 GMT

Hi Faizur,

Check this code below.

Put a field flag type char1 in the structure of wa/itab.

Field-Symbol: <lfs_wa> type (structure name).

LOOP at itab assigning <lfs_wa>.

lv_int = strlen( <lfs_wa> ).

lv_int = lv_int - 3.

IF <lfs_wa>+lv_int(3) = 'XYZ'.

<lfs_wa>-flag = 'X'.
ENDIF.

ENDLOOP.

DELETE itab where flag EQ 'X'.

Regards,

Debopriya Ghosh

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 08:09:53 GMT

Hi Faizur,

You can try like dis.

DELETE table itab FROM wa.

Regards,

Santanu Mohapatra.

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 08:43:03 GMT

The best is to use index. It is accurate way of deleting the correct line of the itab.

LOOP at itab INTO wa.

lf_index = sy-tabix.

** all your checks.
    lv_int = strlen( wa ).
    lv_int = lv_int - 3.

    IF wa+lv_int(3) = 'XYZ'.

      " DELETE itab FROM wa.

delete itab index lf_index.

ENDIF.

clear : lf_index.

ENDLOOP.

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 09:31:37 GMT

Please avoid to use DELETE within LOOP.

Thanks

tarak

Re: delete rows from internal table giving dump

gurunathkumar_dadamu — Thu, 21 Mar 2013 09:32:51 GMT

Hi Faizur,

dont use the delete statement inside the loop.like this scenario use any flag and moidify the itab transporting the flag. after that try to delete where FLAG = 'X'.

Regards,

Gurunath Kumar D

Re: delete rows from internal table giving dump

vigneshyeram — Thu, 21 Mar 2013 09:58:37 GMT

Dear Faizur,

Its better to use index while deleting.

please check the below code.

data: lv_index type sy-index.

LOOP at itabINTO wa.

lv_index = sy-tabix.

lv_int = strlen( wa ).

lv_int = lv_int - 3.

IF wa+lv_int(3) = 'XYZ'.

DELETE itab index lv_index.

ENDIF.

clear: lv_index.

ENDLOOP.

Hope this helps you.

Kindly let me know your feedback.

Thanks & Regards,

Vignesh Yeram

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 10:04:30 GMT

Dear Rehman,

I think You are getting Null Value into the work area.

Use Sy-subrc After reading an internal table into Work Area .

And Put Ur Logic in the if Condition.

Read table into wa.

if sy-subrc = 0.

*****************

ur logic

*****************

End if.

This may help u.

Thanks & Regards

Kranthi Kumar Reddy G

Message was edited by: Kranthi Kumar Reddy

Re: delete rows from internal table giving dump

Former Member — Thu, 21 Mar 2013 11:02:30 GMT

hi,

Declare all fields in wa of type C, N, D or T...

Try this..

LOOP at itab INTO wa.

lv_index = sy-tabix.

lv_int = strlen( wa ).

lv_int = lv_int - 3.

IF wa+lv_int(3) = 'XYZ'.

wa-delete = 'X'.

MODIFY itab from wa index sy-tabix.

endif.

endloop.

DELETE itab where delete = 'X'.