R&D Personnel Incentive Declaration and Labor Control Report
Short answer: A report that compares the working time R&D and design centre staff booked to R&D projects with the incentive calculation in payroll. Total working time, time booked to R&D projects, share of work outside the centre and the wage types benefiting from the incentive are shown side by side per employee; inconsistencies are flagged and the employee list for the periodic declaration is prepared.
- Estimated effort
- M · 7–10 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- TR
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Turkish payroll calculates the R&D income tax withholding and social security incentives according to the status assigned to the employee, and CATS_DA shows the time booked to projects. But no report checks that the incentive calculation is consistent with project labour or monitors the share of work outside the centre. The breakdowns requested in audits are prepared by hand.
Who uses it? R&D centre managers, payroll specialists, tax advisers and auditors.
Closest standard alternatives
- CATS_DA Display Working Times. Shows the working times entered; does not compare them with payroll incentives.
- PC00_M99_CWTR Wage Type Reporter. Lists incentive wage types; does not check project labour.
Localization and legal basis
Türkiye · Turkish Revenue Administration (GİB)
Legal basis: Article 3 of Law No. 5746 on Supporting Research, Development and Design Activities and its implementing regulation.
Incentive rates, eligible staff qualifications and limits for work outside the centre are entered in the settings table according to current regulations during installation; declarations are filed through the relevant authorities' systems.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| CATSDBCATS Time Sheet Database Table | Approved working times and receiving project (driving table) | — | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element and R&D project classification | PRPS-PSPNR = CATSDB-RPROJ | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Org unit and position | PA0001-PERNR = CATSDB-PERNR | ECC + S/4 |
| PA0002HR Master Record: Infotype 0002 (Personal Data) | Name and identity number | PA0002-PERNR = CATSDB-PERNR | ECC + S/4 |
| PA2001HR Time Record: Infotype 2001 (Absences) | Leave and sick days | PA2001-PERNR = CATSDB-PERNR | ECC + S/4 |
| HRPY_RGDIRDirectory for Payroll Results | Payroll result directory | HRPY_RGDIR-PERNR = CATSDB-PERNR | ECC + S/4 |
| PCL2HR Cluster 2 (PCL2) | Incentive wage types and bases | PCL2-RELID = 'TR' AND PCL2-SRTFD = PERNR + SEQNR | ECC + S/4 |
BAPIs and functions used
- HR_PERSONAL_WORK_SCHEDULEGenerate Personal Work Schedule. Returns planned working days and hours
- PYXX_READ_PAYROLL_RESULTRead Payroll Result. Reads the incentive wage types
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | PA0001-BUKRS | Yes | 1000 |
| P_PERIOD | Period | Single value | — | Yes | 11.2026 |
| S_ORGEH | R&D centre org unit | Range / multiple | PA0001-ORGEH | No | 50001200 |
| S_POSID | R&D project (WBS) | Range / multiple | PRPS-POSID | No | RD-2026-* |
| P_VIEW | View: control / declaration list | Radio button | — | No | Kontrol |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Personnel no. | PA0001-PERNR |
| 2 | First name | PA0002-VORNA |
| 3 | Last name | PA0002-NACHN |
| 4 | Planned time (h) | Calculated Personal work schedule − leave |
| 5 | Booked to R&D projects (h) | Calculated Sum of CATSDB-CATSHOURS on R&D-flagged WBS |
| 6 | R&D share | Calculated R&D time / planned time |
| 7 | Outside-centre share | Calculated Outside-centre time / total R&D time |
| 8 | Incentive base | Calculated Incentive base wage type in payroll |
| 9 | Check | Calculated OK, low R&D share, no time booked or outside-centre limit exceeded |
Sample output
| Personnel no. | First name | Last name | Planned time (h) | Booked to R&D projects (h) | R&D share | Outside-centre share | Incentive base | Check |
|---|---|---|---|---|---|---|---|---|
| 00005011 | Burcu | Demirel | 168 | 160 | 0.95 | 0.06 | 71,200 | OK |
| 00005017 | Onur | Tekin | 168 | 112 | 0.67 | 0 | 64,800 | Low R&D share |
| 00005023 | İrem | Şahin | 152 | 0 | 0 | 0 | 58,300 | No time booked |
| 00005029 | Barış | Koç | 168 | 164 | 0.98 | 0.31 | 69,900 | Outside-centre limit exceeded |
How does the report work?
- Employees with R&D status are selected through PA0001 (org unit, employee subgroup) and the infotype or subtype the company uses for incentive status.
- Working times are read from CATSDB as approved records (STATUS 30); the receiving WBS element (RPROJ) is classified as an R&D project from PRPS (by a project number range or the user field PRPS-USR00 defined during installation). Work outside the centre is separated by the activity type or attendance type defined during installation.
- Planned working time comes from the personal work schedule; leave and sick days from PA2001 are deducted.
- Incentive wage types (income tax exemption, employer social security support) and bases are read from the payroll result (PYXX_READ_PAYROLL_RESULT).
- Checks: a row is flagged if the R&D time share is below the limit in the settings table, if an employee receives the incentive but booked no time to R&D projects, or if the limit for work outside the centre is exceeded.
- The declaration view gives the period list with identity number, name, title, R&D days and incentive base.
Performance notes
Read CATSDB by PERNR and WORKDATE range, approved status only. Read PRPS for the relevant WBS elements at once with FOR ALL ENTRIES.
Features
- ALV list (sort, filter, subtotals) ALV by employee and project, coloured by check status
- Double-click drill-down to the document Drill-down from a row to the CATS records
- Export to Excel Declaration list and audit breakdown can be exported to Excel
Authorization objects
- P_ORGINAuthorization to read employee data by personnel area, employee group and infotype
- P_PCLXAuthorization to read the payroll result cluster (RELID RU/TR)
Frequently asked questions
Does it work without CATS?
Project time needs a source in SAP. If network confirmations (AFRU) or another timesheet system are used instead of CATS, the source is changed during installation; the check logic stays the same.
Does the report calculate the incentive amount?
No. The incentive is calculated in payroll; the report checks that this calculation is consistent with project labour and prepares the declaration list.
Does it work on S/4HANA?
Yes. CATSDB, PRPS and the payroll cluster keep the same structure on S/4HANA; project costs can also be compared from ACDOCA.
Related reports
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 …
Network Activity Planned vs Actual Work Hours Report
A custom ALV report that compares planned work with confirmed actual work on network activities and lists the remaining hours, completion percentage, …
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.