Personnel Cost Distribution by Organizational Unit and Expense Group
Short answer: A report that distributes payroll costs to the directorate, department and company levels of the org structure and to management's own expense groups (salary, overtime, bonus, benefits, employer contributions). For employees with cost distribution, the cost centre shares are kept; the result is shown monthly and year to date.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Payroll posting (PC00_M99_CIPE) transfers results to CO by cost centre and cost element, and KSB1 shows those items. But the org hierarchy management wants (directorate, department) and its own expense groups are missing. Every month the accounting extract is mapped to the org chart in Excel.
Who uses it? Senior management, controlling, HR and budgeting teams.
Closest standard alternatives
- PC00_M99_CIPE Create Posting Run. Posts payroll by cost centre and cost element; has no org or expense group breakdown.
- KSB1 Cost Centers: Actual Line Items. Shows cost centre line items; does not sum by org hierarchy.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| HRPY_RGDIRDirectory for Payroll Results | Payroll result directory (driving table) | — | ECC + S/4 |
| PCL2HR Cluster 2 (PCL2) | RT and cost distribution (C1) tables | PCL2-RELID = 'TR' AND PCL2-SRTFD = PERNR + SEQNR | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Org unit and cost centre | PA0001-PERNR = HRPY_RGDIR-PERNR | ECC + S/4 |
| HRP1001Infotype 1001 (Relationships) Database Table | Org hierarchy (A002) | HRP1001-OBJID = PA0001-ORGEH AND HRP1001-OTYPE = 'O' | ECC + S/4 |
| HRP1000Infotype 1000 (Object) Database Table | Unit names | HRP1000-OBJID = HRP1001-SOBID | ECC + S/4 |
| T512TWage Type Texts | Wage type texts | — | ECC + S/4 |
| CSKTCost Center Texts | Cost centre name | CSKT-KOSTL = PA0001-KOSTL | ECC + S/4 |
BAPIs and functions used
- PYXX_READ_PAYROLL_RESULTRead Payroll Result. Reads the RT and C1 tables
- RH_STRUC_GETRead Organizational Structure for a Root Object. Rolls an org unit up to higher levels
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_PERIOD | Period (month/year) | Single value | — | Yes | 11.2026 |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | No | 1000 |
| P_ORGEH | Root org unit | Single value | PA0001-ORGEH | No | 50000010 |
| P_LEVEL | Hierarchy level | Single value | — | No | 2 |
| P_YTD | Show year to date | Checkbox | — | No | X |
| P_PRIOR | Compare with prior year | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Directorate | HRP1000-STEXT |
| 2 | Department | Calculated Unit name one level below |
| 3 | Headcount | Calculated Employees with a payroll result |
| 4 | Salary | Calculated Wage types in the salary group |
| 5 | Overtime | Calculated Wage types in the overtime group |
| 6 | Bonus | Calculated Wage types in the bonus group |
| 7 | Benefits | Calculated Meals, transport, health insurance, etc. |
| 8 | Employer contributions | Calculated Employer social security and unemployment |
| 9 | Total cost | Calculated Sum of all groups |
Sample output
| Directorate | Department | Headcount | Salary | Overtime | Bonus | Benefits | Employer contributions | Total cost |
|---|---|---|---|---|---|---|---|---|
| Üretim Müdürlüğü | Montaj | 142 | 5,240,000 | 612,000 | 180,000 | 395,000 | 1,210,000 | 7,637,000 |
| Üretim Müdürlüğü | Bakım | 38 | 1,690,000 | 214,000 | 42,000 | 108,000 | 391,000 | 2,445,000 |
| Finans Müdürlüğü | Muhasebe | 22 | 1,180,000 | 9,000 | 95,000 | 66,000 | 268,000 | 1,618,000 |
| Satış Müdürlüğü | Yurt İçi Satış | 30 | 1,520,000 | 0 | 310,000 | 128,000 | 384,000 | 2,342,000 |
How does the report work?
- Valid payroll results for the period are read from HRPY_RGDIR; the RT and cost distribution (C1) tables are taken from PCL2 with PYXX_READ_PAYROLL_RESULT.
- The employee’s org unit and cost centre come from PA0001; if cost distribution exists, the C1 percentages are used. Optionally, posted amounts are linked to accounting document lines through the PPOIX/PPOPX index.
- The org unit is rolled up to directorate and company level with RH_STRUC_GET (HRP1001 A002 ‘reports to’ relationships); unit names come from HRP1000.
- Wage types are mapped to expense groups with a settings table; employer contributions are collected in a separate group.
- The result is shown at the selected hierarchy level, by month and year to date, optionally compared with the prior year. Cost centre names come from CSKT.
Performance notes
Read the org structure once and keep it in memory; do not call the hierarchy for each employee. Schedule full-year runs in the background.
Features
- ALV list (sort, filter, subtotals) Hierarchical ALV with subtotals per level
- Double-click drill-down to the document Drill-down from a unit to the per-employee wage type breakdown
- Export to Excel Exported to Excel as a management report
- Runs as a background job Can run in the background after month-end close
Authorization objects
- P_PCLXAuthorization to read the payroll result cluster (RELID RU/TR)
- P_ORGINAuthorization to read employee data by personnel area, employee group and infotype
- P_ABAPReport-level HR authorization check to simplify checks for large populations
Frequently asked questions
What if the org structure changes during the period?
The report uses the employee's org assignment at the end of the payroll period and the hierarchy valid on that date. If needed, an option to regroup past periods with the current hierarchy can be added.
Does it reconcile with accounting totals?
Yes, if the wage types mapped to expense groups are the same ones posted to accounting. Unmapped wage types appear under 'Other', so any difference is visible.
Does it work on S/4HANA?
Yes. The payroll cluster and organizational management are the same on S/4HANA (H4S4); the accounting side can be compared through ACDOCA.
Related reports
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 …
Personnel Cost Planning Report and Transfer to CO Planning
A program that forecasts next year's personnel cost per employee and cost centre by month from the current headcount, basic pay, recurring payments …
Payroll Summary and Cover Summary Report (Row and Column Layouts)
A payroll summary report that shows wage type totals by company, work site, cost centre or employee group in flexible row and column layouts after the …
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.