topic Re: delete from itab in Application Development and Automation Discussions

delete from itab

Former Member — Mon, 31 Dec 2007 12:25:03 GMT

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 — Mon, 31 Dec 2007 12:26:29 GMT

Hi,

Use below code

delete itab where qty = 0 and price = 0.

L.Velu

Former Member — Mon, 31 Dec 2007 12:27:14 GMT

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 — Mon, 31 Dec 2007 12:27:52 GMT

Hi,

Try this code

loop at itab where <field> = 0.

delete itab index sy-tabix.

endloop.

Former Member — Mon, 31 Dec 2007 12:27:55 GMT

nt working

Former Member — Mon, 31 Dec 2007 12:28:31 GMT

DELETE itab WHERE qty EQ 0.

"OR

DELETE itab WHERE price EQ 0.

Former Member — Mon, 31 Dec 2007 12:29:00 GMT

Wat do you mean by nt working

Former Member — Mon, 31 Dec 2007 12:47:38 GMT

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

delete itab where <primary key > equals 0.

with regards,

Hema Sundara.