topic Re: No data in Query report in Application Development and Automation Discussions

No data in Query report

Former Member — Mon, 12 Feb 2018 12:42:43 GMT

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

Re: No data in Query report

RaymondGiuseppi — Mon, 12 Feb 2018 13:14:55 GMT

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

Re: No data in Query report

Former Member — Mon, 12 Feb 2018 15:12:27 GMT

wow works great thank you so much.