topic deleting entry from internal table in Application Development and Automation Discussions

deleting entry from internal table

Former Member — Wed, 22 Apr 2009 08:18:00 GMT

Hi Experts,

i have the following internal table:

data : it_result1 TYPE crmt_object_guid_tab

and work area

data : wa_result1 type crmt_object_guid.

i have to delete a guid from internal table based on some condition.

loop at it_resul1 into wa_result1

if lv_priority eq priority.

delete this entry from internal table.

endif.

endloop..

i tried using delete table it_result with table key CRMT_OBJECT_GUID = wa_result. but this is giving syntax error.

what should be done to delete the entry?

Thanks and regards

Shilpi

Re: deleting entry from internal table

_IvanFemia_ — Wed, 22 Apr 2009 08:20:22 GMT

Hi,

you're in a loop

use

DELETE it_result INDEX sy-tabix.

The sintax error that you have could be fixed by

delete table it_result with table key CRMT_OBJECT_GUID = wa_result1-CRMT_OBJECT_GUID. "specify the field and do not use all the work area

Regards,

Ivan

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 08:20:24 GMT

Check Syntax for DELETE operator on pressing F1

1. DELETE itab.

2. DELETE TABLE itab WITH TABLE KEY k1 = v1 ... kn = vn.

3. DELETE TABLE itab [FROM wa].

4. DELETE itab INDEX idx.

5. DELETE itab FROM idx1 TO idx2.

6. DELETE itab WHERE logexp.

7. DELETE ADJACENT DUPLICATES FROM itab.

delete table it_result with table key CRMT_OBJECT_GUID = wa_result

this is wrong

delete it_result where CRMT_OBJECT_GUID = wa_result

Edited by: Lavanya K on Apr 22, 2009 10:20 AM

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 08:21:23 GMT

Hi,

use the following:


delete table it_result with table key CRMT_OBJECT_GUID = wa_result1.

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 08:22:27 GMT

Use

delete table it_result where CRMT_OBJECT_GUID = wa_result-<fieldname>.(compare with fieldname of workarea not ebntire workarea.)

Thanks

Vijeta Galani

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 08:22:51 GMT

Hi Shilpi,

Delete the entry using the beow syntax.

DELETE TABLE table name FROM work area.

or get the index of the entry from the internal table and delete it

DELETE internal table name INDEX sy-tabix.

Hope this will help ou.

Regards,

Phani.

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 09:14:54 GMT

Try this,

Delete table it_result with table key CRMT_OBJECT_GUID = WA_RESULT1.

Regards,

Joan

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 12:46:47 GMT

Hi,

usually You can use delete statement to delete data from your internal table. For ex.

DELETE ITAB1 WHERE MATNR <> 105024 AND MATNR <> 105023 AND MATNR <> 100010 .

Regards,

Himanshu

Re: deleting entry from internal table

Former Member — Wed, 22 Apr 2009 13:09:10 GMT

Hi Shilpi,

You can try this.


data : it_result1 TYPE STANDARD TABLE OF crmt_object_guid_tab.

data : wa_result1 type crmt_object_guid.

loop at it_resul1 into wa_result1.

if lv_priority eq priority.

delete table it_result1 from wa_result1.

endif.

endloop.

Note: when you use the below syntax, you might face problem in capturing the correct index of the record, since records are being deleted.


DELETE it_result INDEX sy-tabix.