CO Report Custom development ALV report

Missing or Late Statistical Key Figures Check Report

Short answer: A custom ALV report that checks, per cost center, whether the statistical key figures used as keys in assessment and distribution cycles (headcount, square meters, kWh and so on) have been entered for this period and how much they changed against the previous period. Missing values are visible before the cycle runs.

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

Why is the standard not enough?

KB33N displays statistical key figure documents one by one; it does not list which cost centers are missing a value this period. A missing headcount or square-meter value is only noticed after the assessment cycle has posted zero or a wrong allocation, and the cycle is then reversed and run again. A check list is needed before the close.

Who uses it? Cost accountants and controllers running the month-end close.

Closest standard alternatives

  • KB33N Display Statistical Key Figures. Displays statistical key figure documents; does not list missing values.
  • KSU5 Execute Actual Assessment. Runs the assessment cycle; a missing key is only noticed in the cycle result.

Tables used

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

TableRoleJoinSystem
COSRCO Object: Statistical Key Figure TotalsStatistical key figure period values per cost center (driving table)—ECC + S/4
TKA03Statistical Key FiguresKey figure unit and category (fixed/totals)TKA03-KOKRS = P_KOKRS AND TKA03-STAGR = COSR-STAGRECC + S/4
CSKSCost Center Master RecordValid cost centers, object number and ownerCSKS-OBJNR = COSR-OBJNR AND CSKS-KOKRS = P_KOKRSECC + S/4
CSKTCost Center TextsCost center textCSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGUECC + S/4
I_StatisticalKeyFigureStatistical Key FigureStatistical key figure master data on S/4HANAControllingArea = P_KOKRS AND StatisticalKeyFigure = COSR-STAGRS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_KOKRSControlling areaSingle valueTKA03-KOKRSYes1000
S_STAGRStatistical key figureRange / multipleCOSR-STAGRYesPERS
S_KOSTLCost centerRange / multipleCSKS-KOSTLNo4100 – 4999
P_GJAHRFiscal yearSingle valueCOSR-GJAHRYes2026
P_PERIOPeriodSingle value—Yes10
R_PREVReference: previous periodRadio button—NoX
R_PYEARReference: same period last yearRadio button—No—
P_DEVChange threshold for a warning (%)Single value—No20

Output columns

#ColumnSource
1Cost centerCSKS-KOSTL
2Cost center textCSKT-KTEXT
3Person responsibleCSKS-VERAK
4Key figureCOSR-STAGR
5UnitTKA03-MSEHI
6CategoryTKA03-GRTYP
7Reference valueCalculated COSR-SMEnnn value of the reference period
8Current valueCalculated COSR-SMEnnn value of the report period
9Change %Calculated (Current − reference) / reference × 100
10StatusCalculated Missing, check (threshold exceeded) or OK

Sample output

Cost centerCost center textPerson responsibleKey figureUnitCategoryReference valueCurrent valueChange %Status
4110Production maintenanceK. ŞahinPERSEA214157.10OK
4120MachiningB. KayaPERSEA2320-100Missing
4300Warehouse and shippingE. ArslanKWHKWH218,40026,90046.20Check
9100General administrationM. AksoyM2M216406400OK
A view built with fictional sample data; not real system data.

How does the report work?

  1. The unit and category (GRTYP: 1 fixed value, 2 totals value) of the selected key figures are read from TKA03.
  2. Cost centers valid in the report year are taken from CSKS (DATBI ≥ period end); the text is added from CSKT.
  3. Actual values are read from COSR (WRTTP = 04, VERSN = 000): the report period value from the SMEnnn field; the reference value from the previous period or the same period last year (R_PREV / R_PYEAR).
  4. For totals-type key figures a zero value this period means “missing”; for fixed-value ones the value carries forward to later periods, so “missing” is only flagged when nothing was ever entered.
  5. Change % = (this period − reference) / reference × 100; rows above P_DEV are flagged as “check”.

Performance notes

Read COSR with the object number list, fiscal year and key figure selection; build the cost center object numbers from CSKS in one pass. Data volume is small; the report runs in seconds.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Export to Excel
  • Runs as a background job Can run automatically in the closing calendar before the allocation cycles.
  • Send the result by email Missing values can be sent to the responsible cost center owner.

Authorization objects

  • K_CSKSAuthorization to display cost center data
  • K_CCACost center accounting transaction authorization

Frequently asked questions

Why are fixed-value and totals-type key figures checked differently?

A fixed-value entry stays valid for later periods, so an empty period does not mean it is missing. A totals-type key figure needs a new value every period.

How are the key figures to check chosen?

The list of key figures is given on the selection screen. Optionally, the key figures used in the cycles can be read from the cycle definitions and selected automatically.

Are key figures on internal orders checked too?

The default scope is cost centers. If key figures are posted to internal orders as well, order objects (AUFK) are added as an extra selection.

Related reports

CO Program Custom Mass upload

Mass Direct Activity Allocation Upload from Excel

A custom program that reads hours and machine times spent by workshops, maintenance or service units from an Excel file and posts them as direct …

COEP · COSS · CSLA · CSKS

CO Program Custom Interface

Statistical Key Figure Actuals Upload Interface

A custom interface that reads values such as headcount, kWh or square meters delivered by HR, energy monitoring or facility systems from a file and …

COSR · TKA03 · CSKS · AUFK

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: Missing or Late Statistical Key Figures Check Report