HCM Report Custom development ALV report

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.

TableRoleJoinSystem
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 checkedPA0000-PERNR = PA0001-PERNRECC + S/4
CSKSCost Center Master RecordValidity of the cost center on the key dateCSKS-KOKRS = P_KOKRS AND CSKS-KOSTL = PA0001-KOSTLECC + S/4
HRP1000Infotype 1000 (Object) Database TableValidity of the position and organizational unitHRP1000-OTYPE IN ('S','O') AND HRP1000-OBJID IN (PA0001-PLANS, PA0001-ORGEH)ECC + S/4
HRP1001Infotype 1001 (Relationships) Database TableRelationship of the position to its organizational unit (A003)HRP1001-OTYPE = 'S' AND HRP1001-OBJID = PA0001-PLANSECC + S/4
PA0003HR Master Record: Infotype 0003 (Payroll Status)Payroll status: payroll accounted-to datePA0003-PERNR = PA0001-PERNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multiplePA0001-BUKRSYes1000
S_WERKSPersonnel areaRange / multiplePA0001-WERKSNoIST1
S_ABKRSPayroll areaRange / multiplePA0001-ABKRSNoTM
S_PERNRPersonnel numberRange / multiplePA0001-PERNRNo00001024
P_KOKRSControlling areaSingle valueCSKS-KOKRSYes1000
P_KEYDTKey date (payroll period end)Single valueSY-DATUMYes30.11.2026

Output columns

#ColumnSource
1Pers. no.PA0001-PERNR
2NamePA0001-ENAME
3Company codePA0001-BUKRS
4Pers. areaPA0001-WERKS
5Payroll areaPA0001-ABKRS
6Org. unitPA0001-ORGEH
7PositionPA0001-PLANS
8Cost centerPA0001-KOSTL
9Valid fromPA0001-BEGDA
10Valid toPA0001-ENDDA
11Payroll accounted toPA0003-ABRDT
12Check codeCalculated Assignment missing, cost center empty/invalid, default position, object delimited, structure mismatch
13ExplanationCalculated Correction hint based on the check code

Sample output

Pers. no.NameCompany codePers. areaPayroll areaOrg. unitPositionCost centerValid fromValid toPayroll accounted toCheck codeExplanation
00001031Mert Yalınkaya1000IST1TM500001359999999910/01/202612/31/999910/31/2026Default positionAssign a position; the cost center will be derived from it
00001044Ece Karadağ1000IST1TM5000012050001210411001/01/202612/31/999910/31/2026Cost center invalidCost center 4110 was closed as of 30.09.2026
00001063Kaan Sarıdere1000ANK1TM5000016250001288430005/01/202512/31/999910/31/2026Structure mismatchPosition 50001288 belongs to unit 50000150 in the org structure
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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”.
  3. 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).
  4. In HRP1001, the position’s relationship to its organizational unit (A003) is compared with PA0001-ORGEH; if different, “Structure mismatch”.
  5. 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

HCM Package Custom

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, …

4 components · v1.0

Related reports

HCM Report Custom ALV report

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 …

PA0000 · PA0001 · T529T · T527X

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: Employees Missing Cost Center or Organizational Assignment Report