Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

delete from itab

Former Member
0 Likes
892

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
871

Hi,

Try this code

loop at itab where <field> = 0.

delete itab index sy-tabix.

endloop.

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

7 REPLIES 7
Read only

Former Member
0 Likes
871

Hi,

Use below code

delete itab where qty = 0 and price = 0.

L.Velu

Read only

Former Member
0 Likes
871

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

Read only

0 Likes
871

nt working

Read only

0 Likes
871

Wat do you mean by nt working

Read only

Former Member
0 Likes
872

Hi,

Try this code

loop at itab where <field> = 0.

delete itab index sy-tabix.

endloop.

Read only

Former Member
0 Likes
871

DELETE itab WHERE qty EQ 0.

"OR

DELETE itab WHERE price EQ 0.

Read only

Former Member
0 Likes
871

Hi

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

delete itab where <primary key > equals 0.

with regards,

Hema Sundara.