Deleteing from itab......

[Former Member]

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

[Former Member]

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

[former_member156446]

delete from itab where Vornr NE 30

[Former Member]

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

[former_member194669]

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®

[former_member194669]

delete itab where Vornr = 0010 or Vornr = 0020.

a®

[Former Member]

delete from itab where vornr != 0030

[Former Member]

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

[kesavadas_thekkillath]

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 ???

[Former Member]

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

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

OR

DELETE Itab WHERE vornr ne '0030'.

[former_member386202]

Hi,

Do like this

Loop at itab.

if ( itab-vornr eq '0010' ) or

( itab-vornr eq '0020' ).

delete itab.

endif.

endloop.

Regards,

Prashant

[Former Member]

DELETE itab WHERE VORNR NE '0030'.

[Former Member]

Hi,

delete itab where Vornr NE '0030'

[Former Member]

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

[Former Member]

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