materials issued and received on production order report
I'm FI/CO consultant but it is required from me to find out a report for the Quantities and Amounts for materials issues and received on total production orders for certain type of orders.
I have searched the forums and I found the MB51 but it returns the materials on the level of Plant or Storage Location but not on the level of Production Orders br3eaked down by order types.
with each phase the orders receives some material and gives out a product WIP which will be taken to another phase with more materials to be added to it to make new WIP product and so on till we reach last phase and make the Finished Product.
we have 3 phases of production to make a product X:
Phase A takes materials (3K 4L 7M) per order then multiplied by 10 orders.
Phase B takes materials (2L 5N 4O 1H) per order then multiplied by 7 orders.
Phase C takes materials (6D 8F 9G) per order then multiplied by 12 orders.
So we need to know all materials in quantity and value used for each phase
Can someone kindly help how to find out such standard report if there is something like that or we need to go through ABAP?
Thanks in advance;