topic Delete statement in Application Development and Automation Discussions

Delete statement

Former Member — Mon, 13 Nov 2006 21:13:50 GMT

Hello friends,

I have to delete a record from an Internal table based on comparing two fields from the same line in the Internal table.

I am using this code.

LOOP AT itab.

IF itab-01_kschl = 'ZBX1'.

IF itab-02_kschl <> 'ZAXS' OR

itab-02_kschl <> 'ZRON' OR

itab-02_kschl <> 'ZTIS' .

DELETE itab index sy-tabix.

ENDIF

ENDIF.

ENDLOOP.

I am kind of worried to delete using the sy-tablx as the index. Is there a bettew way to handel this issue.

Thanks.

Shejal.

Re: Delete statement

RichHeilman — Mon, 13 Nov 2006 21:18:51 GMT

You don't need the INDEX in the DELETE statement, and your IF statement should have AND, not OR.

LOOP AT itab.
IF itab-01_kschl = 'ZBX1'.
   IF itab-02_kschl <> 'ZAXS' and
       itab-02_kschl <> 'ZRON' and
       itab-02_kschl <> 'ZTIS' .
     DELETE itab.
   ENDIF
ENDIF.
ENDLOOP.

Regards,

Rich Heilman

Re: Delete statement

Former Member — Mon, 13 Nov 2006 21:20:34 GMT

Hi,

Try this..

DELETE ITAB WHERE 01_KSCHL = 'ZBX1' AND

( 02_KSCHL <> 'ZAXS' AND

02_KSCHL <> ZRON' AND

02_KSCHL <> 'ZTIS' ).

Thanks,

Naren

Re: Delete statement

former_member194669 — Mon, 13 Nov 2006 21:20:40 GMT

Hi,

Move the condition values to a range and use syntax

delete itab where kschl in r_range.

aRs

Re: Delete statement

Former Member — Mon, 13 Nov 2006 21:23:32 GMT

I'm not sure your logic is correct. Do you want to:

delete itab 
  where 01_kschl =  'ZBX1'
    and 02_kschl <> 'ZAXS'
    and 02_kschl <> 'ZRON'
    and 02_kschl <> 'ZTIS'.

Rob

Re: Delete statement

Former Member — Mon, 13 Nov 2006 21:23:56 GMT

Thanks Rich, Naren and Mony.

Thanks again for your advice and help.

Shejal.

Re: Delete statement

uwe_schieferstein — Mon, 13 Nov 2006 21:24:08 GMT

Hello Shejal

You could simplify your DELETE statement like this:

DELETE itab WHERE   ( 01_kschl = 'ZBX1'  )
                    AND NOT ( 02_kschl = 'ZAXS'  OR
                                     02_kschl = 'ZRON'  OR
                                     02_kschl = 'ZTIS' ).

Regards

Uwe