delete from itab

[Former Member]

material Qty Price

A 0 0

B 10 100

C 20 60

I wish to remove zero entry from my itab.How can i do so.

Regards

[Former Member]

Hi,

Use below code

delete itab where qty = 0 and price = 0.

L.Velu

[Former Member]

Hi

check this delete itab where qty = 0 .

or you can wirte

delete itab where price = 0.

or both at a time

delete itab where qty = 0 and price = 0.

regards,

siva chalasani

[Former Member]

nt working

[Former Member]

Wat do you mean by nt working

[Former Member]

Hi,

Try this code

loop at itab where <field> = 0.

delete itab index sy-tabix.

endloop.

[Former Member]

DELETE itab WHERE qty EQ 0.

"OR

DELETE itab WHERE price EQ 0.

[Former Member]

Hi

just based on the primary key field u can do this like,

delete itab where <primary key > equals 0.

with regards,

Hema Sundara.