02-12-2018 12:42 PM
Dear team,
I have created a query report with general data, purchasing data and sales data for material master with table link MARA, MARC & MVKE. When executing the report, materials with both purchasing and sales view appears properly, whereas material with no sales view (MVKE) is not appearing in report. Is there any settings so that i can view the report (general and purchasing data for material with no sales view) even there is no sales view extended.
Thanks in advance
Ben
02-12-2018 1:14 PM
In Abap code, use a LEFT [OUTER] JOIN option in your open-sql statement, in SQ02 right-click on arrow between the two tables and select 'Left Outer Join'.
02-12-2018 1:14 PM
In Abap code, use a LEFT [OUTER] JOIN option in your open-sql statement, in SQ02 right-click on arrow between the two tables and select 'Left Outer Join'.
02-12-2018 3:12 PM