Skip to Content

No data in Query report

Feb 12 at 12:42 PM


avatar image
Former Member

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Raymond Giuseppi
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'.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

wow works great thank you so much.