Internal Tables for Payroll Tables that are used for storing data during the payroll run.
Within
Payroll
, data is processed in internal tables that the system fills and reads during the payroll run. The system also changes the data in these tables during the payroll run. The results of processing are then available for other steps.
The read and change access to these tables is enabled using functions that are executed in a personnel calculation schema and using operations that are executed in personnel calculation rules .
The following are some of the tables used in all country versions for
Payroll
:
Table |
Short text |
Description |
|---|---|---|
WPBP |
Work Place/Basic Pay |
Table WPBP is filled by the infotypes
For more information on table WBPB, see Payment-Relevant Information in the Payroll Result . |
RT |
Results Table |
Table RT contains the result wage types of the current period for which payroll is run. Data is transferred from table IT to table RT using the operation ADDWTE. |
CRT |
Cumulative Results Table |
Table CRT contains the cumulations of wage types in table RT over a certain time period. |
BT |
Payment Information |
Every entry in the
For more information on table BT, see Payment-Relevant Information in the Payroll Result . |
C0 |
Cost Distribution |
Table C0 contains global information about the cost distribution for wage types. Certain costs can be distributed to other cost centers than the master cost center. The information is taken from the
|
C1 |
Cost Assignment from Different Infotypes |
Table C1 contains information about the individual cost assignment for individual wage types. You can use the infotype
|
V0 |
Variable Assignment |
Table V0 contains various additional information about the wage types. |
GRT |
Output Table from Gross Part |
Table GRT is table RT according to the gross amount in a split payroll schema. |
ARRRS |
Arrears |
Table ARRRS contains deductions that could not be taken and so are transferred to the following period. |
DDNTK |
Deductions not taken |
Table DDNTK contains deductions that could not be taken in the current period. |
ACCR |
Month End Accruals |
Table ACCR contains special information on a posting period assignment for month end accruals. |
BENTAB |
Benefits |
Table BENTAB contains cumulations for certain benefits plans. |
FUND |
Financing |
Table FUND contains information about fund commitments. This information is taken from HR Funds and Position Management. |
AVERAGE |
Frozen Averages |
Table AVERAGE contains information about frozen averages. |
MODIF |
Modifiers |
Table MODIF contains various modifiers that can be used as additional keys for access to Customizing tables. The system sets the modifiers in payroll with the function MOD (
|
VERSION |
Information on Creation |
Table VERSION contains creation data for the payroll result, for example the Release and payroll program. |
PCL2 |
Update Information PCL2 |
Table PCL2 contains information about the last change access to a payroll result. |
VERSC |
Payroll Status Information |
Table VERSC contains organizational information about the payroll result. |
STATUS |
Status Indicator |
Table STATUS contains eight different status indicators. |
The system exports the data in these tables at the end of payroll processing in cluster tables in table PCL2 (RP cluster 2) using function EXPRT.The cluster tables are in a country-specific cluster, for example RD (
Payroll result, Germany
), on the database. In this way, the data is available for other processing steps, for example, evaluation.
Other internal tables are not exported after the payroll run but are deleted, since they are only required during the payroll run.
Table |
Short text |
Description |
|---|---|---|
IT |
Input Table |
During the payroll run table IT is filled with data that is to be processed. Data is transferred to table RT using operation ADDWTE. Table IT must be empty by the end of the payroll run or the personnel number is rejected. This is checked with the personnel calculation rule X070 (
|
OT |
Output Table |
Table OT only exists temporarily during processing. If a personnel calculation rule is called using the PIT function, a loop is performed for wage types from table IT. The results are written to table OT using the operation ADDWT. At the end of the loop, table IT is restructured from table OT. |
DT |
Difference Table |
Table DT is used to transfer retroactive accounting differences within retroactive chains. |
ORT |
Old Results Table |
Table ORT is table RT from the last payroll result (usually from the previous payroll period). Tables LRT and VORT are also formed from table ORT. |
LRT |
Last Results Table |
Table LRT is table RT from the last payroll result (usually from the previous payroll period). It is formed from table ORT but only contains the wage types that are relevant to the current period and required often. This is controlled using personnel calculation rule X006, which reads processing class 06. |
VORT |
Summarized ORT |
Table VORT is a version of table ORT in which certain splits are eliminated. |
Other internal tables only apply to certain Payroll country versions.
Taking the most important internal tables into account, the payroll workflow can be represented as follows:

Internal tables during the payroll run
Since the systems needs some of the data from the internal tables in the next payroll run it imports a previous results from the cluster tables using function IMPRT (
Import Interim and Final Results
) at the start of the payroll run.
The system uses function IMPRT L to import the payroll result from the previous period.
The system uses function IMPRT O to import the last previous result for the current period. During a retroactive accounting run this is, for example, the original result of this period.
The system transfers the tables of this imported result to the corresponding O tables.For example, to tables ORT (
Old results table
), OCRT (
Old cumulated results table
), or OARRRS (
Old arrears table
). These O tables are deleted after the payroll run.
You can see in the
payroll log
which data a certain internal table contains at a certain time during the payroll run. You can use the
editor for functions and operations
to specify which tables the system displays for a certain function in the payroll log. You can specify the relevant tables for customer-specific functions using
input
and
output parameters
.