!--a11y-->
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 Human Resources.* |
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 Human Resources.* |
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:
These three fields (BELNR, COUNTER, CATSHOURS) correspond to the fields with the same names in table CATSDB.
The transfer indicator specifies whether a record has already been transferred from an interface table to the corresponding target component. You can
A record is assigned a cancelation indicator when it has the processing status 60 (