topic How to avoid duplicated entries in database view in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-duplicated-entries-in-database-view/m-p/4792505#M1122469 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I created a database view to show all the customers from KNA1 who has order(s) in VBAK, here is</P><P>my join condition:</P><P></P><P>KNA1-MANDT = VBAK-MANDT</P><P>KNA1-KUNNR = VBAK-KUNNR</P><P></P><P>In view fields I have KNA1-KUNNR and KNA1-NAME1.</P><P></P><P>My problem is, if a customer has 10 orders, then it's id and name will show 10 times in the view.</P><P>How can I avoid the duplicates?</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 04 Dec 2008 16:54:01 GMT Former Member 2008-12-04T16:54:01Z How to avoid duplicated entries in database view https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-duplicated-entries-in-database-view/m-p/4792505#M1122469 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I created a database view to show all the customers from KNA1 who has order(s) in VBAK, here is</P><P>my join condition:</P><P></P><P>KNA1-MANDT = VBAK-MANDT</P><P>KNA1-KUNNR = VBAK-KUNNR</P><P></P><P>In view fields I have KNA1-KUNNR and KNA1-NAME1.</P><P></P><P>My problem is, if a customer has 10 orders, then it's id and name will show 10 times in the view.</P><P>How can I avoid the duplicates?</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 04 Dec 2008 16:54:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-duplicated-entries-in-database-view/m-p/4792505#M1122469 Former Member 2008-12-04T16:54:01Z Re: How to avoid duplicated entries in database view https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-duplicated-entries-in-database-view/m-p/4792506#M1122470 <HTML><HEAD></HEAD><BODY><P>I don't think this is possible. You have SELECT....DISTINCT while selecting records from these database view.</P><P></P><P>a®</P><P></P></BODY></HTML> Thu, 04 Dec 2008 17:12:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-duplicated-entries-in-database-view/m-p/4792506#M1122470 former_member194669 2008-12-04T17:12:21Z