We are maintaining a production cost centers named "AB" "CD" "EF" "GH" in the costing tab of Resource (Tcode: CRC3).
For one resource we can maintain only one cost center.
Total Resources are 20.
So I have maintained AB cost center for 5 Resources(1-5), CD cost center for 5 Resources(6-10), EF cost center for 5 Resources(11-15) and GH cost center for 5 Resources(16-20).
The purpose of this is to capture the confirmaed quantity against process order.
In detail, I need to capture the confirmed quantity of a process order in those cost centers.
If Process order A is confired with 100 quantity, as it is using the resource 1 the confirmed quantity should store in cost center "AB"
In the similar ways other cost centers also capture some confirmed quantities.
Cost center "AB" is having some cost with other transactions.
I need a report that the cost should be divided with the confirmed quantity resulting per unit cost.
Please suggest me is there any standard reports will solve my problem.
Other wise suggest me the table and field names for devoloping acutom report.
I will award good points for the best answer.