how can i delete data from internal table

[Former Member]

how can i delete data form internal table containting multiple rows where

a field which contain 'abc*' should not be deleted

i am trying this but its not working and i dont want to use loop .

DELETE i_itmlim_rel WHERE objtype_a NA 'BUS2121*'.

thanks in advance

naval bhatt

[Former Member]

delete i_itmlim_rel where objtyp np 'BUS2121*'.

regards

shiba dutta

[Former Member]

Hi ,

Hi you can use the command

<b>

DELETE i_itmlim_rel WHERE objtype_a NS 'BUS2121'.

</b>

Regards

Arun

Message was edited by:

Arun R

[Former Member]

Hi,

Remove astrick('*') in where condition and try.

Thanks,

Saida

[Former Member]

delete i_itmlim_rel where objtyp np 'BUS2121*'.

regards

shiba dutta

[Former Member]

Use this:

DELETE itab where field ne 'ABC'.

regards

[Former Member]

Hi,

loop at i_itmlim_rel.
if objtype_a cp 'abc*'.
else.
DELETE i_itmlim_rel.
endif.
endloop.

Don't use negative logic in your code. It won't give proper results some times.

Regards

Bhupal Reddy

[Former Member]

hi,

try this code.

DELETE i_itmlim_rel WHERE objtype_a <b>not like</b> 'BUS2121<b>%</b>'.

i hope this will help u.