Skip to Content

Production Order & Sales Order Actual Cost Component Split Report

Dears

We are in MTO scenario with Production Order as cost object.

(a) We run the actual activity price calculation at the period end on the Production Order.

I am looking for a report that showing the actual cost component split order-wise.

Is there a standard report available for this ?

(b) We also have actual costing and & Material Ledger functionality.

How can we get the actual profitability report Sales Order-wise from the COPA ?

The report we have created gives the Sales Revenue and the standard cost split.

This does not tally with the Production Order Actual cost.

If we settle the material ledger every period, would that give the actual cost on the Sales Order already processed and delivered to the customer ?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 21, 2016 at 06:45 AM

    Hi Nikki

    1. After you run KE27, the system will re-valuate your inventory and COGS with the actual values, it means it will post delta posting to COPA as well.

    2. If material ledger in place, every month the prices varainces will allocate to inventory and it will become zero.

    Regards

    Bhaskar

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2016 at 07:10 AM

    Hi Nikki,

    You need to do setting to flow actual cost component split to CO-PA under Masterdata valuation:

    1) Define and Assign Valuation Strategy

    2) Define Access to Actual Costing/Material Ledger

    3) Assign Costing Keys to Material Types

    4) Assign Value Fields (create new value fields to flow actual cost component split to COPA)

    You need to execute t-code KE27 at the month end, to get the actual cost component split.

    Regards

    Bhaskar

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 05:37 AM

    Thank you Bhaskar.

    I shall do the material ledger closing and do the revaluation in COPA using KE27 transaction to get the actual cost.

    But I have doubts regarding:

    1. Since our FG is standard price, will the actual cost updated for all the sold items also ? (Because the stock is not available to update the actual cost, right ? I understand that if there is no stock for a Standard Price material, it will be posted as price difference. Will this happen in the case of Material ledger actual costing also ?

    2. Another doubt is, after the actual cost is updated in the material, what happens to the variance ? Do we need to settle the variance to COPA after the production order settlement ? I am not sure about how the variance will be treated in the Material ledger.

    Best regards

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2016 at 06:44 AM

    Hi Bhaskar

    I created a report in KKO4 for Production order component split display in our case.

    The report is coming fine. But I need to create a transaction code for this report as we do for other report painter reports.

    I cannot give the tcode KKO* to the user. Is it possible without abaper help ?

    Add comment
    10|10000 characters needed characters exceeded