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

Report MRP data - Fixed Vendor

antonio_bruno
Participant

‎2011 Jun 22 9:01 AM

0 Likes
443

Hi All,

I am trying to build a report by query, to display MRP data and related fixed vendor (if available).

I tried joining the tables MARC, MAKT, EORD and LFA1, but did not get the output as desired. The report shows only the material with a source list.

Please, could you help me to display all the records (with or without fixed vendor)? How can i use a outer join?

Thanks in andvance.

Antonio

Edited by: Antonio Bruno on Jun 22, 2011 10:40 AM

Hi All,

I am trying to build a report by query, to display MRP data and related fixed vendor (if available).

I tried joining the tables MARC, MAKT, EORD and LFA1, but did not get the output as desired. The report shows only the material with a source list.

Please, could you help me to display all the records (with or without fixed vendor)? How can i use a outer join?

Thanks in andvance.

Antonio

Edited by: Antonio Bruno on Jun 22, 2011 10:40 AM

Reply
1 REPLY 1
Read only

antonio_bruno
Participant

‎2011 Nov 02 12:35 PM

0 Likes
377

Can use the inner join directly in the infoset by add a table.