# Personnel Cost Distribution by Organizational Unit and Expense Group

> 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.

- Type: Report, Custom development, ALV report
- Module: HCM
- Estimated effort: M (6–9 working days)
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/reports/personnel-cost-distribution-by-org-unit-and-expense-group/


## 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.

### Closest standard alternatives

- PC00_M99_CIPE: Posts payroll by cost centre and cost element; has no org or expense group breakdown.
- KSB1: Shows cost centre line items; does not sum by org hierarchy.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| HRPY_RGDIR | Payroll result directory (driving table) | Read | - | ECC + S/4 |
| PCL2 | RT and cost distribution (C1) tables | Read | PCL2-RELID = 'TR' AND PCL2-SRTFD = PERNR + SEQNR | ECC + S/4 |
| PA0001 | Org unit and cost centre | Read | PA0001-PERNR = HRPY_RGDIR-PERNR | ECC + S/4 |
| HRP1001 | Org hierarchy (A002) | Read | HRP1001-OBJID = PA0001-ORGEH AND HRP1001-OTYPE = 'O' | ECC + S/4 |
| HRP1000 | Unit names | Read | HRP1000-OBJID = HRP1001-SOBID | ECC + S/4 |
| T512T | Wage type texts | Read | - | ECC + S/4 |
| CSKT | Cost centre name | Read | CSKT-KOSTL = PA0001-KOSTL | ECC + S/4 |

## BAPIs and functions used

- PYXX_READ_PAYROLL_RESULT: Reads the RT and C1 tables
- RH_STRUC_GET: Rolls an org unit up to higher levels

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_PERIOD | Period (month/year) | Single value | - | Yes |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | No |
| P_ORGEH | Root org unit | Single value | PA0001-ORGEH | No |
| P_LEVEL | Hierarchy level | Single value | - | No |
| P_YTD | Show year to date | Checkbox | - | No |
| P_PRIOR | Compare with prior year | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Directorate | HRP1000-STEXT |
| Department | Calculated: Unit name one level below |
| Headcount | Calculated: Employees with a payroll result |
| Salary | Calculated: Wage types in the salary group |
| Overtime | Calculated: Wage types in the overtime group |
| Bonus | Calculated: Wage types in the bonus group |
| Benefits | Calculated: Meals, transport, health insurance, etc. |
| Employer contributions | Calculated: Employer social security and unemployment |
| Total cost | Calculated: Sum of all groups |

## How does the report work?

1. 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.
2. 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.
3. 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.
4. Wage types are mapped to expense groups with a settings table; employer contributions are collected in a separate group.
5. 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.

## Authorization objects

- P_PCLX: Authorization to read the payroll result cluster (RELID RU/TR)
- P_ORGIN: Authorization to read employee data by personnel area, employee group and infotype
- P_ABAP: Report-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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=hcm-payroll-cost-distribution-by-org
