Direct activity Allocation (Activity)
Scenario: Accounting manager wants to know how he can make a cost or price planning for labor hours
in sap for full fiscal year.
He also wants to know how to make actual postings directly for those labor hours with actual prices.
The following tables are updated in sap s/4 Hana finance through activity allocation i.e. COBK, COEP
AND ACDOCA
Step 1. create a secondary cost element –GL account T code Fs00
A secondary cost element is needed to create an activity type master data with cost element category
43(Internal activity allocation)
Secondary cost element controlling module cost only such as assessment, internal activity allocation,
order settlement)
Control data tab:
Create/bank interest:
Step2: Activity type master data for direct activity allocation T code KL01
Units produced
Labour hours/charges
Power
Activity-type allocations combine both quantity flows and value flows
applicable for
cost center
G/L Acct
The activity type group is optional. Group define various Activities into one combined group
Creation of Activity type group T code KLH1
Step3: creation of Activity type/price or planning: T code KP26
isIts necessary to create cost
center for recording oter w,;ise
cost capture not possible
For every cost center it requires standard hierarchy which is associated with profit center for recording
as well as revenue and its costs for internal reporting
Creation of profit center T code KCH5N
Creation of cost center T code OkEON
From the organization data tab:
Now assign that cost center to Activity cost/price-planning allocation
Click on overview Button
We can see planning activity how we have done through this button from the same screen
In this example we have taken that 8000 hrs. would be taken for the whole year as plan activity with
fixed cost price 10 and variable cost is 40
Click on save.
Cost center Actual line items T code KSB1
Reports: cost center Period break down Actual/plan T code S_ALR_87013640
ACTIVITY TYPES: PERIOD BREAK DOWNS T code S_ALR_87013646
Until we post actual cost it will show as a blank once we post it then it will how much actual value is
posted in that.
ACTIVITY TYPES: Schedule/plan T code S_ALR_87013647
Plan activity it was showing that per month 666,7
Step 4: Direct Activity Allocations _Actual price posting T code KBK6
By the above picture we can get to conclude that plan price is just for planning to estimate But in case of
actual price may rise up or down so in this case prices up when compared to plan price
Step 5. Activity Allocation T code KB21N
Here transferring cost from the one cost center to another cost center
Our machinery cost would transfer to labor hrs. cost Actual cost postings will be happened
Click on go to select FI/co Documents open the postings
Now check with the report T code S_ALR_87013646
Here u can absorb that plan quantity per month 666 in that actual utilization quantity is only 600 we
have recorded .
In the same way value also varies T code S_ALR_87013640
Step 6. Reversal of Actual postings T code KB24N
Now check report Before and after
Before T code S_ALR_87013646
After