topic Re: Quick Viewer/SQ01 in Application Development and Automation Discussions

Quick Viewer/SQ01

Former Member — Tue, 23 Sep 2008 05:27:42 GMT

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.

Re: Quick Viewer/SQ01

Former Member — Tue, 23 Sep 2008 05:28:26 GMT

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

Re: Quick Viewer/SQ01

Former Member — Tue, 23 Sep 2008 05:36:25 GMT

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.