topic Database view multiple records in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009253#M1805340 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>There has been created a database view to find some values from vbak, vbap, vbep and mvke ...</P><P>The join conditions seems correct, but still the result returns 2 records (in stead of 1 record) ... The difference between the two records is the value of the field from MVKE ?</P><P>Does anyone know why this is wrong ?</P></BODY></HTML> Mon, 20 Jan 2014 16:25:08 GMT kumaro412 2014-01-20T16:25:08Z Database view multiple records https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009253#M1805340 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>There has been created a database view to find some values from vbak, vbap, vbep and mvke ...</P><P>The join conditions seems correct, but still the result returns 2 records (in stead of 1 record) ... The difference between the two records is the value of the field from MVKE ?</P><P>Does anyone know why this is wrong ?</P></BODY></HTML> Mon, 20 Jan 2014 16:25:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009253#M1805340 kumaro412 2014-01-20T16:25:08Z Re: Database view multiple records https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009254#M1805341 <HTML><HEAD></HEAD><BODY><P>Quick guess, no guarantee: MANDT field is missing from the link to MVKE, maybe try including this.</P><P><BR />Thomas</P></BODY></HTML> Mon, 20 Jan 2014 16:29:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009254#M1805341 ThomasZloch 2014-01-20T16:29:57Z Re: Database view multiple records https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009255#M1805342 <HTML><HEAD></HEAD><BODY><P>Hi Kurt,</P><P></P><P>Include MVKE-MANDT in Join conditions. Otherwise you will get multiple entries if you have MKVE entries in other clients.</P></BODY></HTML> Mon, 20 Jan 2014 17:36:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009255#M1805342 Former Member 2014-01-20T17:36:08Z Re: Database view multiple records https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009256#M1805343 <HTML><HEAD></HEAD><BODY><P>Hi Kurt,</P><P></P><P>Noticed that only table you're not using all key fields is VBPE (ETENR - Delivery Schedule Line Number -&nbsp; is missing) therefore would suggest you to check if you don't have 2 entries there for you selection.</P><P></P><P>Regards,</P><P>Edgar</P></BODY></HTML> Mon, 20 Jan 2014 19:21:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009256#M1805343 edgar_nagasaki 2014-01-20T19:21:29Z Re: Database view multiple records https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009257#M1805344 <HTML><HEAD></HEAD><BODY><P>In time, if it's the case you could add a criteria in selection conditions tab.</P></BODY></HTML> Mon, 20 Jan 2014 19:30:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view-multiple-records/m-p/10009257#M1805344 edgar_nagasaki 2014-01-20T19:30:03Z