Appendix

Objective

After completing this lesson, you will be able to view additional information that supports the learning content.

Data Flow of Time Evaluation

Diagram illustrating data flow in time evaluation

The EXPRT function exports the time evaluation results to the database. The function can be inserted at any point in the schema.

Functions and Operations

Diagram of the functions and operations to process work tables

There are special functions and operations that you can use to process work tables.

The names of the operations and functions give an indication as to their use.

Tables in Cluster B1

NT1The NT1 table contains pointers to all time events that have not yet been processed. It is used for recalculation recognition and pair formation. The time events themselves are located in the TEVEN table.
NT2The NT2 table contains pointers to time events where there was an error in processing.
ERTThe ERT table contains all messages of the last time evaluation run.
NCTThe NCT table contains dates for days which require pair formation to be rerun entirely.
IFT1The IFT table is used only internally at SAP.
IFT2The IFT2 table is the interface table for incentive wages. It describes the changes made in the WST table (wage types and other documents) from cluster B2 to the time tickets already posted in incentive wages.

For more information, see the documentation about Integration with LogisticsPlant Data Collection in the Posting Time Tickets to Incentive Wages section.
STThe ST table contains selected balances that are downloaded for employees' information.
QTThe QT table contains a variety of information, which is redetermined daily, such as:
  • The date of the last day for which pair formation and generation was executed

  • The start and end of planned working time, the public holiday class, the day type, and the daily work schedule class of that day

Tables in Cluster B2

Basic data and work schedule

WPBPThe WPBP table contains data about the employee's work center and basic pay.
PSPThe PSP table contains the employee's personal work schedule data for each day.

Balances, wage types, and quota transactions

ZESThe ZES table contains the daily balances.
SALDOThe SALDO table contains all cumulated balances. The balances are cumulated in month-end processing from the TES table to the SALDO table.
ZKOThe ZKO table stores all quota transactions of the period.
ZLThe ZL table represents the interface between time evaluation and payroll. The existing time wage types are a result of time wage type selection using the Time Wage Type Selection Rule table (T510S).

The entries in the ZL table contain pointers to the following tables:
  • ALP: Different payment
  • C1: Cost distribution
  • AB: Absences

The selected time wage types are assigned an IFTYP, which is an indicator for payroll. It describes the origin of the wage type:
  • S: Planned working time
  • M: Overtime
  • A: Absence
ALPThe ALP table contains information about a different payment.
C1The C1 table contains information about a cost distribution (account assignment).
VSThe VS table contains variable balances which can be determined individually. The balances can be entered in the table using the ADDVD operation in time evaluation. They are then available for customer-specific evaluations.
CVSThe CVS table contains the cumulated balances from the VS table. The CVS table is filled automatically.
FEHLERThe FEHLER table stores all messages that were generated within time evaluation.
KNTAGRelevant for Germany only.

Automatic accrual of absence quotas

QTACCThe QTACC table contains the accrual entitlements that were generated by time evaluation on the relevant day of the accrual. You can double-click on a row to display detailed information about the generation.
QTBASEThe QTBASE table contains information about the base entitlement on which the calculation of the accrual entitlements is based. Any changes to the base entitlement within an accrual period are highlighted.
QTTRANSThe QTTRANS table indicates the status of the transfer pool for each day. The accrued 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 about the transfer pool and the transfer by double-clicking the appropriate row.
URLANThe URLAN table contains information on the updating of the Leave Entitlement infotype (0005).

Time pairs and time tickets

PTThe PT table contains the time pairs generated by pair formation. You require the table only if you use time recording terminals.
WSTThe WST table contains the generated time tickets.
CWSTThe CWST table contains the cumulated time tickets.
ATThe AT table is an assignment table that links time pairs and time tickets.

Time data

ABThe AB table contains all absences.
ANWESThe ANWES table contains all attendances that were entered in the Attendances infotype (2002).
VERTThe VERT table contains all substitutions that were entered in the Substitutions infotype (2003).
RUFBThe RUFB table contains all availabilities that were entered in the Availabilities infotype (2004).
MEHRThe MEHR table contains all overtime records that were entered in the Overtime infotype (2005).
ABWKONTIThe ABWKONTI table 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-from date is on at least one day of the current time evaluation period

ANWKONTIThe ANKONTI table contains all attendance approvals from the Attendance Quotas infotype (2007).
SKOThe SKO table contains all time transfer specifications that were entered in the Time Transfer Specifications infotype (2012).

Status information

BEZUGThis table contains the recalculation data for time evaluation and the time statement and retroactive accounting data for an external payroll system.