I have a similar problem. I'm working with the table tccom100 as my main table.
Now i want to view only those business partners who have an entry in the table tdpur400. But the problem is that there are multiple records in the table tdpur400 with a single business partner and i'm not able to use the query.extend to return distinct records. As a result i have duplicate Business partner records. Is there any way to solve this.