We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] SQ01 Report - Material movements

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from TFEwines on Jan 24 at 4:08 PM
When the joins needed in the report get too complex, resource consuming, or impossible, I have found the best way to solve the issue is to create user defined fields in the infoset with ABAP select statements coded for the fields.

Good luck!

---------------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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2012 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
TFEwines  
Sr. Business Analyst - SAP MM/PP/QM/Workflow
achievement
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language