Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

No data in Query report

Go to solution
Former Member

‎2018 Feb 12 12:42 PM

0 Likes
1,574

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

1 ACCEPTED SOLUTION
Read only

Go to solution
RaymondGiuseppi
Active Contributor

‎2018 Feb 12 1:14 PM

1,351

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

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

Reply
2 REPLIES 2
Read only

Go to solution
RaymondGiuseppi
Active Contributor

‎2018 Feb 12 1:14 PM

1,352

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

Read only

Go to solution
Former Member
In response to RaymondGiuseppi

‎2018 Feb 12 3:12 PM

0 Likes
1,351

wow works great thank you so much.