Select language:

Object documentation Internal Tables for Payroll 

Definition

Tables that are used for storing data during the payroll run.

Use

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 Structure linkpersonnel calculation schema and using operations that are executed in Structure linkpersonnel calculation rules.

Structure

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 Structure linkPayment-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 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 Structure linkPayment-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 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

This graphic is explained in the accompanying text

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 Structure linkeditor 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.

 

Leaving content frame