Getting duplicate records in database view

[former_member620811]

Hi Experts,

I have created one view using KAN1,KNVP,ADRC & TPART tables.

I have attached join condition & fields screenshot, Please have a look.

view.png

view-fields.png

Issue is I am getting triple entries for the same records,could you please help me to solve this issue?

view-entries.png

Thank you in advance!

[former_member620811 · Accepted solution]

Hi,

Problem has been solved by using 'MANDT' field from all the tables in join condition.

Thanks!

[VeselinaPeykova]

KNVP stores partner functions and partner number per sales area (VKORG/VTWEG/SPART).

If your customer is extended for multiple sales areas and if you have this partner function ZM and partner 50007605 for more than one sales area you will get more than one record as a result

[former_member620811]

Hi Veselina,

Thanks for your response.

'50007605' this is not partner , its personal number for the customers.

If I am having all the fields as key then how we can get all same entries for one customer and same partner function?

PFA for selection area as well.

selection.png

Please let me know if there is any solution!

[VeselinaPeykova]

varsha2510 for KNVP table this is partner number. Partners can be vendors, customers, contact persons, employees and so on.

Make a simple SQVI, add the fields for the sales area and most probably this will be the reason why you have multiple entries.

If you want to ensure that you have no more than 1 result then you have to add sales area fields as criterion.