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.