HCM Report Custom development ALV report TR · Türkiye

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

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
HRPY_RGDIRDirectory for Payroll ResultsPayroll result directory (driving table)—ECC + S/4
PCL2HR Cluster 2 (PCL2)Payroll cluster: RT results tablePCL2-RELID = 'TR' AND PCL2-SRTFD = PERNR + SEQNRECC + S/4
T512TWage Type TextsWage type textsT512T-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 breakdownPA0001-PERNR = HRPY_RGDIR-PERNRECC + S/4
T500PPersonnel AreasPersonnel area (work site) nameT500P-PERSA = PA0001-WERKSECC + S/4
T001PPersonnel Area/SubareaPersonnel subarea nameT001P-WERKS = PA0001-WERKS AND T001P-BTRTL = PA0001-BTRTLECC + S/4
CSKTCost Center TextsCost centre nameCSKT-KOSTL = PA0001-KOSTLECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_ABKRSPayroll areaSingle valuePA0001-ABKRSYesT1
P_PERIODPeriodSingle value—Yes11.2026
S_BUKRSCompany codeRange / multiplePA0001-BUKRSNo1000
S_WERKSPersonnel areaRange / multiplePA0001-WERKSNo1000
P_LAYOUTLayout: groups as rows / groups as columnsRadio button—NoGrup satırda
P_COVERPrint the cover summaryCheckbox—NoX

Output columns

#ColumnSource
1Company codePA0001-BUKRS
2Work siteT500P-NAME1
3Cost centreCSKT-KTEXT
4HeadcountCalculated Employees with a payroll result in the period
5Gross earningsCalculated Sum of wage types in the earnings group
6Statutory deductionsCalculated Income tax, stamp tax, employee social security and unemployment
7Other deductionsCalculated Advances, garnishments, private pension and other deductions
8Net payCalculated Gross − statutory − other deductions
9Employer contributionsCalculated Employer social security and unemployment
10Total employer costCalculated Gross earnings + employer contributions

Sample output

Company codeWork siteCost centreHeadcountGross earningsStatutory deductionsOther deductionsNet payEmployer contributionsTotal employer cost
1000Merkez OfisFinans422,310,500612,400.5048,3001,649,799.50473,652.502,784,152.50
1000Merkez Ofisİnsan Kaynakları18864,200228,800.1012,100623,299.90177,1611,041,361
1000FabrikaÜretim2369,127,4002,310,550.30286,4006,530,449.701,871,11710,998,517
2000Bölge DeposuLojistik311,124,800281,90022,900820,000230,5841,355,384
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. The RT table is taken from PCL2 with PYXX_READ_PAYROLL_RESULT. Wage type texts come from T512T.
  3. 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.
  4. 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.
  5. Layout choice: wage type groups as rows and breakdowns as columns, or the other way round. Headcount is shown in every column.
  6. 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

HCM Program Custom Interface TR

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

HRPY_RGDIR · PCL2 · PA0009 · BNKA

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: Payroll Summary and Cover Summary Report (Row and Column Layouts)