Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Want to delete Rows from SAP Query which have u20180u2019 or blank values

Former Member

‎01-29-2010 5:44 AM

0 Kudos

Hi Experts,

I have made one sap-query, in that I have added some additional fields, after that I am getting some blank or u20180u2019 values in some rows, can anyone tell me how to delete those rows which have u20180u2019 or blank values.

Regards

Mahadev Roy

5 REPLIES 5

Former Member

‎01-29-2010 5:47 AM

0 Kudos 
DELETE itab WHERE itab-field1 = '0'

Former Member
In response to Former Member

‎01-29-2010 6:28 AM

0 Kudos

Hi,

In my SAP-Query I add some additional Field from SQ02 there is no ITab...

Former Member

‎01-29-2010 5:50 AM

0 Kudos

hi,

press F1 on delete and find out.

you might learn new ways as well.

Former Member

‎01-29-2010 5:55 AM

0 Kudos

Hi

Try this query.

Delete itab where itab-field eq '0' or itab-field eq space.

Thanks

Khushboo

Former Member

‎01-29-2010 7:39 AM

0 Kudos

Hi mahadev

You must be fetching data from SQ02 in some internal table.Delete values from that internal table.

Also as you are fetching records from SQ02 then in the select statement you can put this condition of '0' and blank

so that you will get appropriate result.

Thanks

Khushboo