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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| COSRCO Object: Statistical Key Figure Totals | Statistical key figure period values per cost center (driving table) | — | ECC + S/4 |
| TKA03Statistical Key Figures | Key figure unit and category (fixed/totals) | TKA03-KOKRS = P_KOKRS AND TKA03-STAGR = COSR-STAGR | ECC + S/4 |
| CSKSCost Center Master Record | Valid cost centers, object number and owner | CSKS-OBJNR = COSR-OBJNR AND CSKS-KOKRS = P_KOKRS | ECC + S/4 |
| CSKTCost Center Texts | Cost center text | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_StatisticalKeyFigureStatistical Key Figure | Statistical key figure master data on S/4HANA | ControllingArea = P_KOKRS AND StatisticalKeyFigure = COSR-STAGR | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | TKA03-KOKRS | Yes | 1000 |
| S_STAGR | Statistical key figure | Range / multiple | COSR-STAGR | Yes | PERS |
| S_KOSTL | Cost center | Range / multiple | CSKS-KOSTL | No | 4100 – 4999 |
| P_GJAHR | Fiscal year | Single value | COSR-GJAHR | Yes | 2026 |
| P_PERIO | Period | Single value | — | Yes | 10 |
| R_PREV | Reference: previous period | Radio button | — | No | X |
| R_PYEAR | Reference: same period last year | Radio button | — | No | — |
| P_DEV | Change threshold for a warning (%) | Single value | — | No | 20 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Cost center | CSKS-KOSTL |
| 2 | Cost center text | CSKT-KTEXT |
| 3 | Person responsible | CSKS-VERAK |
| 4 | Key figure | COSR-STAGR |
| 5 | Unit | TKA03-MSEHI |
| 6 | Category | TKA03-GRTYP |
| 7 | Reference value | Calculated COSR-SMEnnn value of the reference period |
| 8 | Current value | Calculated COSR-SMEnnn value of the report period |
| 9 | Change % | Calculated (Current − reference) / reference × 100 |
| 10 | Status | Calculated Missing, check (threshold exceeded) or OK |
Sample output
| Cost center | Cost center text | Person responsible | Key figure | Unit | Category | Reference value | Current value | Change % | Status |
|---|---|---|---|---|---|---|---|---|---|
| 4110 | Production maintenance | K. Şahin | PERS | EA | 2 | 14 | 15 | 7.10 | OK |
| 4120 | Machining | B. Kaya | PERS | EA | 2 | 32 | 0 | -100 | Missing |
| 4300 | Warehouse and shipping | E. Arslan | KWH | KWH | 2 | 18,400 | 26,900 | 46.20 | Check |
| 9100 | General administration | M. Aksoy | M2 | M2 | 1 | 640 | 640 | 0 | OK |
How does the report work?
- The unit and category (GRTYP: 1 fixed value, 2 totals value) of the selected key figures are read from TKA03.
- Cost centers valid in the report year are taken from CSKS (DATBI ≥ period end); the text is added from CSKT.
- 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).
- 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.
- 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
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 …
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 …
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.