CATS – Tables

CATSCO Cross-Application Time Sheet (CATS)- Transfer to CO 

CATSDB CATS- Database Table for Time Sheet (What you see in CADO is the view of table CATSDB)

CATSHR Cross-Application Time Sheet (CATS)- Transfer to HR 

CATSMM Cross-Application Time Sheet (CATS)- Transfer to MM 

CATSPM Cross-Application Time Sheet (CATS)- Transfer to PM/CS 

CATSPS Cross-Application Time Sheet (CATS)- Transfer to PS 

PTEX2000 – CATS transfer table/interface table to IT 2001/2002 (attendances/Absenses)

PTEX2010 – Interface Table for EE Remuneration Info. Infotype (2010)

PTEXDIR – human resources directory table

Creating custom fields in CATS

To add a few fields in main CATS data entry screen, add those fields in structure CI_CATSDB (This structure is customer extension of the CATSDB table). Assign these fields to the data entry profile.

1. In the IMG, go to Create Customer Fields, then Make Field Assignment,
which takes you to table TCAFI. Create your custom field there, and SAP
will assign a number. This Step will add the field to
the CATS.

2. In Create Customer Fields, go to Add customer fields to field selection. (These screens are confusing)
In the Data entry section, you need to enable your custom field in both the Influencing and Modifiable sections. “Modifiable” is a
global setting; click the radio button to allow input for “Additional
field 1″. Then go to the influencing screen, enter your CATS profile,
and allow input for “additional field 1”. So I suggest to make sure you
have this field enabled for input in both the influencing and modifiable

Now you should see the field in the CATS timesheet.

Integration of CATS with mobile phones, telephones, touch screen kiosks, biometrics

Collecting time data using the access cards and card readers are popular in today’s corporations. Some clients have requirements where they want to integrate a variety of devices – these include biometrics, touch screen kiosks, blackberry, mobile phones, PDA, telephones, RF terminals, etc. For example, some courier companies have implemented this (Canada Post). As SAP does not offer this functionality inherently – this can be achieved with some help from SAP technical consultants. There are also some companies which provide software to bridge this functionality (example: Timelink).

CATS – Transfer to PS

Transfer to Project System 
You can use report RCATSPS (Time Sheet: Transfer to Project System) to transfer time sheet data to Project System. The report generates confirmations for networks and, if necessary, goods movements for backflushes.

You can transfer time sheet data that is assigned the processing status 30 (Approved) or 60 (Canceled). The report transfers the data from the interface table CATSPS to Project System.

When the system generates confirmations for networks, it triggers activity allocation in Controlling at the same time.

The control key must specify that the operation may be confirmed. If it does not, the data is transferred to Controlling.

Transferring canceled data to Project System can adversely affect system performance. When the report transfers canceled records, it reads all the confirmations for the relevant operation for each cell that has been changed in the time sheet. The load on the system increases accordingly.

SAP recommends therefore that you

· Use only networks that have been created for a relatively short period

The more confirmations generated for a network, the poorer the report’s performance when canceling confirmations.

· Specify in the Number of tasks field that the report generates several tasks for each transfer, if you have performance problems

· You select the records you want to transfer by personnel number, period, network number or document number.

· If you do not want the current date to be the posting date of the transferred records, you can manually enter the posting date you require. You can also determine the posting date you require for cancellations.

· For optimum performance, you can distribute the data you want to transfer over several tasks. You specify how many tasks in the relevant field.

· If another user is processing a network when you run the report, the network is locked. You can enter a number of lock attempts for the report. The report then attempts to perform the transfer as many times as you have specified.

· If you want to enter services for an operation without this affecting the scheduling of the network, select Transfer without dates. The report then transfers the records without the actual start and finish.

· For a detailed list of the data that has been transferred, select the Log option.

· If you only want to check which data will be successfully transferred and if any data will generate errors, select Test run.

If you select the Log option, the system displays a log after the transfer is complete.

If the report was not able to post some of the records in Project System, it also generates an error pool. The records containing errors are flagged as transferred. You can postprocess them in Project System. Note however if you do this that the data in Project System is no longer consistent with the data in the Time Sheet.

CATS – Configuration

SAP’s official documentation on CATS configuration can be found at

To make configuration easier, refer to this excel

This excel contains gives a model of the accesses that needs to given for 3 different profiles – employee, manager and time admin.

Archiving of data from CATSDB: When the data becomes too huge, consider archiving the data. Though archiving is done by technical associates, functional associates would have to stipulate the timing of the archiving.

Some terms that are commonly used:
Yellow time: Unapproved time
Green time: Approved time

For additional Time sheet related questions refer to this link

CATS – for beginners

CATS means cross application timesheet which enables entries into time tables, the below link will help you in more detail.

SAP provides 4 such solutions:

CATS Classic:
CATS classic is the original user interface of the Cross-Application Time Sheet in the SAP system. It is particularly suited to users who also use the SAP system to perform other tasks. CATS classic is the most suitable user interface for entering working times for multiple personnel numbers, for example, by secretaries.

CATS Regular (ITS):
CATS regular (ITS) offers a similar data entry screen and comparable functions to CATS classic. However, this user interface has been optimized for use as an Employee Self-Service (ESS) application in a Web browser. In contrast to CATS classic, CATS regular (ITS) users only need a Web browser and not a SAP GUI for Windows. This makes CATS regular (ITS) the most suitable user interface for recording working times in the intranet or Internet.

CATS notebook can be used by sales people who are on site and do not have Internet connection. They enter their time sheet info offline into CATS notebook & when they are online, timesheet data is transferred to the server.

CATS for service providers enables you to specify basic data that is often valid for more than one day. You can then record task components (such as miles/kms driven, overtime, and so on)

CATS user interfaces

for user interfaces, please refer to the following link:

CATS Configuration

For configuration document, refer to the following link:

CATS – Transaction codes

To Customize CATS:

CAC1 : Maintain Profile 

CAC2 : Allocate Fields 

CAC3 : Def. Rej. Reasons 

CAC4 : Def. Auth. Groups 

CAC5 : Def. Cust. Fields 

CAC6 : Allowed Print Report

Working with CATS

CAT2 : Maintain Times  CAT3 : View Times  CATSXT : Times for SP  CATR : Reorg. Interf. Tables

Approving Times Entries


Transferring Time Entries

CATA : All entries (exc. MM)  CAT5 : .. to PS  CAT6 : .. to Time Mgt  CAT7 : .. to  CO  CAT9 : .. to PM / CS  CATM : .. to MM