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: 

Delete Statement

Go to solution
Former Member

‎11-19-2009 2:33 PM

0 Kudos

I'm hoping someone can help me

What i want to do is delete all lines from a internal table where 'REL' in not contained in a field.

The problem is that there is other sets of letters in the field as well, so I can't use the NOT EQUAL statement.

Is there some kind of CONTAINS statement.

Thanks

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎11-19-2009 2:36 PM

0 Kudos

Hello,

Try this way,


DELETE itab where not field CP '*REL*'.

Vikranth

3 REPLIES 3

Go to solution
Former Member

‎11-19-2009 2:36 PM

0 Kudos

Hello,

Try this way,


DELETE itab where not field CP '*REL*'.

Vikranth

Go to solution
Former Member

‎11-19-2009 2:37 PM

0 Kudos

HI,

Delete from it_data where field+0(3) Eq 'REL'... if the REL is inthe first 3 letters.

try to use offet.

regards,

Aj

Go to solution
Former Member

‎11-19-2009 2:41 PM

0 Kudos

Hi Mlockett,

You can make use of String operation like CO (Contains only), CA (Contains any) etc.

LOOP AT ITAB INTO WA.

IF WA CA 'REL'.

DELETE table ITAB FROM WA TRANSPORTING xxxx.

ENDIF.

Kindly set to resolved if it helps you..

Regards

Abhii

Edited by: Abhii on Nov 19, 2009 3:41 PM

Edited by: Abhii on Nov 19, 2009 3:42 PM