Skip to Content
0
Former Member
Nov 30, 2009 at 09:07 PM

Internal Table Comparision

36 Views

Hi,

I have two internal tables both have them large no of records.

For ex: it_large this table has about 150,00-200,00 records on average. It has 3 fields item_id, text and type.

and it_small this tables has about 60,000-80,000 records on average. Just has one field item_id.

I want to find records from it_large which are not contained in it_small.

What is the best way to do so?

I currently use following logic:

loop at it_large assingning <ls_large>.

read table it_small assigning <ls_small> with table key item_id = <ls_large>-item_id.

if sy-subrc <> 0.
* populate missing items internal table
end f.
endloop.

Thanks in advance,

CD