Skip to Content
Author's profile photo Former Member

How to configure Mixed Costing

 Mixed costing is very useful in some cases. For example, it’s the only way to release a standard cost estimate for each procurement alternative that is associated with a valuation type. 

Recently I got some requests to explain in details how the mixed costing works. I hope this blog can help to explain.
The prerequisite for the mixed costing is as below:
 – A quantity structure type is configured in the customizing
 – This quantity structure type is associated to a costing version in the Customizing.
 – The Procurement alternatives for the material have bee defined
 – The mixing ratios for the procurement alternatives are defined based on the quantity structure type
 – The material is costed with the above-defined costing version.
1. Define the quantity structure type
The path to configure mixed costing is as below (ECC 6.0):
a
The tcode for quantity structure type is OMXA. 
b
Now I created the qty structure type “MIX”. 
“Time Dependency” – This controls the time period in which the quantity structure will be used. It can be time indepenent, based on fiscal year, or based on each period.
“Percent validation” – Tick this indicator if you want to ensure that the sum of the existing mixing ratios for a material and quantity structure type totals 100%.
 
2. Associate the quantity structure type to a costing version
The path is right after that for the quantity structure type.
c
For the attached screenshot, the mixed costing will be called with the qty structure type MIX, when costing version = 1 & costing type = 19, or when costing version = 99 & costing type = 01 & valuation variant = 001. The system will not do mixed costing for the other combinations of costing version & costing type & valuation variant.
In this transaction, you can also define:
 – Variant for transfer price determination 
 – Exchange rate type for currency translation 
 
The configuration for the costing version can also be checked via costing variant configuration(tcode OKKN). It’s a more convenient way as the configuration is based on the combination.
d
d
In the Assignment tab, click the costing version button.
e
You’ll see for the costing variant PPC1 (costing type 01, valuation variant 001), costing version 99 is assigned the qty structure type “MIX”.
 
3. Define procurement alternatives
The tcode is CK91N. Here we need to create the procurement alt per material/plant.
I created two proc alternatives for different versions. It’s also possible to create alternatives for different valuation type/process cateogry/etc…
f
For process category
– Production
you can choose to create procurement alternatives for in-house production either with production versions or by using the BOM and routing.
Purchase order
You can then enter a vendor and the relevant purchasing org in the initial screen. 
In the cost estimate for a procurement alternative with reference to a vendor, strategy “L” (price from purchasing info record) is always automatically set to highest priority strategy.  If you want to have a different logic, you may consider note 636967 and 319832.
You can also create an unspecified procurement alternative. To do this, do not enter a vendor or a purchasing organization. The material is then valuated with the prices in the material master and not using the purchasing info record.
– Subcontracting
In this case the system will require you to enter the information on the BOM, vendor and purchasing org. 
– Stock transfer
You’ll be required to enter the source plant
 
4. Define Mixing Ratios for the procurement alternatives
 The tcode is ck94
g
Here we can create the mixing ratios for the material per qty structure type.
Since our Qty Structure type “MIX” is based on fiscal year, here we only need to enter the “fiscal year” information.
If it’s based on period, we need to create the mixing ratios for each period.
h
Here all the proc alt created via CK91N will be displayed. And you can assign the mixing radio to them as you want.
– MR indicator
Set this indicator if you want to include a procurement alternative in mixed costing. It will ensure this procurement alt will be included in a mixed costing (even with a weighting of 0).
– Mixing Ratio
This is the most import figure in this transaction. You can enter equivalence numbers or percentages. But if “Percent validation” is ticked for the qty structure type,  the sum of the existing mixing ratios must totals 100%.
 
5. Cost the material with the above-defined costing version. 
Create a cost estimate for material YS-FRAME-01/plant IWS0 with costing variant PPC1 and costing version 99. The mixed costing is successfully carried out, as expected.
i
 
Please note, the costing lot size of mixed costing is different with the normal costing.
For more information please refer to note 402440, which provided very detailed explanation of the logic together with some examples. 

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Hi Expert,

      When i will post MB1B, system occur a error message F5800 of Inconsistent currency information as below:

      Inconsistent currency information

      Message no. F5800

      Diagnosis

      The currency information for the financial accounting component must be
      transferred fully for each currency type.

      If, for example, the sending application sends corporate group currency
      data to Accounting, this currency data must be transferred for every
      company code line item.

      An error has occurred for line item '0000000002' of the financial
      accounting document (company code '5000') with currency type '12'
      (currency key 'CNY'). This could be for one of three reasons:

      Line item '0000000002' does not have any currency data for currency type
      '12', although at least one other line item has currency data for
      currency type '12'.
      Line item '0000000002' contains currency data for currency type '12',
      although at least one other line item contain no currency data for
      currency type '12'.

      Line item '0000000002' has no currency data for currency type '12',
      although the currency type '12' corresponds to the local currency (
      currency type '10').

      System Response

      Data processing within Financial Accounting can only take place with
      consistent currency information.

      Procedure

      The calling application probably contains a system error. Contact the
      calling application to locate the error.

      PS: I have already activated transfer price with material ledger.

      Could you please help to solve it? tks.

      Author's profile photo Former Member
      Former Member

      One of the best document on Mixed Costing !

      Regards,

      Sharvari Joshi.

      Author's profile photo KAPIL MEHTA
      KAPIL MEHTA

      Hi

      I read your article and it is very informative. I just have one query - Can you please suggest standard SAP report which gives standard cost breakup along with procurement alternative level information, if product involved Mixed costing.

      I have checked S_ALR_87099930 & S_P99_41000111, but they do not show name/description/identification of Procurement alternative.

      Regards

      Kapil

       

      Author's profile photo Former Member
      Former Member

      Hi Expert,

      Can this set up be apply for one material which have been set up two difference BOM and two difference production Line?

       

      thank you,

      TZM

      Author's profile photo Tapan Rana
      Tapan Rana

      Yes