Understanding the RT Table in SAP HR

In SAP Human Resources (HR), the RT table plays a critical role in storing and managing payroll results. Understanding its function and how to access it is beneficial for HR specialists, payroll administrators, and SAP consultants. Let’s dive in!

What exactly is the RT Table?

• The RT table stands for “Results Table.”
• It is a dynamic, internal table generated each time payroll is executed in the SAP HR system.
• It holds calculated wage types and their corresponding values for each employee in the payroll run.

What Data Does the RT Table Hold?

The RT table houses crucial payroll-related information, including:

• Wage Types: Identifiers for different payment components (e.g., basic salary, overtime, bonuses, deductions, etc.)
• Amounts: The calculated monetary values for each wage type.
• Number/Rate: For wage types based on a quantity or rate (e.g., hours worked, hourly rate).
• Period Parameters: Time intervals relevant to the calculation (e.g., start date, end date).

Why is the RT Table Important?

1. Payroll Reporting and Analysis: The RT table is the source for various payroll reports, which extract wage types, amounts, and other relevant data for analysis and audits.
2. Integration: Wage type values in the RT table can be transferred to other modules, such as Financial Accounting (FI), to post costs.
3. Retroactive Payroll Calculations: The RT table serves as a reference point if payroll needs to be rerun with changes from previous periods.

How to Access the RT Table

There are several ways to view the contents of the RT table:

• Transaction Codes:
  • PC_PAYRESULT: General payroll result viewer
  • PC00_M99_CWTR: Cluster display of results table
• Payroll Log: The RT table data is displayed during relevant processing steps within a specific employee’s payroll log.
• ABAP Programming: For custom reports or data extractions, ABAP programmers can access the RT table using function modules like:
  • RP_PROVIDE_FROM_LAST
  • CU_READ_RGDIR

Important Considerations

• The RT table is temporary and is overwritten each time payroll is run.
• To retain historical payroll results, essential data from the RT table is transferred to other tables like CRT (Cumulation Results Table).
• Being a dynamic internal table, the RT table doesn’t have a fixed database table counterpart.

In Conclusion

The RT table is a central pillar of the SAP HR payroll process. Understanding its purpose, contents, and access methods empowers SAP HR users to manage, analyze, and report on their payroll data effectively.