Delete Command in Internal table

[Former Member]

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.

[Former Member]

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