topic Re: Deleteing from itab...... in Application Development and Automation Discussions

Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:36:26 GMT

Hi Experts,

I have records in itab. For. e.g.

Order No. Vornr Qty.

123 0010 15

123 0010 2

123 0020 3

123 0030 13

123 0030 12

123 0030 9.

I want to delete Vornr = 0010 and 0020 from itab. Only 0030 i want to keep.

There are multiple orders with multiple aufnr vornr.

Pl. guide me......

Yusuf

Re: Deleteing from itab......

former_member156446 — Thu, 20 Dec 2007 05:37:48 GMT

delete from itab where Vornr NE 30

Re: Deleteing from itab......

former_member194669 — Thu, 20 Dec 2007 05:39:31 GMT



delete itab where Vornr = 0010 or Vornr = 0020.

a®

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:40:52 GMT

delete from itab where vornr != 0030

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:42:07 GMT

hi.,

use following command after fetching the data into internal table.

delete itab where vornr NE 0030.

Reward points if useful

Edited by: Chandrasekhar Velpula on Dec 20, 2007 6:43 AM

Re: Deleteing from itab......

kesavadas_thekkillath — Thu, 20 Dec 2007 05:42:07 GMT

if ur requirement is to delete 0010 and 0020

just go for delete itab where vornr = 0010 and vornr = 0020.

or u r requirement is something else ???

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:42:37 GMT

DELETE TABLE itab WITH TABLE KEY vornr = '0010'.

DELETE TABLE itab WITH TABLE KEY vornr = '0020'.

DELETE Itab WHERE vornr ne '0030'.

Re: Deleteing from itab......

former_member386202 — Thu, 20 Dec 2007 05:42:48 GMT

Hi,

Do like this

Loop at itab.

if ( itab-vornr eq '0010' ) or

( itab-vornr eq '0020' ).

delete itab.

endif.

endloop.

Regards,

Prashant

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:44:46 GMT

DELETE itab WHERE VORNR NE '0030'.

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:46:15 GMT

Hi,

delete itab where Vornr NE '0030'

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:46:30 GMT

Hi,

To delete more than one line using a condition, use the following statement:

DELETE <itab> WHERE <cond>.

In your case:

DELETE itab WHERE Vornr NE 0030.

Regards,

Bhaskar

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:46:34 GMT

Hi Jack,

This is not so simple that u were explaining.

There are multiple vornr and aufnr

Like vornr upto 120 in some of same order.

Yusuf

Re: Deleteing from itab......

former_member194669 — Thu, 20 Dec 2007 05:55:45 GMT

Create a range and fill all values of VORNR you want to delete in LOW and then use

delete itab where vornr in r_vornr.

" Here r_vornr is range

a®

Re: Deleteing from itab......

Former Member — Thu, 20 Dec 2007 05:57:20 GMT

Hi,

how many values u have doesnt matter,

say u have 10 vornr values, populate all vornr into A range like below

r_vornr-option = 'I'.

r_vornr-sign = 'EQ'.

move '0030' to r_vornr-low.

append r_vornr.

clear r_vornr-low.

r_vornr-option = 'I'.

r_vornr-sign = 'EQ'.

move '0050' to r_vornr-low.

append r_vornr.

clear r_vornr-low.

sort itab.

loop at itab where vornr in r_vornr.

move itab to itab_new.

append itab_new.

clear itab_new.

endloop.

now itab_new will contain required values alone