i have 2 internal table. itab and itab1
itab1
material1 material2 qty
aaa 123 1
aaa 456 3
itab2
material1 material2 material3 values
aaa 123 xyz 1a
aaa 123 x1y1 2b
aaa 123 x2z2 1a
bbb 456 abc 4g
ddd 789 pqr 2g
ddd 789 lmn 5g
ddd 789 1bc 7h
i need to compare both the internal tables with material1 and material2, In the 2nd internal table the field material2's records comes three or more times i need to remove those records from the internal tabel and append the correct records into another table.
How to add with out this values into another internal table.
From the above example i need to remove aaa and ddd from the internal and append only bbb from here to itab3.
any one help this?
Mohana