CO Report Custom development ALV report

Cost Center Plan vs Actual with Commitments Report

Short answer: 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 budget and consumption rate. Rows above the consumption threshold are flagged with a traffic light.

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

Why is the standard not enough?

S_ALR_87013611 shows plan, actual and variance but does not include open purchase requisition and order commitments, so managers see more remaining budget than there really is. Commitments are listed in a separate report and KSB1 shows only actual line items. There is no standard Excel-ready list that deducts actuals and commitments together to give the remaining budget.

Who uses it? Controllers, cost center owners, budgeting teams and finance managers.

Closest standard alternatives

  • S_ALR_87013611 Cost Centers: Actual/Plan/Variance. Shows plan, actual and variance; does not include commitments or remaining budget.
  • KSB1 Cost Centers: Actual Line Items. Lists actual line items; does not compare with plan and commitments.

Tables used

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

TableRoleJoinSystem
COSPCO Object: Cost Totals for External PostingsPrimary cost totals: plan, actual and commitments (driving table)—ECC + S/4
COSSCO Object: Cost Totals for Internal PostingsSecondary cost totals: plan and actual allocationsCOSS-OBJNR = COSP-OBJNR AND COSS-GJAHR = COSP-GJAHRECC + S/4
CSKSCost Center Master RecordCost center master: validity, profit center, categoryOBJNR = 'KS' + CSKS-KOKRS + CSKS-KOSTLECC + S/4
CSKTCost Center TextsCost center descriptionCSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBIECC + 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-KOSTLNo4100–4599
S_KSTARCost elementRange / multipleCOSP-KSTARNo770000–779999
P_GJAHRFiscal yearSingle valueCOSP-GJAHRYes2026
P_PERFRFrom periodSingle value—Yes1
P_PERTOTo periodSingle value—Yes10
P_VERSNPlan versionSingle valueCOSP-VERSNNo0
P_CMMTInclude commitmentsCheckbox—NoX
P_WARNWarning threshold (%)Single value—No85

Output columns

#ColumnSource
1Cost centerCSKS-KOSTL
2DescriptionCSKT-KTEXT
3Profit centerCSKS-PRCTR
4Cost elementCOSP-KSTAR
5PlanCalculated Sum of COSP + COSS WKG001…WKG016, value type 01, P_VERSN
6ActualCalculated COSP + COSS period total, value type 04
7CommitmentCalculated COSP period total, value types 21 and 22
8Actual + commitmentCalculated Actual + commitment
9RemainingCalculated Plan − actual − commitment
10Consumption (%)Calculated (Actual + commitment) / plan × 100
11LightCalculated Consumption < P_WARN green, P_WARN–100 yellow, > 100 red
12CurrencyTKA01-WAERS

Sample output

Cost centerDescriptionProfit centerCost elementPlanActualCommitmentActual + commitmentRemainingConsumption (%)LightCurrency
4100Maintenance workshopPC1100770150480,000352,40061,800414,20065,80086YellowTRY
4100Maintenance workshopPC1100770160120,000131,5000131,500-11,500110RedTRY
4300MarketingPC1200760200900,000512,000144,000656,000244,00073GreenTRY
4500Information technologyPC1900770300360,000290,50052,000342,50017,50095YellowTRY
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 with their validity in the selected period (DATAB/DATBI) and their texts from CSKT in the logon language; the object number (OBJNR) is built from the cost center.
  2. Plan: value type 01 (plan) in COSP and COSS for the selected plan version (VERSN).
  3. Actual: value type 04 in COSP and COSS, version 0. Commitment: value types 21 (purchase requisition) and 22 (purchase order) in COSP.
  4. Period amounts are summed from WKG001…WKG016 for the P_PERFR–P_PERTO range in controlling area currency (TKA01-WAERS).
  5. Remaining = plan − actual − commitment; consumption % = (actual + commitment) / plan × 100. The P_WARN threshold and 100% set the traffic light.

Performance notes

Read COSP and COSS by the object number list, fiscal year, value type and version; the totals tables are small, so the report is much faster than one based on line items. In S/4HANA, do the aggregation in the database.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants Variants with subtotals by cost center or profit center can be saved.
  • Double-click drill-down to the document The actual amount drills down to KSB1 and the commitment amount to the open order items.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Each cost center owner can receive their own rows.

Authorization objects

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

Frequently asked questions

Which commitments are included?

Open purchase requisitions and purchase orders with the cost center as account assignment are included. If other commitment types such as funds reservations are used, they can be added to the value type list.

Can I select by cost center group or hierarchy?

Yes. A cost center group is added to the selection; the group is resolved into a list of cost centers and the result can be subtotaled by hierarchy node.

Does it work on S/4HANA?

Yes. COSP and COSS are read as compatibility views on S/4HANA and actuals come from ACDOCA. If the new planning (ACDOCP) is used, the report is adapted to read plan values from there.

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 Program Custom Mass upload

Cost Center Cost Plan Upload from Excel

A custom program that loads periodic plan amounts per cost center and cost element from a budget file into the CO plan in bulk. It checks every row in …

COSP · CSKS · CSKB

CO Report Custom ALV report

Internal Order Budget Availability Report

A custom ALV report that compares the annual or overall budget of internal orders with actual costs and open commitments, and shows the remaining …

AUFK · BPJA · BPGE · COSP

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: Cost Center Plan vs Actual with Commitments Report