Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Saps -
With those selection criteria, I would start with table VAKPA, and from there go to the sales order tables. From the sales order tables I would go through the doc flow table to get to the invoice tables. For the stock, you're going to have to decide between actual stock without regard to availability (reading the stock tables) and available stock considering earlier requirements (calling an availability function and interpreting the results).
Dave
| | | ---------------Original Message---------------
From: saps
Sent: Saturday, December 10, 2011 11:34 AM
Subject: Make To Order Scenario - Enhancement of SD Report
I am working in MTO scenario. I have a requirement for a report. It is as follows.
"Sales order no.", "Item No.", "material code", "order quantity", "invoiced quantity", "balance quantity", "Stock against the balance quantity", "shipping type".
The selection criteria will be the customer no. (KUNNR - Sold to party), Sales order No. & Sales Order Date.
The report should take into account the updates of the schedule lines of the sales order so that when the distributor runs this report he will get an idea of the current day's work.
Is there any standard SAP SD report for this requirement? If not then which table should I refer to create a "Z" report. I am not finding the table "MSEG" that useful. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Dave Thornburgh
SAP Development Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
