topic Delete Statement in Application Development and Automation Discussions

Delete Statement

Former Member — Thu, 19 Nov 2009 14:33:42 GMT

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

Former Member — Thu, 19 Nov 2009 14:36:01 GMT

Hello,

Try this way,


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

Vikranth

Former Member — Thu, 19 Nov 2009 14:37:12 GMT

HI,

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

try to use offet.

regards,

Former Member — Thu, 19 Nov 2009 14:41:17 GMT

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