Actual Cost calculation for internal activities

[Makal]

Hi

Here is a scenario. There is no HR module (Not interested in mini-HR & CATS).

Using only work center, can system calculate actual cost on confirmation of activity & post it?

If yes, please explain it. It'll be great if you can suggest customization steps too.

Thanks

[Makal · Accepted solution]

I have made all setting in Work center. In KP26 the rate for the activity type is specified. I'm giving planned hours in internal activity & I have assigned this work center to my activity.

But System is not calculating plan costs (I went to CJ30 for budget allocation, I'm not finding any cost related to internal activity).

Setting i made in work center:

=====================

Basic data tab: work center, person responsible, location & usage

Capacities tab: capacity category

Scheduling tab: capacity category, Formula (SAP004)

Costing tab: start date, end date, controlling area, cost center, Activity type, formula (SAP008)

-

---

Can anybody through some light on this topic?

Thanks

[Former Member · Accepted solution]

Hi Amaresh,

Can you tell us what is the error message?

And also please try the following,

1. In costing tab of workcenter, below the activity overview table, you can see a field for Activity type internal processing. There again you type the activity type and input SAP008 formula in the adjacent field also. If you are using multiple activity types, then type only SAP008 in that adjacent field.

2. Check if the activity type unit maintained in the costing tab of workcenter and in Tcode KL01 are the same.

3. Also, in capacities tab of workcenter check if you have maintained formula SAP008.

Regards,

Kabir

Edited by: Kabir on Mar 14, 2009 8:35 AM

[Makal · Accepted solution]

All are set properly Kabir.

I'm not getting any error messege.

When I go to CJ30 (for budgeting), I don't see the costs for the internal activities. All intenral activities have been assigned work center, with correct activity type & price. Work hours has been mentioned in the activity in hours. But I'm not getting any planned costs (I checked CJ30 & in CJ41).

Any idea why? Am I missing anything?

Thanks

[former_member203108 · Accepted solution]

Do you get planned cost for internal activities in reports? or is it only in CJ30 that u dont get planned cost of internal activities?

If you dont get planned cost for internal activities in report also then u should check order value update setting whether network is included in updating plan cost of WBSE or not..

[Makal · Accepted solution]

I checked CN41N,

There also it's not showing planned costs.

[prabu_kaliappan · Accepted solution]

Hi Amaresh,

For planned cost calculation, you have to allow the network to determine the cost.

1. Define Costing Variant.

2. Assign them into network types

3. Parameters for network type (Set as determine planned cost)

4. Assign these network type into network profile

5. Assign the network profile into project profile.

6. Attach the workcenter in internal activities.

System will calculate the planned cost.

Hope this will help you.

Regards

Prabu

[Makal · Accepted solution]

Hi Prabhu

I already have costing variant.

Following are my settings for costing variant:

Control Tab : Costing type: Unit cost est. for proj.

Valuation variant: Network: Planned for PS

Update tab : Itemization not selected

Misc. tab : Cost Elements for Unit Costing: Allowed

And I have already assigned this costing variant in planning profile & this n/w profile is assigned in project profile

Work center is already assigned in internal activity. I have also defined the work hours in activity.

[atul_rajmane · Accepted solution]

Dear Amrish,

Just Check your CstgVariantPlan and CstgVariantActual in OPUV.

Check same settings in Maintain plan costing variants for network types in Cost > Planned Cost > Automatic Costing in Networks/Activities > Costing.

Try used standard setting of PS02 (Network: Planned) and PS03 (Network: Actual) settings in your Network Type Parameters.

Thanks and Regards,

Atul R. Rajmane

[Makal · Accepted solution]

I have used standards only Atul.

Is there anything to do with OKKT settings? What settings I have to use here? I'm using standard PS01

[virendra_pal · Accepted solution]

check in txn OPSV if network type is assigned ticked

if not tick and run CJEN to rebuild database

also for overheads you can use costing sheet functionality

[former_member203108 · Accepted solution]

Dear Amaresh,

The costing variant PS01 which is assigned in your project profile is for Detailed planning and unit costing not for network costing. For network costing your have to assign costing variant separately which can be done in OPUV. Go to control tab of network header and see whether costing variant is assigned to the network or not. if not, assign in OPUV.

[Former Member · Accepted solution]

Please check the valid date of activity type rate (KP26).

if the valid date is from 2009.

but the activity date is from 2008.

there is no planned cost to be calculated.

another way to check the planned cost of activities.

Using CJ20N, click the network header, and go edit-cost-cost itemalization

you can see the planned working hours and the planned cost.

Judy

[Makal · Accepted solution]

I checked it in the network header, in control tab.

Following are the details:

CstgVariantPlan: PS02

CstgVariantActl: PS03

It seems it's fine, but still can't see planned cost.

Ahmed, you mentioned "For network costing your have to assign costing variant separately which can be done in OPUV". Can you please explain bit more on this.

Thanks

[Makal · Accepted solution]

Virendra

it is ticked in OPSV

[former_member203108 · Accepted solution]

Amaresh, If u see the costing variant PS02 and PS03 in network overview then it means costing variants are already assigned in OPUV . you can check order value update in OPSV for network(order cat 20).

Also in project builder select the activity and press ctrlF10, it will calculate cost and press ctrlF11 it will show the cost report for the activity, u can check whether cost is calculated or not.

[Makal · Accepted solution]

Thank you all.

Everything was perfect, but even then the plan costs were not getting calculated. The reason being very simple, I forgot to specify the activity type in Activity. I had pressumption that, if we define activity type in Work center, that's enough. But it seems we have to define the activity type in both work center as well as in the activity.

One final question friends, please cooperate

I checked Ctrl+F11. It shows following four rows

Cost Elem.	Cost Element (text)	Origin	Total plan costs
620200	overhead: Production	xxx	05
620300	Overhead: Administration	xxx	06
620400	Overhead: Sales and Distribution	xxx	12
640100	Internal acty alloc, production hours	yyy/SKL	25

4th one is because of the activity type I have assigned both in Activity & work center. But from where the remaining 3 costs are coming? Any idea?

[former_member203108 · Accepted solution]

It comes from Costing sheet and overhead key assigned to the activity

[virendra_pal · Accepted solution]

these are the overheads

coming from costing variant which also holds the costing sheet - this is where the overheads are allocated

for plan the overheads always appear immendiately

for actual you need to run overhead allocation transaction at month end CJ44/CJ45

[Makal · Accepted solution]

Dear Friends

Thank you very much for your valuable suggestions & time.