CO Report Custom development ALV report

Activity Type Plan vs Actual Rate and Under/Over-Absorption Report

Short answer: A custom ALV report that compares the plan rate per cost center and activity type with the actual rate derived from actual costs, and shows the under- or over-absorption between the value allocated at actual quantity × plan rate and the cost actually incurred.

Estimated effort
M · 4–6 working days
System
ECC and S/4HANA
Tables
8
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

KSBT shows only plan rates and does not compare them with actual costs. S_ALR_87013611 gives the cost center's plan and actual costs, but does not calculate the value allocated at actual quantity × plan rate or the actual rate per activity type. Under- or over-absorption is therefore usually worked out in Excel before the actual price calculation.

Who uses it? Production controllers, cost accountants and CO teams responsible for rate planning.

Closest standard alternatives

  • KSBT Cost Centers: Activity Prices. Shows plan rates; does not compare them with actual costs.
  • S_ALR_87013611 Cost Centers: Actual/Plan/Variance. Gives the cost center's plan and actual costs; does not calculate the absorption difference per activity type.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
COSTCO Object: Price TotalsPlan and actual activity rates (driving table)—ECC + S/4
COSLCO Object: Activity Type TotalsPlan and actual activity quantitiesCOSL-OBJNR = COST-OBJNR AND COSL-GJAHR = COST-GJAHRECC + S/4
COSPCO Object: Cost Totals for External PostingsPrimary actual costs of the cost centerCOSP-OBJNR = masraf yeri nesne numarasıECC + S/4
COSSCO Object: Cost Totals for Internal PostingsSecondary actual costs received by the cost centerCOSS-OBJNR = masraf yeri nesne numarasıECC + S/4
CSKSCost Center Master RecordCost center masterCSKS-KOKRS = P_KOKRSECC + S/4
CSKTCost Center TextsCost center descriptionCSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTLECC + S/4
CSLAActivity Type Master DataActivity type and activity unitCSLA-KOKRS = CSKS-KOKRSECC + S/4
TKA01Controlling AreasControlling area currencyTKA01-KOKRS = CSKS-KOKRSECC + S/4

S/4HANA notes

  • COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.
  • COSS → ACDOCA: In S/4HANA COSS is a view, not a table; internal actual postings are read from ACDOCA.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_KOKRSControlling areaSingle valueCSKS-KOKRSYes1000
S_KOSTLCost centerRange / multipleCSKS-KOSTLNo4200–4299
S_LSTARActivity typeRange / multipleCSLA-LSTARNoMAK01
P_GJAHRFiscal yearSingle valueCOST-GJAHRYes2026
P_PERFRFrom periodSingle value—Yes1
P_PERTOTo periodSingle value—Yes10
P_VERSNPlan versionSingle valueCOST-VERSNNo0
P_TOLRate deviation tolerance (%)Single value—No5

Output columns

#ColumnSource
1Cost centerCSKS-KOSTL
2DescriptionCSKT-KTEXT
3Activity typeCSLA-LSTAR
4UnitCSLA-LEINH
5Plan quantityCalculated Sum of COSL LST001…LST016, value type 01
6Actual quantityCalculated Sum of COSL LST001…LST016, value type 04
7Plan rateCalculated COST TKG total rate / price unit, value type 01
8Actual costCalculated Actual debits of the cost center in COSP + COSS (activity credits excluded)
9Allocated valueCalculated Actual quantity × plan rate
10Under(+) / over(−) absorptionCalculated Actual cost − allocated value
11Actual rateCalculated Actual cost / actual quantity
12Deviation (%)Calculated (Actual rate − plan rate) / plan rate × 100
13CurrencyTKA01-WAERS

Sample output

Cost centerDescriptionActivity typeUnitPlan quantityActual quantityPlan rateActual costAllocated valueUnder(+) / over(−) absorptionActual rateDeviation (%)Currency
4210Injection line 1MAK01H4,2003,8608503,412,0003,281,000131,000883.944TRY
4220Assembly lineISC01H6,4006,7204202,688,0002,822,400-134,400400-4.80TRY
4230Paint shopMAK02H1,8001,2501,1001,905,0001,375,000530,0001,52438.50TRY
A view built with fictional sample data; not real system data.

How does the report work?

  1. Cost centers of the controlling area are read from CSKS and CSKT, and activity types and their units from CSLA; the cost center / activity type object number is built.
  2. Plan rate: value type 01 in COST for P_VERSN; the total rate (TKG) of the periods is divided by the price unit. If the actual price calculation has run, the value type 04 rate is read as well.
  3. Quantities: plan (01) and actual (04) activity quantities in COSL are summed for P_PERFR–P_PERTO.
  4. Actual cost: the cost center’s actual (04) debits in COSP and COSS, excluding the credits from activity output.
  5. Allocated value = actual quantity × plan rate. Under/over-absorption = actual cost − allocated value. Actual rate = actual cost / actual quantity; the deviation % is compared with P_TOL.

Performance notes

COST, COSL, COSP and COSS are totals tables and read quickly with an object number list. For large controlling areas, selecting by cost center group or plant-related cost centers is recommended.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The actual cost drills down to KSB1 and the rate to KSBT.
  • Export to Excel
  • Runs as a background job
  • Send the result by email

Authorization objects

  • K_CSKSDisplay authorization by cost center
  • K_CCAGeneral cost center accounting authorization

Frequently asked questions

Can the report be used before the actual price calculation?

Yes, that is its main purpose. The actual rate is calculated in the report from actual cost and quantity; once the actual price calculation has run, the system's rate is shown in an extra column as well.

Can fixed and variable rates be shown separately?

Yes. By reading the fixed rate portion in COST, the plan rate can be split into fixed and variable, so the deviation from capacity utilization becomes visible separately.

Does it work on S/4HANA?

Yes. COST and COSL are still used on S/4HANA; COSP and COSS are read as compatibility views. If the new planning is used, plan quantities and rates are checked during installation.

Packages that include this solution

CO Package Custom

Cost Center Planning and Controlling Pack

A three-solution pack that covers the cost center planning cycle from start to end: plan upload from Excel, plan vs actual vs commitment comparison …

3 components · v1.0

Related reports

CO Report Custom ALV report

Cost Center Plan vs Actual with Commitments Report

A custom ALV report that shows plan, actual and open purchasing commitments per cost center and cost element on one row, and calculates the remaining …

COSP · COSS · CSKS · CSKT

Let us build this report for your system

Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.

Related report: Activity Type Plan vs Actual Rate and Under/Over-Absorption Report