How to avoid duplicated entries in database view

[Former Member]

Hi,

I created a database view to show all the customers from KNA1 who has order(s) in VBAK, here is

my join condition:

KNA1-MANDT = VBAK-MANDT

KNA1-KUNNR = VBAK-KUNNR

In view fields I have KNA1-KUNNR and KNA1-NAME1.

My problem is, if a customer has 10 orders, then it's id and name will show 10 times in the view.

How can I avoid the duplicates?

Thank you.

[former_member194669]

I don't think this is possible. You have SELECT....DISTINCT while selecting records from these database view.

a®