Using Costing Keys for CO-PA Reporting (Part 3)

In case you want your cost estimate to be used to value only certain characteristics in CO-PA, then you can use transaction KEPC to assign costing keys to those characteristics. For example, if you wanted certain Billing Document Types to be valued with a separate costing key, you can assign the costing key to the specific Billing Type characteristic. Unlike the two steps mentioned in the previous blog (assigning costing keys to products and assigning costing keys to material types), you can control how the assignment table will defined when assigning costing keys to characteristics. When you get into this transaction, click on the “Display <-> Change” button and click on the “Create Step” button. Then you have the choice of using an Assignment Rule, Table Lookup or Enhancement (similar to when you are setting up a derivation rule). Select the “Assignment Rule” option and press the “Enter” key. In the 4th row of the “Source fields” section, enter the Billing Type characteristic “COPA-FKART” (I am using the example mentioned above to demonstrate this scenario, however you can use whatever characteristic(s) suits your business objective). Now you can click on the “Maintain Rule Values” button to get the table below:

Column Explanation Example
PV This is the “Point of Valuation” and refers to the trigger-point when CO-PA is updated  with the costing key valuation 01 – Real Time Valuation
RecT. This is the “Record Type” and refers to the business transaction that updates CO-PA F – Billing Document
Plan ver. This is the “Plan Version” and is only used if you are updating CO-PA with Plan data 0 – Plan/Actual version
Billing Type This is the Material Type that you want to be updated with the costing key valuation IV – Intercompany Billing
First Costing Key (CO-PA) Enter the 1st costing key that you want to use to value the products with that characteristic 004 –  Transfer Price

 

Note that assigning costing keys to products overrides the assignment to material types, which in turn overrides the assignment to characteristics.

 

Finally you can assign the Point of Valuation (which has been configured above) to the relevant cost components and value fields using transaction KE4R. Go to the menu path enter the Operating Concern and cost component structure (configured in OKTZ). When you get to the configuration table, you will see the following columns which are explained below:

Column Explanation Example
PV This is the “Point of Valuation” and refers to the trigger-point when CO-PA is updated  with the costing key valuation 01 – Real Time Valuation
CCo The cost component that was configured in the cost component structure 10 – Raw Materials
F/V This refers to “Fixed/Variable”. You can assign the cost component to a fixed, variable or total value field 3 – Sum of fixed and variable amounts
Fld name 1 This is the value field assigned to the first costing key VV100 – Raw Materials Standard
Fld name 2 This is the value field assigned to the second costing key VV200 – Raw Materials Future
Fld name 3 This is the value field assigned to the third costing key VV300 – Raw Materials Actual
Fld name 4 This is the value field assigned to the fourth costing key (only possible when you assign costing keys to characteristics) VV400 – Raw Materials Transfer Price 1
Fld name 5 This is the value field assigned to the fifth costing key (only possible when you assign costing keys to characteristics) VV500 – Raw Materials Transfer Price 2
Fld name 6 This is the value field assigned to the sixth costing key (only possible when you assign costing keys to characteristics) VV600 – Raw Materials Transfer Price 3

Comments are closed.