Skip to Content
0
Former Member
Dec 04, 2008 at 04:54 PM

How to avoid duplicated entries in database view

344 Views

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.