Employees Missing Cost Center or Organizational Assignment Report
Short answer: A custom ALV check report that finds, before payroll runs, active employees with an empty or invalid cost center, assignments left on the default position, delimited organizational units or positions, and organizational assignments that do not match the action records. The payroll team fixes FI/CO posting errors before posting.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
PA20 shows one employee. A broken infotype 0001 record is usually noticed only when posting payroll results to accounting (PC00_M99_CIPE) fails. There is no standard list that checks in bulk whether the cost center is valid on the posting date, whether the position has been delimited and whether the assignment is consistent with the action record.
Who uses it? Payroll specialists, HR master data teams and cost accounting.
Closest standard alternatives
- PA20 Display HR Master Data. Shows the infotypes of one employee; no bulk consistency check.
- PC00_M99_CIPE Create Posting Run. Posts payroll results to accounting; reports an invalid cost center only as an error during posting.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Organizational assignment: company code, payroll area, unit, position, cost center (driving table) | — | ECC + S/4 |
| PA0000HR Master Record: Infotype 0000 (Actions) | Employment status; only active employees are checked | PA0000-PERNR = PA0001-PERNR | ECC + S/4 |
| CSKSCost Center Master Record | Validity of the cost center on the key date | CSKS-KOKRS = P_KOKRS AND CSKS-KOSTL = PA0001-KOSTL | ECC + S/4 |
| HRP1000Infotype 1000 (Object) Database Table | Validity of the position and organizational unit | HRP1000-OTYPE IN ('S','O') AND HRP1000-OBJID IN (PA0001-PLANS, PA0001-ORGEH) | ECC + S/4 |
| HRP1001Infotype 1001 (Relationships) Database Table | Relationship of the position to its organizational unit (A003) | HRP1001-OTYPE = 'S' AND HRP1001-OBJID = PA0001-PLANS | ECC + S/4 |
| PA0003HR Master Record: Infotype 0003 (Payroll Status) | Payroll status: payroll accounted-to date | PA0003-PERNR = PA0001-PERNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes | 1000 |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No | IST1 |
| S_ABKRS | Payroll area | Range / multiple | PA0001-ABKRS | No | TM |
| S_PERNR | Personnel number | Range / multiple | PA0001-PERNR | No | 00001024 |
| P_KOKRS | Controlling area | Single value | CSKS-KOKRS | Yes | 1000 |
| P_KEYDT | Key date (payroll period end) | Single value | SY-DATUM | Yes | 30.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Pers. no. | PA0001-PERNR |
| 2 | Name | PA0001-ENAME |
| 3 | Company code | PA0001-BUKRS |
| 4 | Pers. area | PA0001-WERKS |
| 5 | Payroll area | PA0001-ABKRS |
| 6 | Org. unit | PA0001-ORGEH |
| 7 | Position | PA0001-PLANS |
| 8 | Cost center | PA0001-KOSTL |
| 9 | Valid from | PA0001-BEGDA |
| 10 | Valid to | PA0001-ENDDA |
| 11 | Payroll accounted to | PA0003-ABRDT |
| 12 | Check code | Calculated Assignment missing, cost center empty/invalid, default position, object delimited, structure mismatch |
| 13 | Explanation | Calculated Correction hint based on the check code |
Sample output
| Pers. no. | Name | Company code | Pers. area | Payroll area | Org. unit | Position | Cost center | Valid from | Valid to | Payroll accounted to | Check code | Explanation |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001031 | Mert Yalınkaya | 1000 | IST1 | TM | 50000135 | 99999999 | 10/01/2026 | 12/31/9999 | 10/31/2026 | Default position | Assign a position; the cost center will be derived from it | |
| 00001044 | Ece Karadağ | 1000 | IST1 | TM | 50000120 | 50001210 | 4110 | 01/01/2026 | 12/31/9999 | 10/31/2026 | Cost center invalid | Cost center 4110 was closed as of 30.09.2026 |
| 00001063 | Kaan Sarıdere | 1000 | ANK1 | TM | 50000162 | 50001288 | 4300 | 05/01/2025 | 12/31/9999 | 10/31/2026 | Structure mismatch | Position 50001288 belongs to unit 50000150 in the org structure |
How does the report work?
- Employees active on the key date in PA0000 (STAT2 = 3) are selected; the assignment valid on that date is read from PA0001. Without an assignment, the error “Assignment missing” is written.
- If the cost center is empty and cannot be derived from the position, “Cost center empty”; if filled, a record valid on the key date (DATAB ≤ date ≤ DATBI) is searched in CSKS for the selected controlling area, otherwise “Cost center invalid”.
- If the position is 99999999, “Default position”; otherwise HRP1000 is checked for the position (OTYPE S) being valid on the key date. The same check is done for the organizational unit (OTYPE O).
- In HRP1001, the position’s relationship to its organizational unit (A003) is compared with PA0001-ORGEH; if different, “Structure mismatch”.
- The payroll accounted-to date (ABRDT) is added from PA0003; errors are listed by employee and check code.
Performance notes
Restrict PA0001 and PA0000 to records valid on the key date. Read the CSKS and HRP1000 checks once for the unique list of cost centers and objects. Schedule the report as a background job one day before payroll in the payroll calendar.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the personnel number opens infotype 0001 in PA20.
- Export to Excel
- Runs as a background job Can run automatically before payroll in the payroll calendar.
- Send the result by email
Authorization objects
- P_ORGINRead authorization for personnel data by infotype and organizational assignment
- PLOGRead authorization for organizational management objects
- K_CSKSRead authorization for cost center master data
Frequently asked questions
Is an empty cost center an error if it is derived from the position?
No. If the cost center is empty, the report first checks the position's cost assignment relationship (HRP1001); if a valid cost center is found from the position, the row is not listed as an error.
Does the report make corrections?
No, it only reads. Corrections are made in the standard process with PA30 or PPOME; if bulk correction is needed, it can be done with a separate upload program.
Does the report work if organizational management integration is off?
Yes. If integration is off, the HRP1000/HRP1001 checks are skipped and only the PA0001 and CSKS checks are done.
Packages that include this solution
Pre-Payroll Check and Upload Pack
A pack that brings together the work done before every payroll run: bulk upload of additional payments and absence and attendance records from Excel, …
Related reports
Employee Bank Details Changed Since Last Payroll Report
A custom ALV control report that lists employees whose bank details (infotype 0009) were created or changed after the last payroll run or within a …
Headcount Movement and Turnover Report by Department
A custom ALV report that gives, for the selected period and per organizational unit, opening headcount, hires, transfers between units, voluntary 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.