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