Tables in Cluster B2Basic 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
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
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
|
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
|
VERT |
Table VERT contains all substitutions entered in the
|
RUFB |
Table RUFB contains all availability records entered in the
|
MEHR |
Table MEHR contains all overtime data entered in the
|
ABWKONTI |
Table ABWKONTI contains all absence quotas from the
|
ANWKONTI |
Table ANKONTI contains all attendance approvals from the
|
SKO |
Table SKO contains all time transfer specifications recorded in the
|
Status information
Table |
|
BEZUG |
This table shows the recalculation dates for time evaluation, the time statement and a third-party payroll system. |