Skip to Content

No data in Query report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 12 at 01: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'.

    Add comment
    10|10000 characters needed characters exceeded