Payroll Summary and Cover Summary Report (Row and Column Layouts)
Short answer: 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 payroll run. Wage types are rolled up into earnings, statutory deductions, other deductions and employer contributions, and a one-page cover summary for signature is printed from the same data.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
PC00_M99_CWTR lists wage types and the Turkish payroll journal (PC00_M47_CLJN) gives a per-employee printout; but there is no report that pivots wage types into the company's own groups as rows or columns, shows work site and cost centre subtotals and prints an official cover sheet. So a pivot is built in Excel every month.
Who uses it? Payroll specialists, HR and finance managers, accounting teams, auditors.
Closest standard alternatives
- PC00_M99_CWTR Wage Type Reporter. Lists wage types; does not give a row/column summary by the company's groups or a cover sheet.
- PC_PAYRESULT Display Payroll Results. Shows one employee's payroll result; not suitable for a summary.
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: Article 238 of Tax Procedure Law No. 213 (payroll register) and Article 37 of Labour Law No. 4857 (wage statement).
Summary lines and the signature block are set according to the company's approval flow during installation; the legal payroll content is checked against current regulations.
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) | Payroll cluster: RT results table | PCL2-RELID = 'TR' AND PCL2-SRTFD = PERNR + SEQNR | ECC + S/4 |
| T512TWage Type Texts | Wage type texts | T512T-LGART = RT-LGART AND T512T-MOLGA = '47' | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Company, work site, cost centre and employee group breakdown | PA0001-PERNR = HRPY_RGDIR-PERNR | ECC + S/4 |
| T500PPersonnel Areas | Personnel area (work site) name | T500P-PERSA = PA0001-WERKS | ECC + S/4 |
| T001PPersonnel Area/Subarea | Personnel subarea name | T001P-WERKS = PA0001-WERKS AND T001P-BTRTL = PA0001-BTRTL | ECC + S/4 |
| CSKTCost Center Texts | Cost centre name | CSKT-KOSTL = PA0001-KOSTL | ECC + S/4 |
BAPIs and functions used
- CU_READ_RGDIRRead Payroll Directory (Cluster CU). Reads the payroll result directory
- PYXX_READ_PAYROLL_RESULTRead Payroll Result. Reads the RT table
- SSF_FUNCTION_MODULE_NAMEGet Smart Form Function Module Name. Finds the function name of the cover summary form
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_ABKRS | Payroll area | Single value | PA0001-ABKRS | Yes | T1 |
| P_PERIOD | Period | Single value | — | Yes | 11.2026 |
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | No | 1000 |
| S_WERKS | Personnel area | Range / multiple | PA0001-WERKS | No | 1000 |
| P_LAYOUT | Layout: groups as rows / groups as columns | Radio button | — | No | Grup satırda |
| P_COVER | Print the cover summary | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | PA0001-BUKRS |
| 2 | Work site | T500P-NAME1 |
| 3 | Cost centre | CSKT-KTEXT |
| 4 | Headcount | Calculated Employees with a payroll result in the period |
| 5 | Gross earnings | Calculated Sum of wage types in the earnings group |
| 6 | Statutory deductions | Calculated Income tax, stamp tax, employee social security and unemployment |
| 7 | Other deductions | Calculated Advances, garnishments, private pension and other deductions |
| 8 | Net pay | Calculated Gross − statutory − other deductions |
| 9 | Employer contributions | Calculated Employer social security and unemployment |
| 10 | Total employer cost | Calculated Gross earnings + employer contributions |
Sample output
| Company code | Work site | Cost centre | Headcount | Gross earnings | Statutory deductions | Other deductions | Net pay | Employer contributions | Total employer cost |
|---|---|---|---|---|---|---|---|---|---|
| 1000 | Merkez Ofis | Finans | 42 | 2,310,500 | 612,400.50 | 48,300 | 1,649,799.50 | 473,652.50 | 2,784,152.50 |
| 1000 | Merkez Ofis | İnsan Kaynakları | 18 | 864,200 | 228,800.10 | 12,100 | 623,299.90 | 177,161 | 1,041,361 |
| 1000 | Fabrika | Üretim | 236 | 9,127,400 | 2,310,550.30 | 286,400 | 6,530,449.70 | 1,871,117 | 10,998,517 |
| 2000 | Bölge Deposu | Lojistik | 31 | 1,124,800 | 281,900 | 22,900 | 820,000 | 230,584 | 1,355,384 |
How does the report work?
- Valid results for the payroll area and period are read from HRPY_RGDIR with CU_READ_RGDIR; for retroactive runs the in-period or for-period view is chosen by parameter.
- The RT table is taken from PCL2 with PYXX_READ_PAYROLL_RESULT. Wage type texts come from T512T.
- A grouping table maps wage types to earnings, statutory deductions (income tax, stamp tax, employee social security and unemployment contributions), other deductions, employer contributions and net pay lines.
- Breakdown fields come from PA0001 (company code, personnel area, subarea, cost centre, employee group); the work site name comes from T500P and T001P, the cost centre name from CSKT.
- Layout choice: wage type groups as rows and breakdowns as columns, or the other way round. Headcount is shown in every column.
- The cover summary is printed with Smart Forms: period, company, total gross, deductions, net, employer cost, headcount and signature fields for preparer and approver.
Performance notes
Read payroll results from the cluster per employee and sum only the wage types in the grouping table. For large companies, run the report in the background after period close and store the result.
Features
- ALV list (sort, filter, subtotals) ALV list with selectable row/column layout and subtotals
- User-specific layout variants User-specific layout variants
- Double-click drill-down to the document Drill-down from a total to the per-employee wage type breakdown
- Export to Excel The summary can be exported to Excel
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
Frequently asked questions
How are wage type groups changed?
Groups are kept in a settings table; when a new wage type is created it is only added there, without changing the program. Unassigned wage types appear on an 'Other' line so that missing mappings are not overlooked.
How are retroactive calculations shown?
A parameter chooses between two views: by the period in which it was paid (in-period) or by the period it belongs to (for-period). The in-period view is usually used for reconciliation with accounting.
Does it work on S/4HANA?
Yes. The payroll cluster and organizational assignment keep the same structure on S/4HANA (H4S4); cost centre texts are still read from CSKT.
Related reports
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 …
Payroll Wage Type Period Comparison and Variance Report
A custom ALV report that compares the payroll results of one period with the previous period per employee and wage type, and lists variances above a …
Bank-Specific Salary Payment File Generation
A program that reads net payment amounts from payroll results after the payroll run and produces the salary file in the format each bank requires. …
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.