Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Jan 23 at 10:12 AM Although SAP will allow you to do the joins that way, it doesn't always work. Since MSEG to AUFK is an outer join, and it's the primary way into the other tables, try making them all outer joins. That may solve the issue. If it doesn't, come back and we'll look again.
Lou
| | | ---------------Original Message---------------
From: Kevin Vinson
Sent: Monday, January 23, 2012 9:06 AM
Subject: SQ01 Report - Material movements
Hi
I am trying to create a report in SQ01/02/03 and am not sure if I am doing something wrong or it is not possible. For a list of material documents I wish to see additional work order information from tables AUFK, AFIH, ILOA & CRHD.
When I link the tables as follows I can see the required work order information but any material documents assigned to WBS elements or cost centres are not displayed. I need to see all documents in the selection set
MSEG => AUFK (Outer join)
AUFK => AFIH (Inner join)
AFIH => ILOA (Inner join)
ILOA => CRHD (Inner join)
Can anyone please provide advice, your help would be very much appreciated. |
| Reply to this email to post your response. __.____._ |  _.____.__ |
