topic Re: Delete Command in Internal table in Application Development and Automation Discussions

Delete Command in Internal table

Former Member — Thu, 10 Apr 2008 04:08:55 GMT

Hi Friends,

Currently i am using DELETE command in internal table. My main requirement is delete the records in internal table based on the select -options given in Selection screen.

Synatx is given below.

DELETE i_list WHERElifsk NOT in S_lifsk[].

It is working fine if we give positive values ie EQ 24 etc.

if we give negetive values if NE 23(in select options) here

sy-subrc is failing.

Can any one kindly suggest.

Regards,

DVNS.

Re: Delete Command in Internal table

Former Member — Thu, 10 Apr 2008 04:49:28 GMT

Hi DV

Its so simple... u r requirement is to delete all the entries which are not in the select options.

Ur sintax is working correct. Because, even if u hit a database table with select querry using this select option, it will fetch all the positive entries and excludes all negative entries....

if still u feel problem is persisting... then fetch the lifsk from db table using this select option into an internal table and then filter how ever u want.

Venkata Raju Duggirala