CK13N not matching with value calculated manually.

[caram]

Hi Experts,

Please go through to the below scenario and help.

Cost estimate details:

Costed on 15.01.2015

Marked : 20.01.2015

Released ; 20.01.2015

UOM : KM (10 RL=35KM)

Valuation type  : Legal and group

Currency : GBP (Controlling currency) and KRW (Local Currency)

PIR details :

On 15.01.2015, PIR was initially created with currency MYR with no condition. On 20.01.2015 PIR updated with condition and currency USD.

UOM – RL

Material master Details :

UOM : RL

Currency – KRW (local currency)

Controlling details :

Exchange rate type: P

Currency – GBP

OKYD and OKEQN is maintained with exchange rate type P

Questions: The value calculated by system is not matching with the manual calculation done with exchange rate type P. Any idea what exchange rate type system using to do the valuation? Why the values are different. Also checked with M rate but still system calculated values are not reconciled.

Appreciate your inputs

[caram · Accepted solution]

Issue referred to SAP

[former_member182339]

Sitaram,

In CO we have “valuation” concept. This valuation concept have 3 views…Legal, Group, Profit Center View in CO Same time we do have different currency types. For e.g. Group currency, Company code currency.The combination of currency and valuation view ‑‑ for example, group currency and profit center view ‑‑ is referred to as a valuation approach. You need to assign the currency and valuation profile to a controlling area and then activate the profile. This ensures that the data is updated consistently in all the affected applications.

When you execute costing it usually uses exchange rate type P to calculates the cost.

let me know if you need more details.

Thank You

Hrusikesh

[caram]

Hi Hrusikesh,

I am aware costing run pickups P rate. However the value computed by system is not tylling back with the value calculated manually using P rate. We have other materials where there is no difference with respect to manual and system calculated value.

Please let me know if you need any further information.

Thanks,

Sitaram

[kamalkumar_biswas2]

Hi

You are telling this is happening only for this material only?

So...system is placed rightly as per as exchange rate is concerned otherwise other materials also give same result.

Is it coming from components materials?

[caram]

Hi Kamal,

Yes this is happening for a particular material. The only difference is for this material PIR is maintained with UoM RL & currency USD. However costing lot size UoM  KM and currency KRW.

For example

10 RL = 35 KM

PIR condition value : 1 RL = 2 USD

100 RL = 200 USD

Based on quantity conversion 350 KM = 200 USD

P rate : USD to KRW  - 1500 KRW

Costing Lot size - 100 KM

Now Manually calculated cost estimate value : ((200/350)*100)*1500= 85714 KRW

But system computed value substantially less then the above value.

Please let me know if you need any further information

[kamalkumar_biswas2]

Hi

One suggestion.. increase costing lot size to 1000 or 10000

[caram]

How this would help.. could you please elaborate?

[kamalkumar_biswas2]

Hi

Due to lower costing lot size it happens to per unit cost to some extend incorrect as lower lot size dimension. Increase of lot size otherwise not effect any thing.

you can test

[former_member198650]

Hi Sitaram,

Have you check the exchange rate in OB08 for 'P'?

Regards,

Mukthar

[caram]

Hi Mukthar,

Yes, manual values being calculated based on P rate in OB08.

Thanks,

Sitaram