MCB): Workaround for Massive MD04 – Stock and Requirement List

1- Introduction:

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)
• Plant
• 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,

Mariano Cabalen