Start of Content Area

Object documentation The Interface Tables for the Time Sheet Locate the document in its SAP Library structure

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 delete these records from the interface table.

A record is assigned a cancelation indicator when it has the processing status 60 ( Canceled) in table CATSDB.

 

 

End of Content Area