cancel
Showing results for 
Search instead for 
Did you mean: 

Actual Cost calculation for internal activities

Makal
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Makal
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

I checked CN41N,

There also it's not showing planned costs.

prabu_kaliappan
Participant
0 Kudos

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
Active Contributor
0 Kudos

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
Participant
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Virendra

it is ticked in OPSV

former_member203108
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

virendra_pal
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Dear Friends

Thank you very much for your valuable suggestions & time.

Answers (2)

Answers (2)

Former Member
0 Kudos

in cj20n costplanning my total/planned cost is getting updated when i update days else its not getting updated. i need the standard program which i can enhance as to update my planning cost even if days is not updated. else suggest me as how to resolve this issue.

former_member203108
Active Contributor
0 Kudos

Roshni, you can only reply to the old thread if it is related to your problem, otherwise you have to create a new one. Dont reply to a thread which is not related your issue.

virendra_pal
Active Contributor
0 Kudos

set up rates for activity type and cost centre in KP26

enter the activity type and cost centre in the work centre master data

do confirmation of network activity CN25

no need of HR at all or even CATS

Makal
Active Contributor
0 Kudos

Thanks Virendra.

In OP42, what are the data that I need to maintain?

I guess only Basic data, Default values, Scheduling, costing tabs I'll have to use here. Coudld you please elaborate more on this?

Thanks

virendra_pal
Active Contributor
0 Kudos

i do not usually maintain a default work centre using OP42

I would just create them as master data with basic data, capacities, scheduling, costing tabs

note capacity and scheduling are required only if you are using these functionlaities

for getting costs i think just the costing tab and basic data tab should be sufficient

Makal
Active Contributor
0 Kudos

Thank you so much.

I use scheduling, but not capacity.

So I can just use Basic data, scheduling & costing

virendra_pal
Active Contributor
0 Kudos

for scheduling use formula SAP004

for costing use formula SAP008

Makal
Active Contributor
0 Kudos

Dear Virendra

Thanks for your tips/hints/suggestions.

They are really helpful.

Makal
Active Contributor
0 Kudos

There is one question here Virendra.

Say I want to capture the costs of Project manager, Site engineer & labour (hourly basis). How can it be acheived?

Is it by creating different activity types in CO side?

Can I capture all the three types costs mentioned above in one single work center? How?

And also, how do over head costs be covered?

former_member183901
Active Participant
0 Kudos

Amaresh,

You create different activity types where in you can quote different rate per hour in KP26 to the relevant cost center.

Ex: You can have activity type ZXYZA-For Project Manager,ZXYZB for Team Lead like that.

Bekele

Makal
Active Contributor
0 Kudos

Thanks Bekele

But how do overheads be calculated?

Can we use work center for external activity & services also (Only for planning costs) ?

Thanks