HCM Report Custom development ALV report TR · Türkiye

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

Tables used

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

TableRoleJoinSystem
CATSDBCATS Time Sheet Database TableApproved working times and receiving project (driving table)—ECC + S/4
PRPSWBS Element Master DataWBS element and R&D project classificationPRPS-PSPNR = CATSDB-RPROJECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Org unit and positionPA0001-PERNR = CATSDB-PERNRECC + S/4
PA0002HR Master Record: Infotype 0002 (Personal Data)Name and identity numberPA0002-PERNR = CATSDB-PERNRECC + S/4
PA2001HR Time Record: Infotype 2001 (Absences)Leave and sick daysPA2001-PERNR = CATSDB-PERNRECC + S/4
HRPY_RGDIRDirectory for Payroll ResultsPayroll result directoryHRPY_RGDIR-PERNR = CATSDB-PERNRECC + S/4
PCL2HR Cluster 2 (PCL2)Incentive wage types and basesPCL2-RELID = 'TR' AND PCL2-SRTFD = PERNR + SEQNRECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multiplePA0001-BUKRSYes1000
P_PERIODPeriodSingle value—Yes11.2026
S_ORGEHR&D centre org unitRange / multiplePA0001-ORGEHNo50001200
S_POSIDR&D project (WBS)Range / multiplePRPS-POSIDNoRD-2026-*
P_VIEWView: control / declaration listRadio button—NoKontrol

Output columns

#ColumnSource
1Personnel no.PA0001-PERNR
2First namePA0002-VORNA
3Last namePA0002-NACHN
4Planned time (h)Calculated Personal work schedule − leave
5Booked to R&D projects (h)Calculated Sum of CATSDB-CATSHOURS on R&D-flagged WBS
6R&D shareCalculated R&D time / planned time
7Outside-centre shareCalculated Outside-centre time / total R&D time
8Incentive baseCalculated Incentive base wage type in payroll
9CheckCalculated OK, low R&D share, no time booked or outside-centre limit exceeded

Sample output

Personnel no.First nameLast namePlanned time (h)Booked to R&D projects (h)R&D shareOutside-centre shareIncentive baseCheck
00005011BurcuDemirel1681600.950.0671,200OK
00005017OnurTekin1681120.67064,800Low R&D share
00005023İremŞahin15200058,300No time booked
00005029BarışKoç1681640.980.3169,900Outside-centre limit exceeded
A view built with fictional sample data; not real system data.

How does the report work?

  1. Employees with R&D status are selected through PA0001 (org unit, employee subgroup) and the infotype or subtype the company uses for incentive status.
  2. 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.
  3. Planned working time comes from the personal work schedule; leave and sick days from PA2001 are deducted.
  4. Incentive wage types (income tax exemption, employer social security support) and bases are read from the payroll result (PYXX_READ_PAYROLL_RESULT).
  5. 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.
  6. 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

PS Report Custom ALV report

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

AUFK · AFKO · AFVC · AFVV

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: R&D Personnel Incentive Declaration and Labor Control Report