The Interface Tables for the Time Sheet
Definition
The interface tables for the Time Sheet are used to provide time sheet data for transfer to the corresponding target components.
Use
The system writes data that has the processing status 30 (
Approved
) or 60 (
Canceled
) from the database table
CATSDB
to the interface tables for the Time Sheet. This data is then available for transfer to the target components.
The system determines which are the relevant interface tables for the data based on the
working time attributes used when the record was created. Data that is entered with an attendance, for example, is written to the
Human Resources
interface table, PTEX2000. A record is often written to more than one interface table because it has been created with working time attributes that belong to different
target components
.
Structure
Human Resources
interface tables (PTEX2000, PTEX2010, and PTEXDIR)
PTEX2000 (
Interface Table for Attendances/Absences Infotypes (2002/2001)
) and PTEX2010 (
Interface Table for EE Remuneration Info. Infotype (2010)
) contain the time sheet data that you can transfer to
Human Resources
. The report generates infotype records for the
Attendances
(2002),
Absences
(2001), or
EE Remuneration Info
(2010) infotypes from the transferred records.
The important fields in the interface tables are:
AWKEY |
Object key |
Corresponds to the BELNR field in table CATSDB. |
STOKZ |
Cancelation indicator |
A record is assigned a cancelation indicator when it has the processing status 60 ( Canceled ) in table CATSDB. |
AWART |
Attendance/absence type |
Field in table PTEX2000. Specifies the attendance or absence type for the recorded hours. |
LGART |
Wage type |
Field in table PTEX2010. Contains the wage type for the record. |
DATUM1 |
Date |
Specifies the date on which the record was written to the interface table.* |
DATUM2 |
Date |
Specifies the date of the record's initial transfer to
|
DATUM3 |
Date |
Specifies the date on which the record was last accessed.* |
DATUM4 |
Date |
Specifies the date of the record's first successful transfer to
|
STATU2/STATU3 |
Status |
The system assigns a record in PTEX2000/2010 a log status for its first and last transfer. You use this status to see whether the transfer was successful or whether errors occurred. The system assigns the following statuses: 0 or blank: Record is new; it has not yet been transferred. 1: Record has been successfully transferred. 2: Errors occurred during transfer; the record could not be posted. 3: Record is locked. 4: A record has been canceled. The original and changed (canceled) record cancel each other out. They are not transferred but remain in the interface table. |
*The same is true of the
User
(UNAME1-4),
Time
(UZEIT1-4), and
Program
(PGMID1-4) fields.
Human Resources directory table PTEXDIR
Table PTEXDIR is a directory table. The system uses it to check whether the combination of
Logical system of source
(LOGSYS),
Reference procedure
(AWTYP), and
Object key
(AWKEY) is unique. If the combination is not unique, the system excludes the relevant records from the transfer. The system does not transfer data from table PTEXDIR to other components.
Interface tables for the other target components
The interface tables in
Controlling
(CATSCO),
Plant Maintenance/Customer Service
(CATSPM),
Project System
(CATSPS), and
Materials Management
(CATSMM) each contain the following fields, which are filled with time sheet data:
Document number (BELNR)
Counter (COUNTER)
Hours (CATSHOURS)
These three fields (BELNR, COUNTER, CATSHOURS) correspond to the fields with the same names in table CATSDB.
Transfer indicator (TRANSFER)
The transfer indicator specifies whether a record has already been transferred from an interface table to the corresponding target component. You can delete these records from the interface table.
Cancelation indicator (STOKZ)
A record is assigned a cancelation indicator when it has the processing status 60 ( Canceled ) in table CATSDB.