topic delete table entries in Application Development and Automation Discussions

delete table entries

Former Member — Thu, 15 Nov 2007 13:19:02 GMT

i want to delete table entries based on the internal table

can i use for all entires for delete?

if so how?

i dont want to use loop as it takes more time

regards

senthtil

Re: delete table entries

Former Member — Thu, 15 Nov 2007 13:21:44 GMT

FOR ALL ENTRIES is not available to DELETE.

You can use the WHERE or the INDEX statements.

DELETE itab WHERE matnr = '123'.

LOOP AT itab2.

DELETE itab INDEX sy-tabix. "delete by itab2's SY-TABIX

ENDLOOP.

Regards

Tamá

Re: delete table entries

Former Member — Thu, 15 Nov 2007 13:21:51 GMT

Hi Senthil,

do like this

delete <itab> where ....

Reward if it helps,

Satish

Re: delete table entries

Former Member — Thu, 15 Nov 2007 14:08:15 GMT

Hi,

You can use as below :

Delete itab where fieldname = 'some value'.

Above code will delete all the entries from the internal table which satisfies the condition.

Thanks,

Sriram Ponna.

Re: delete table entries

kostas_tsioubris — Thu, 15 Nov 2007 14:12:06 GMT

Hi,

you are not making clear if you want to delete the internal table entries or ddic table entries, in case you want to delete internal table entries use one of the above suggestions else use something like this.

delete ddic_table from table itab[].

Kostas