Quick Viewer/SQ01

[Former Member]

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.

[Former Member]

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

[Former Member]

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.