Community
Application Development and Automation 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: 
Read only

ME80FN sapquery join problem

Former Member

‎2007 Apr 23 6:33 PM

0 Likes
451

Hello,

we have uncovered a problem with one of our custom queries and I am not sure how to find it let alone correct it. Last year I had to make a change to the me80fn query to add some fields from the EKKN table. I added the tale and the fields and everything was good. What we are finding out now that the query is only showing records that have entries in the EKKN. it is like it did a inner join on the ekkn table. I am trying to find where I see the joins for the tables and after that, I think I have to change it to an outer join. I have some documentation but it is not helping. I also am looking the SQVI bit I am not sure this is working wither. Can some one let me know how to view the joins on the table to see if that is the problem. also if they are all inner joins, how to correct it to create the outer join on the EKKN table.

thanks in advance

2 REPLIES 2
Read only

Former Member

‎2007 Apr 27 4:28 PM

0 Likes
397

I have received no responses to this thread.

Read only

Former Member

‎2007 Apr 27 7:40 PM

0 Likes
397

ME80FN uses logical database MEPOLDB. Since this database already includes EKKN, you would probably be better off using GETs rather than SELECTs.

Rob