Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Database view multiple records

Go to solution
kumaro412
Active Participant

‎01-20-2014 4:25 PM

0 Kudos

Dear all,

There has been created a database view to find some values from vbak, vbap, vbep and mvke ...

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 ?

Does anyone know why this is wrong ?

Preview file
235 KB
Preview file
92 KB
1 ACCEPTED SOLUTION

Go to solution
ThomasZloch
Active Contributor

‎01-20-2014 4:29 PM

0 Kudos

Quick guess, no guarantee: MANDT field is missing from the link to MVKE, maybe try including this.


Thomas

4 REPLIES 4

Go to solution
ThomasZloch
Active Contributor

‎01-20-2014 4:29 PM

0 Kudos

Quick guess, no guarantee: MANDT field is missing from the link to MVKE, maybe try including this.


Thomas

Go to solution
Former Member

‎01-20-2014 5:36 PM

0 Kudos

Hi Kurt,

Include MVKE-MANDT in Join conditions. Otherwise you will get multiple entries if you have MKVE entries in other clients.

Go to solution
edgar_nagasaki
Contributor

‎01-20-2014 7:21 PM

0 Kudos

Hi Kurt,

Noticed that only table you're not using all key fields is VBPE (ETENR - Delivery Schedule Line Number -  is missing) therefore would suggest you to check if you don't have 2 entries there for you selection.

Regards,

Edgar

Go to solution
edgar_nagasaki
Contributor
In response to edgar_nagasaki

‎01-20-2014 7:30 PM

0 Kudos

In time, if it's the case you could add a criteria in selection conditions tab.