topic Re: how can i delete data from internal table in Application Development and Automation Discussions

how can i delete data from internal table

Former Member — Wed, 20 Dec 2006 05:16:22 GMT

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 — Wed, 20 Dec 2006 05:19:50 GMT

Hi ,

Hi you can use the command

DELETE i_itmlim_rel WHERE objtype_a NS 'BUS2121'.

Regards

Arun

Message was edited by:

Arun R

Former Member — Wed, 20 Dec 2006 05:21:31 GMT

Hi,

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

Thanks,

Saida

Former Member — Wed, 20 Dec 2006 05:21:35 GMT

delete i_itmlim_rel where objtyp np 'BUS2121*'.

regards

shiba dutta

Former Member — Wed, 20 Dec 2006 05:22:13 GMT

Use this:

DELETE itab where field ne 'ABC'.

regards

Former Member — Wed, 20 Dec 2006 05:24:41 GMT

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 — Wed, 20 Dec 2006 05:33:18 GMT

hi,

try this code.

DELETE i_itmlim_rel WHERE objtype_a not like 'BUS2121%'.

i hope this will help u.