topic delete from internal table based on select options in Application Development and Automation Discussions

delete from internal table based on select options

Former Member — Mon, 12 May 2008 12:33:20 GMT

example :

selection-options : s_vbeln .

it has 1 to 10 low and high values

internal table it_vbeln has 1 - 20 vbeln values .

now i wanna delete entries which are not applicable as per s_vbeln.

that is from 11 to 20 must be deleted .

Please help.

Re: delete from internal table based on select options

Former Member — Mon, 12 May 2008 12:37:14 GMT

loop at it_vbeln .

if it_vbeln-vbeln in s_vbeln .

else.

delete it_vbeln index sy-tabix.

endif.

endloop.

Re: delete from internal table based on select options

Former Member — Mon, 12 May 2008 12:39:09 GMT

This should work.


tables: vbak.
DATA: BEGIN OF itab OCCURS 0,
  vbeln LIKE vbak-vbeln,
  END OF itab.

SELECT-OPTIONS s_vbeln for vbak-vbeln.

DELETE itab WHERE NOT vbeln IN s_vbeln.

Re: delete from internal table based on select options

Former Member — Mon, 12 May 2008 12:39:10 GMT

Hello,

Try this:


  DELETE it_vbeln WHERE NOT vbeln IN s_vbeln.

Regards,

Re: delete from internal table based on select options

Former Member — Mon, 12 May 2008 12:59:30 GMT

Hi,

You can use single row operation :

delete it_vbeln where not vbeln in s_vbeln.

thanks