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: 

Quick Viewer/SQ01

Go to solution
Former Member

‎09-23-2008 6:27 AM

0 Kudos

I need to fetch data i.e. data extraction from production using quick viewer.

I need to fetch from the below tables

LFA1, LFB1, LFBK, LFM1, BNKA, ADR6

1st four tables are have LIFNR field common, I am able to map all 6 tables. But when I map last two tables data is not retrieved may be bacuse I am using partial primary keys. Please advise how to fetch data from all the 4 tables.

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎09-23-2008 6:28 AM

0 Kudos

Sorry, from all 6 tables.. how to extract data? Please advise

2 REPLIES 2

Go to solution
Former Member

‎09-23-2008 6:28 AM

0 Kudos

Sorry, from all 6 tables.. how to extract data? Please advise

Go to solution
former_member188685
Active Contributor
In response to Former Member

‎09-23-2008 6:36 AM

0 Kudos

You need to change the Join Conditions from Inner Join to Left Outer Join to get all the data. If you Don't use the Proper joins you will not get the correct/full data.