Actual rates (KBK6) is not getting picked up for CPTA (template allocation)

[Former Member]

Hello Experts,

I am using template allocation for the purpose of overhead calculation. I maintained rate in KP26. It is getting pulled up when I ran standard cost estimate. This is correct

Now I want to run CPTA (ie. charging overhead at month end) using actual rate. Hence I maintained actual rate in Tcode KBK6. Actual rate is little bit varying with KP26 rates. Hence I want to run CPTA with actual rate.

When I executed CPTA, I saw that system is picking up KP26 rate and not KBK6 rate. Please help me. How system will pick up KBK6 rate for CPTA.

--Meena.

[Former Member · Accepted solution]

Hi Meena,

If you have any errors in CPTA transaction it will not update the actual OH values in the order. Check for the error log in CPTA output report.

Br, Srinivas Salpala

[Former Member · Accepted solution]

Hi Experts,

In my case, overhead is getting calculated in CPTA.

But its picking up KP26 rate and not KBK6 rate. I want SAP to capture KBK6 rate in CPTA.

--

Meena

[Former Member · Accepted solution]

Hi Meena,

Is the cost centre you allocate from credited with actual activity price?

What's the object you allocate activity to? Is it a production order?

In that case you need to run revaluation.

Regards,

Szymon

[Former Member · Accepted solution]

Yes,

Is the cost centre you allocate from credited with actual activity price? - Yes

What's the object you allocate activity to? Is it a production order? - Yes

In that case you need to run revaluation. - Revaluation why need to run?

[Former Member · Accepted solution]

Hi,

Because that's the system logic.

All allocations between cost centres and orders during period are at plan price.

At month end you need to run revaluation if you want to get "actual" values on orders.

Please execute  txn. MFN1 and let me know if it helped.'

Regards,

Szymon

[Former Member · Accepted solution]

Hi Szymon,

Thnx for your inputs.

But MFN1 is not showing results. I have tried KSII before that. But still results are not posting.

Since I already mentioned KBK6,  system should pick up rates in KSII and MFN1.

Please help

[Former Member · Accepted solution]

Hi Meena,

The correct sequence of closing should be:
1. Template Allocation - CPTA

This will post activity allocation from CC to your production order at PLAN price.

2. Calculate Actual Activity Prices - KSII

This will calculate actual price based on costs posted to CC and activities allocated (try to avoid KBK6 in your testing but rather calculate actual price properly). It will also credit CC but will NOT debit the order.

3. Revaluate your production order - MFN1

This will debit the order with the difference between plan and actual activity price.

Please kindly read SAP Note 156563 - Settlement after activity allocation/revaluation.

It explains revaluation logic in detail.

If in your case CPTA generates activity allocation between CC and order (valued at plan price) and KSII calculates new actual activity price, MFN1 has to update the order.

Regards,

Szymon

[Former Member · Accepted solution]

Hi Szymon,

I did MFN1 after maintaining KBK6. System calculated difference and posted in variance. My purpose is solved.

Now I need to work on populating KBK6 automatically and I will get back to you.

Thnx

Meena

[ajaycwa1981 · Accepted solution]

Hi Meena

The steps to auto calculate activity price are

1. KSU5 / KSV5 - Perform allocations, if any

2. Do Splitting - KSS2 (for this, you will need splitting structure. T code OKES and OKEW)

3. Calculate activity price in KSII

Br. Ajay M

[Former Member · Accepted solution]

Hi Meena,

I'm glad your problem has been solved.

Cheers,

Szymon

[rajneesh_saxena]

Dear Meena

Please check that in your order costing sheet and OH key is assigned or not.

Regards

Rajneesh Saxena

[Former Member]

Hi Experts,

In my case, overhead is getting calculated in CPTA.

But its picking up KP26 rate and not KBK6 rate. I want SAP to capture KBK6 rate in CPTA.

--

Meena

[rajneesh_saxena]

Did you check your order as I suggested?

Rajneesh

[rajneesh_saxena]

Dear Meena

Also check at CPT2 that Actual activation is done or not.

Regards

Rajneesh Saxena

[Former Member]

Hi Rajneesh,

Please find screenshot of "actual activation" I hope you are asking for the same.

Screenshot is for template A022 (for environment 009)

--Meena