we have used 3 different tables for Material interface joining with left outer joins and material ID is used as common field.
Now, Issue is few materials have different sales organizations and descriptions so in case if material has two sales org and description for each sales org then interface should transfer 2 records however it is transferring 4 records because descriptions are sent twice for each sales org.
Material ID 767
sales org 0001 and 0002
description are AA with language key 1 and BB with language key 2.
now, output is like
we need output like below using language key
can you please help here? I