Delete statement

[Former Member]

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.

[RichHeilman]

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

[Former Member]

Hi,

Try this..

DELETE ITAB WHERE 01_KSCHL = 'ZBX1' AND

( 02_KSCHL <> 'ZAXS' AND

02_KSCHL <> ZRON' AND

02_KSCHL <> 'ZTIS' ).

Thanks,

Naren

[former_member194669]

Hi,

Move the condition values to a range and use syntax

delete itab where kschl in r_range.

aRs

[Former Member]

Thanks Rich, Naren and Mony.

Thanks again for your advice and help.

Shejal.

[Former Member]

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

[uwe_schieferstein]

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