Tables in Cluster B2

Basic data and work schedule

Table

 

WPBP

Table WPBP contains data on the employee’s work center and basic pay.

PSP

Table PSP contains data on the employee’s personal work schedule for each day.

Balances, wage types and quota transactions

Table

 

ZES

Table ZES contains daily balances.

SALDO

Table SALDO stores all cumulated balances. The balances are added from table TES to SALDO in month-end processing.

ZKO

All quota transactions of the period are stored in table ZKO.

ZL

Table ZL represents the interface between time evaluation and payroll. The existing time wage types have been derived via time wage type selection using the Time Wage Type Selection Rule table (T510S).

The entries in table ZL contain pointers to the following tables:

ALP - alternative payment

C1 - cost distribution

AB - absences

An IFTYP is specified for the selected time wage types. The IFTYP is an indicator for payroll. It describes the origin of the wage type:

S - planned work

M - overtime

A - absence

ALP

Table ALP contains the specifications on a different rate of payment

C1

Table C1 contains cost distribution specifications (account assignment).

VS

Table VS contains variable balances which can be defined by the user. These balances can be entered in the table during time evaluation using operation ADDVS, where they are available for customer-specific evaluations.

CVS

Table CVS contains the cumulated balances from table VS. Table CVS is filled automatically.

FEHLER

All messages generated during time evaluation are stored in table FEHLER.

For information on the various types of message, see Grouping Messages .

KNTAG

The string KNTAG shows whether or not the employee performs core night work. (Germany only)

Automatic accrual of absence quotas

Table

 

QTACC

Table QTACC contains the accrual entitlements that were generated by time evaluation on the relevant date of the accrual.

You can view detailed information on the generation by double-clicking the appropriate line.

QTBASE

Table QTBASE contains the information on the base entitlement that was used as a basis for calculating the accrual entitlements.

Any changes to the base entitlement within an accrual period are flagged accordingly.

QTTRANS

Table QTTRANS indicates the status of the transfer pool for each day. The cumulated entitlements are indicated until they have been transferred to the Absence Quotas infotype (2006) or until the entitlement has expired.

You can view detailed information on the transfer pool and on the transfer by double-clicking the appropriate line.

URLAN

Table URLAN contains information on the updating of the Leave Entitlement infotype (0005).

Time pairs and time tickets

Table

 

PT

Table PT contains the time pairs generated in pair formation. This table is only required if you use time recording systems.

WST

Table WST contains the generated time tickets

CWST

Table CWST contains the cumulated time tickets

AT

Table AT is an assignment table which links time pairs and time tickets.

Time data

Table

 

AB

Table AB contains all absences

ANWES

Table ANWES contains all attendances which have been entered using the Attendances infotype (2002).

VERT

Table VERT contains all substitutions entered in the Substitutions infotype (2003)

RUFB

Table RUFB contains all availability records entered in the Availability infotype (2004)

MEHR

Table MEHR contains all overtime data entered in the Overtime infotype (2005)

ABWKONTI

Table ABWKONTI contains all absence quotas from the Absence Quotas infotype (2006) that fulfill one of the following conditions:

  • Absence quotas that are valid on at least one day of the time evaluation period

  • Absence quotas that are deductible on at least one day of the time evaluation period and whose validity period is in the past

  • Absence quotas that are deductible on at least one day of the time evaluation period and whose validity period starts on a day in the current time evaluation period

ANWKONTI

Table ANKONTI contains all attendance approvals from the Attendance Quotas infotype (2007).

SKO

Table SKO contains all time transfer specifications recorded in the Time Transfer Specifications infotype (2012)

Status information

Table

 

BEZUG

This table shows the recalculation dates for time evaluation, the time statement and a third-party payroll system.