MCB): Workaround for Massive MD04 – Stock and Requirement List
As a SCM consultant I have received several times the same request: Planners want to have a t-code to extract MD04 massively.
Luckily this can be done “some times” using SAP functionality of Long Term Planning. I said “some times” because this report does not show reasonable results when in the plant we have Subcontracting.
Before using and sharing this report, the consultant should make a validation and check if the report shows accurate results in the corresponding plant.
2- MCB): Workaround for Massive MD04
The report mentioned in the paragraph above is MCB).
Here you can see how to use this report and extract the results to excel.
2.1- This is the selection screen
Enter the following fields and Execute:
- Planning Scenario: 000 (this report was defined for Long Term Planning. By using planning scenario 000, you are using the actual data that you have in planning)
- Period to analyze
You can run the report by plant, without entering the materials., but in this case the report could take some time.:
2.2- Switch drilldown:
2.3- Change the characteristic display: get material code:
2.4- Modify the layout and add more columns:
2.5- Open the Keyfigures in monthly buckets:
You will note that you have different columns. Unfortunately you can only open in monthly buckets one column each time:
2.6- Extract the report to an excel file:
I hope you can find this document useful.
Remember that if you have subcontracted requirements or if you have the planning data in an external system (e.g.: APO without being Ciffed), this could not be an accurate report.
Thanks and Regards,