Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Quick Viewer/SQ01

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.

Tags:
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question