Time clocks and CATS

[Former Member]

Hi,

We have a requirement to capture clock-in/out from Genesis time clock system and process time in SAP. We want the generated time pair to be stored CATS database so that the mangers can edit / approve the time punches via CATS_APPR_LITE transaction

Since I am new to Time management I need help with the following:

1) What is the format to upload the data using SAP report RPTCC106 (loads table CC1TEV)

2) How is the data from CC1TEV then loaded to TEVEN table?

3) How is the time pair formed? Is it possible to store the paired form in CATS database instead of infotype 2011?

Thanks

[Former Member · Accepted solution]

1) What is the format to upload the data using SAP report RPTCC106 (loads table CC1TEV)

The format is the same as the structure of the CC1TEV table. Please look at this in the SE11/SE16 transaction

2) How is the data from CC1TEV then loaded to TEVEN table?

The standard SAP program SAPCDT45 is run to transfer data to TEVEN. In case any rows error out during the transfer, the information of these rows is stored in the table CC1REM. The CC1TEV table is completely purged of all information (correct or incorrect) on a non-test run of the SAPCDT45 program.

3) How is the time pair formed? Is it possible to store the paired form in CATS database instead of infotype 2011?

Time pairs are formed during time evaluation run only. Yes, it is possible to import the data into CATSDB (the central CATS table) through the use of a BAPI CATS0002. In this case, however, the CC1TEV and TEVEN tables will be rendered unusable. You will also have to create an attendance type for use with CATS.

[Former Member · Accepted solution]

Thanks for your input. I need a little more clarification on question # 3. So if we want the data to be imported to CATSDB then we cannot use the standard SAP programs RPTCC106 and SAPCDT45, is my assumption correct?

Also, i am assuming that for me to use CATSDB i will need the pari formation to be done in clock system and not in SAP.

Thanks

[Former Member · Accepted solution]

If you transfer to CATSDB, the following aspects apply:

1. Yes, storing data into CC1TEV and TEVEN will be redundant. So, yes, these programs do not need to be run;

2. Along with in-time and out-time, you will need to configure an attendance type (to allow transfer of data from the CATS system to the HR system. This data will then be stored in IT 2002;

3. Cost allocation will be done directly by the CATS system into CO, no additional activity needs to be taken in time evaluation to carry out such allocation;

4. Time pairs will still be formed during time evaluation (once data is transferred from CATS to HR) - but the pairs in this example will be formed by matching planned working times with the times of the attendance type in IT 2002.

[Former Member]

Did you overcome your issue ?

Are you fixed with using that clock system?