Report to display requirements/open orders for materials
Hello SAP experts,
I have a requirement from the business - they need a report which they can execute based on the MRP Type and get all the requirements for that material, open production orders, work center and the date of requirement. Currently they use - MD04 but the issues with that is - they can't run it for multiple materials and secondly they need to double click each item to find the production order number for which the requirement is.
I have tried the collective transaction (similar to MD04) but that doesn't help. Therefore, is there any other SAP transaction which can be used for this or we need to go for a custom report/txn. only ?
Thank you in advance.