topic Internal table query in Application Development and Automation Discussions

Internal table query

harish_padikkadmohananara — Mon, 30 Jul 2007 11:11:15 GMT

Hi,

I have a internal table with two columns c1 and c2.

I have three records r1,r2 and r3.These records are ,

A1 B1

A2 B2

A3 B3

Now i can have a record,

A1 B2

but not a record like,

A1 B1

again,so the duplication of the record need to be prevented.I need to know how to check for the duplication of existing records in the internal table with the newly added record.

Thank you.

Regards,

Harish

Re: Internal table query

Former Member — Mon, 30 Jul 2007 11:12:23 GMT

hi,

Use

DELETE ADJACENT DUPLICATES.

Re: Internal table query

Former Member — Mon, 30 Jul 2007 11:13:37 GMT

SORT ITAB BY <C1> <C2> .

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING C1 C2.

IF SY-SUBRC EQ 0.

<implies there are duplicate entries and are deleted>.

ELSE.

ENDIF.

Regards,

Pavan

Re: Internal table query

harish_padikkadmohananara — Mon, 30 Jul 2007 11:13:56 GMT

Can you elaborate?Also will this not affect the performace when it comes to many number of records being handled?

Re: Internal table query

Former Member — Mon, 30 Jul 2007 11:16:32 GMT

You can use the READ TABLE statement to check for duplicate entries.


READ TABLE itab WITH KEY c1 = value1
                         c2 = value2.

IF sy-subrc eq 0.
" Duplicate records exist
ENDIF.

Please mark points if the solution was useful.

Regards,

Manoj

Re: Internal table query

Former Member — Mon, 30 Jul 2007 11:20:25 GMT

Hi Harish,

SORT ITAB BY C1, C2.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING C1 C2.

<b>

Regards,

Azhar</b>