topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Fri, 13 Apr 2007 14:02:54 GMT

Hi All,

I have a internal table itab.

Is there any fuction module or any other way by which i check out all the duplicate entries in my itab and remove it.

regards,

Raman

Re: internal table

Former Member — Fri, 13 Apr 2007 14:07:51 GMT

Hi Raman...

There is a way to achieve this.

use the statement:

sort itab by field1 field2.

delete adjacent duplicates from itab comparing field1 field2 .

here itab is the internal table and field1 and field2 are the fields if internal table itab.

see the following link :

http://help.sap.com/saphelp_nw04/helpdata/en/06/aafd54fc4011d195280000e8353423/frameset.htm

Hope it helps you...

Let me know if u have any more doubt...

Reward points if useful......

Suresh.......

Re: internal table

RichHeilman — Fri, 13 Apr 2007 14:09:39 GMT

Sort it by the key, and then use the DELETE ADJACENT DUPLICATES statement.

sort itab ascending by keyfield.
delete adjacent duplicates from itab comparing keyfield.

Regards,

Rich Heilman

Re: internal table

Former Member — Fri, 13 Apr 2007 14:10:16 GMT

Hi Raman,

There is no function module which will deletes duplicate entries in an internal table.

But SAP provides you a OPEN SQL statement DELETE statement which will do for your requirement.

Syntax:

DELETE ADJACENT DUPLICATES FROM itab.

Check this link to know about DELETE statement

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/delete_i.htm

Thanks,

Vinay

Re: internal table

Former Member — Fri, 13 Apr 2007 14:16:20 GMT

Thanks a lot for all your replies.

I got the soluition.

Just one more question related to the reply from Rich.

how can i define primary key from my internal table

regards,

Raman

Re: internal table

RichHeilman — Fri, 13 Apr 2007 14:18:23 GMT

No need to define it, simply sort the internal table by the columns that you want to compare for duplicates. So if the duplicates are based on two fields, then sort by those two fields and have both in the COMPARING list.

Regards,

Rich Heilman

Re: internal table

Former Member — Fri, 13 Apr 2007 14:21:13 GMT

check something like this

DATA:  z_itab1 TYPE TABLE OF z_index WITH NON-UNIQUE KEY field1.