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.
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.