Cost Centers with Missing or Invalid Profit Center Assignment Report
Short answer: A custom ALV report that checks cost centers, and optionally internal orders, for their profit center assignment and lists records where the assignment is missing, the profit center is undefined, locked or expires before the cost center. Costs that never reach a profit center are found before month-end and before document splitting or an S/4HANA migration.
- Estimated effort
- S · 2–3 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
KS13 shows cost centers in bulk and can list the profit center field, but it does not check whether the assignment is valid, unlocked and defined for the same period as the cost center. KE53 shows one profit center. Unassigned costs are noticed only when amounts pile up on the default profit center in profit center reports.
Who uses it? Controllers, profit center accounting users, master data teams and S/4HANA conversion projects.
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 |
|---|---|---|---|
| CSKSCost Center Master Record | Cost center master: company code, person responsible, profit center, validity (driving table) | — | ECC + S/4 |
| CSKTCost Center Texts | Cost center description | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGU | ECC + S/4 |
| CEPCProfit Center Master Data | Profit center master: validity and lock indicator | CEPC-KOKRS = CSKS-KOKRS AND CEPC-PRCTR = CSKS-PRCTR | ECC + S/4 |
| CEPCTProfit Center Texts | Profit center description | CEPCT-KOKRS = CEPC-KOKRS AND CEPCT-PRCTR = CEPC-PRCTR AND CEPCT-DATBI = CEPC-DATBI AND CEPCT-SPRAS = SY-LANGU | ECC + S/4 |
| AUFKOrder Master Data | Internal orders and assigned profit center (optional) | AUFK-KOKRS = CSKS-KOKRS | ECC + S/4 |
| COSPCO Object: Cost Totals for External Postings | Actual primary costs in the year | COSP-OBJNR = 'KS' + CSKS-KOKRS + CSKS-KOSTL (veya AUFK-OBJNR) AND COSP-GJAHR = P_GJAHR AND COSP-WRTTP = '04' | ECC + S/4 |
S/4HANA notes
- COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | CSKS-KOKRS | Yes | 1000 |
| S_BUKRS | Company code | Range / multiple | CSKS-BUKRS | No | 1000 |
| S_KOSTL | Cost center | Range / multiple | CSKS-KOSTL | No | 4100 – 4999 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_GJAHR | Fiscal year for the cost check | Single value | COSP-GJAHR | No | 2026 |
| P_ORDERS | Also check internal orders | Checkbox | — | No | X |
| P_COSTS | Show only objects with costs | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Controlling area | CSKS-KOKRS |
| 2 | Company code | CSKS-BUKRS |
| 3 | Object type | Calculated Cost center or internal order |
| 4 | Cost center / order | CSKS-KOSTL |
| 5 | Description | CSKT-KTEXT |
| 6 | Valid to | CSKS-DATBI |
| 7 | Person responsible | CSKS-VERAK |
| 8 | Profit center | CSKS-PRCTR |
| 9 | Profit center description | CEPCT-KTEXT |
| 10 | Profit center valid to | CEPC-DATBI |
| 11 | Profit center locked | CEPC-LOCK_IND |
| 12 | Actual costs this year | Calculated Sum of COSP WKG001…WKG016, value type 04 |
| 13 | Issue | Calculated Missing assignment, undefined, locked or validity mismatch |
Sample output
| Controlling area | Company code | Object type | Cost center / order | Description | Valid to | Person responsible | Profit center | Profit center description | Profit center valid to | Profit center locked | Actual costs this year | Issue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 1000 | Cost center | 4120 | Quality control | 12/31/9999 | M. Arslan | 286,400 | Missing assignment | ||||
| 1000 | 1000 | Cost center | 4310 | Maintenance workshop | 12/31/9999 | S. Koç | PC2100 | Production Bursa | 12/31/2025 | 512,900 | Validity mismatch | |
| 1000 | 2000 | Cost center | 5200 | Izmir sales office | 12/31/9999 | E. Şahin | PC3200 | Aegean region | 12/31/9999 | X | 74,300 | Locked |
| 1000 | 1000 | Internal order | 700145 | Trade fair 2026 | PC9999 | 118,000 | Undefined |
How does the report work?
- Cost centers valid on the key date for the selected controlling area are read from CSKS, with texts from CSKT.
- CSKS-PRCTR is checked for each cost center: blank means Missing assignment; not in CEPC means Undefined profit center; CEPC-LOCK_IND set means Locked; CEPC-DATBI before the cost center’s valid-to date means Validity mismatch.
- If selected, internal orders from AUFK are checked with the same rules (AUFK-PRCTR).
- Objects with actual costs in the year are totalled from COSP (actual value type); problem objects that carry costs are prioritised.
- The profit center text is added from CEPCT; the result is sorted by issue type.
Performance notes
Master data tables are small; COSP is read only by object number and fiscal year. The report runs in seconds even for large controlling areas.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the cost center opens KS03; double-clicking the profit center opens KE53.
- Export to Excel
- Runs as a background job Can run automatically before month-end close and be sent to the master data team.
- Send the result by email
Authorization objects
- K_CSKSCost center master display authorization
- K_PCAProfit center authorization
- K_ORDERInternal order display authorization
Frequently asked questions
Where do postings to a cost center without an assignment go?
In profit center accounting they land on the default (dummy) profit center. The report shows the cost centers behind these amounts and how much cost they carried during the year.
Why does this check matter on S/4HANA?
On S/4HANA the profit center sits on the same document line, and with document splitting every line is expected to carry the right profit center. Fixing missing assignments before the conversion reduces the need for correction postings at period close.
Can the fixes be made in bulk?
Yes. The records to fix can be exported to Excel and updated with the mass cost center change program; running the report again confirms the result.
Packages that include this solution
Cost Center Reorganization Pack
A four-component pack for rebuilding the cost center structure after an organizational change: mass cost center creation and change from Excel, cost …
Related reports
Mass Cost Center Creation and Change Upload from Excel
A custom program that creates or updates cost centers in bulk from Excel or CSV rows, with description, person responsible, company code, profit …
Profit Center Plan vs Actual Revenue and Cost Report
A custom ALV report that compares plan and actual amounts by profit center and account for the period and year to date, and gives the variance as …
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.