CO Report Custom development ALV report

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

  • KS13 Cost Centers: Master Data Report. Shows cost centers in bulk; does not check whether the profit center assignment is valid.
  • KE53 Display Profit Center. Shows one profit center; no comparison with cost centers.

Tables used

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

TableRoleJoinSystem
CSKSCost Center Master RecordCost center master: company code, person responsible, profit center, validity (driving table)—ECC + S/4
CSKTCost Center TextsCost center descriptionCSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGUECC + S/4
CEPCProfit Center Master DataProfit center master: validity and lock indicatorCEPC-KOKRS = CSKS-KOKRS AND CEPC-PRCTR = CSKS-PRCTRECC + S/4
CEPCTProfit Center TextsProfit center descriptionCEPCT-KOKRS = CEPC-KOKRS AND CEPCT-PRCTR = CEPC-PRCTR AND CEPCT-DATBI = CEPC-DATBI AND CEPCT-SPRAS = SY-LANGUECC + S/4
AUFKOrder Master DataInternal orders and assigned profit center (optional)AUFK-KOKRS = CSKS-KOKRSECC + S/4
COSPCO Object: Cost Totals for External PostingsActual primary costs in the yearCOSP-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

ParameterDescriptionTypeReference fieldRequiredExample
P_KOKRSControlling areaSingle valueCSKS-KOKRSYes1000
S_BUKRSCompany codeRange / multipleCSKS-BUKRSNo1000
S_KOSTLCost centerRange / multipleCSKS-KOSTLNo4100 – 4999
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026
P_GJAHRFiscal year for the cost checkSingle valueCOSP-GJAHRNo2026
P_ORDERSAlso check internal ordersCheckbox—NoX
P_COSTSShow only objects with costsCheckbox—No—

Output columns

#ColumnSource
1Controlling areaCSKS-KOKRS
2Company codeCSKS-BUKRS
3Object typeCalculated Cost center or internal order
4Cost center / orderCSKS-KOSTL
5DescriptionCSKT-KTEXT
6Valid toCSKS-DATBI
7Person responsibleCSKS-VERAK
8Profit centerCSKS-PRCTR
9Profit center descriptionCEPCT-KTEXT
10Profit center valid toCEPC-DATBI
11Profit center lockedCEPC-LOCK_IND
12Actual costs this yearCalculated Sum of COSP WKG001…WKG016, value type 04
13IssueCalculated Missing assignment, undefined, locked or validity mismatch

Sample output

Controlling areaCompany codeObject typeCost center / orderDescriptionValid toPerson responsibleProfit centerProfit center descriptionProfit center valid toProfit center lockedActual costs this yearIssue
10001000Cost center4120Quality control12/31/9999M. Arslan286,400Missing assignment
10001000Cost center4310Maintenance workshop12/31/9999S. KoçPC2100Production Bursa12/31/2025512,900Validity mismatch
10002000Cost center5200Izmir sales office12/31/9999E. ŞahinPC3200Aegean region12/31/9999X74,300Locked
10001000Internal order700145Trade fair 2026PC9999118,000Undefined
A view built with fictional sample data; not real system data.

How does the report work?

  1. Cost centers valid on the key date for the selected controlling area are read from CSKS, with texts from CSKT.
  2. 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.
  3. If selected, internal orders from AUFK are checked with the same rules (AUFK-PRCTR).
  4. Objects with actual costs in the year are totalled from COSP (actual value type); problem objects that carry costs are prioritised.
  5. 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

CO Package Custom

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 …

4 components · v1.0

Related reports

CO Report Custom ALV report

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 …

FAGLFLEXT · CEPC · CEPCT · SKAT

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 Centers with Missing or Invalid Profit Center Assignment Report