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:
Internal Tables for Payroll
|
Table |
Short text |
Description |
|
WPBP |
Work Place/Basic Pay |
Table WPBP is filled by the infotypes Actions (0000), Organizational Assignment (0001), Planned Working Time (0007), Basic Pay (0008), and Cost Distribution (0027). It contains important organizational and payment-relevant data, and different partial period parameters. For more information on table WBPB, see
|
|
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 Bank Transactions table (BT) of an employee, corresponds to a payment that was created in a payroll period for this employee. However, the employee is not necessarily the payment recipient of all payments. For more information on table BT, see |
|
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 Cost Distribution infotype (0027). |
|
C1 |
Cost Assignment from Different Infotypes |
Table C1 contains information about the individual cost assignment for individual wage types. You can use the infotype Recurring Payments/Deductions (0014) and Additional Payments (0015) to assign the wage types to a cost center that is different to the employee's master cost center. |
|
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 (Determine Employee Groupings) and operation MODIF (Set Employee Groupings). |
|
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.
Internal tables for Payroll that are not exported
|
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 (Cancel, if table is not empty). |
|
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.
