Show TOC

Loading Data with KLK9

This schema can be used to transfer payroll result for each individual pay period, starting from a pre-determined first period, up to and including the period directly previous to the first SAP accounting period. Before execution of this schema, the following preconditions must be met:

Preconditions:

1. Master data for the personnel number for which payroll results are to be transferred must be entered. This includes infotype 0000, 0001, 0003, and 0224.
2. Data from non-SAP system is entered into table T558B, and T558C either via the IMG or by special programs which must be written by customers.
If arrear information is also to be transferred, they must be entered into the table T5K8C, separately.
3. With this release, it is assumed that the personnel has no prior payroll results exist in SAP.
You also have to fill the following two (2) tables with data coming from the non-SAP system. The purpose and table layout of these tables are described below:

Table T558B - Pay periods information

Specify the payroll periods and special payroll runs in table T558B for each personnel number for which results are to be transferred. (Please note that aside from regular payroll runs, only bonus accounting is currently supported). The SeqNr field in this table indicates the chronological sequence of payroll runs for the employee.

The entries in table T558B might be as follows:

PerNo|SeqNr|PayTy|PayID PayDt |PerMo|P.Yr.|P.Per.|Start End
7900 1 A 01.01.97
7900 2 01 97 01 01.01.97 31.01.97
7900 3 01 97 02 01.02.97 28.02.97
7900 4 A 10.01.97
7900 5 A 20.01.97
7900 6 01 97 0301.03.97 31.03.97

Please note that when using #TRN# type schema such as KLK9, when starting the payroll driver RPCALCK0, the system ignores the period specified in the selection screen, but instead reads the T558B table to form the payroll periods. The payroll driver checks whether the regular payroll periods specified in table T558B correspond to the employee#s data, recorded in the Personal Events and Organizational Assignment infotypes, and the periods in table T549Q for the employee#s payroll accounting area. If this is not the case, the employee is rejected. Please note that certain changes to master data, such as change of payroll subunit or legal person (i.e. Organizational Assignment infotype), and certain events (T530-PERSP = #X#) can lead to splits in the payroll period. Therefore, if the system rejects the employee during the comparison with master data, a possible reason may be that the old system used a different payroll logic.

For regular pay runs (PayTy = space), entries must be made in the PerMo, P.Yr., P.Per., Start, and End fields (assign payroll periods from T549Q). The PayDt field is optional. If this field is blank, the system uses the payment date from table T549S, otherwise, the date entered will be used.

For bonus pay runs (PayTy = #A#), the only required field is the PayDt field, indicating the date of bonus accounting.

Table T558C - Wage types information

For each payroll period, enter the wage types from T558B to be transferred in table T558C. The PerNo and SeqNr fields are the keys which link table T588B and T588C. The field KeyDate is used to assign the split indicators for the date to the wage types belonging to the payroll run (WPBP splits and country-specific splits). If this field is blank, the system positions itself on the last split period. The field Molga must be set to #07#, and is checked against the CALMOLGA during the payroll run.

The entries in table T558B might be as follows:

PerNo SeqNr Molga Lgart KeyDate Amt/UnitNumber Amount
7900 1 07 /101 500.00
7900 2 07 /101 1,750.00
7900 2 07 /102 1,500.00
7900 3 07 /101 2,000.00
7900 3 07 /102 1,800.00

In the example above, the $500.00 entry with sequence number 1 corresponds to the bonus run for 01.01.1997. The $1,750.00 and $1,500.00 entries, with sequence number 2, correspond to the regular payroll run for period 01.1997. The $2,000.00 and $1,800.00 entries, with sequence number 3, correspond to the regular payroll run for period 02.1997.

If arrears information is to be transferred, table T5K8C must also be filled, in addition to the T558B and T558C tables.

Table T5K8C - Wage types information

For each employee#s payroll period defined in table T558B, enter the arrears data to be transferred in table T5K8C. The PerNo and SeqNr fields link table T558B and T5K8C. The TblTy field indicates the type of record (Set this field to #A# for arrears). For arrears records, the CumTy, TxPtr, and KeyDate fields are ignored.

The entries in table T5K8C might be as follows:

PerNo|SeqNr|TblTy|CumTy|TxPtr|Lgart|KeyDate|Amt/Unit|Number|Amount
7900 | 1 | A | | |/110 | | | |-234.50
7905 | 3 | A | | |/106 | | | |-150.00

After you run the KLK9 schema, a new payroll result will be created, populating the following tables:

1. The RT table is populated with correct split indicators.
2. The CRT table is cumulated.
3. The TCRT table is cumulated.
4. The ARRS table is populated.