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.

Was this article helpful?

Yes No

Related Articles

Leave A Comment?

You must be logged in to post a comment.