Time Sheet Data (Approved)

Technical name: CA_TS_IS_1

Technical Data

Type of DataSource

Transaction Data

Application Component

CA-TS

Available as of OLTP Release

SAP R/3 4.6C

Available as of PlugIn Release

2002.1

RemoteCube enabled

Yes

Use

This DataSource contains data that was entered using the Cross-Application Time Sheet (SAP CATS) and has been approved. The CA_TS_IS_2 DataSource is available for time sheet data that has not yet been approved but that has been released for approval.

If you implement Human Resources Management and want to obtain information about attendances/absences and wage types, you must first define the Time Type for Reporting in Customizing. For more information, see the Implementation Guide under Integration with Other SAP Components ® Business Information Warehouse ® Settings for Application-Specific DataSources ® Human Resources.

Delta Update

When transferring time sheet data to the Business Information Warehouse (BW), you must note the connection between the following data sources:

·        CA_TS_IS_1 (Time Sheet Data (Approved))

Documents are written in the SAP R/3 system for Time Sheets with status 30 (approved). The documents log the changes that have been made to data records.

Therefore, the SAP R/3 system can perform a delta update for this data source. The system only transfers newly approved data records and changes that have been made to existing data records. At the same time, the SAP R/3 system notes the date of the last delta transfer.

·        CA_TS_IS_2 (Time Sheet Data (Released for approval))

The SAP R/3 system does not write documents for Time Sheet data with status 20 (released for approval). This means that changes made to these data records are not logged.

Therefore, the SAP R/3 system always performs a complete transfer of data records that have been released for approval. The number of data records that need to be transferred usually remains constant because in the period between two transfers not only new data records are added but other data records are also approved. Therefore, system performance is not restricted.

To use this DataSource you must have implemented Support Package SAPKH46C32, or have made the relevant corrections in SAP Note 509592.

Linking DataSources

During the complete transfer of data records that have been released for approval, the system performs the following steps:

1.     Determines the time of the last delta transfer of approved data records.

2.     Transfers data records that have been released for approval if the last changed on date is further in the past than the determined date.

The system performs the following steps whilst transferring data records that have been changed in the source system after the transfer to the Business Information Warehouse:

...

       1.      Determines data records that were transferred as approved data records during the last delta transfer, but that have since been changed in the source system and released.

By changing data records in the source system, two new data records have been created. One data record with status 20 (released for approval) and one data record with status 50 (changed after approval).

       2.      Transfers the data record with status 50 with a negative sign to the BW so that the data record that was originally transferred is deleted.

       3.      Transfers the data record with status 20 with a positive sign to the BW so that the changed value can be included in the relevant analysis.

During the next delta transfer (after the data records that were changed in the source system have been approved), the system transfers the original value (status 60 (Canceled)) with a negative sign and the changed value with a positive sign as approved data records to the BW. During the next complete transfer of data records that have been released for approval, the system overwrites the data record with status 50.

This ensures that data in the BW always reflects the dataset in the database table for the Time Sheet (CATSDB) as accurately as possible. This is provided that you always transfer approved data records and data records that have been released for approval together, and in the same order.

...

       1.      Approved data records (DataSource CA_TS_IS_1)

       2.      Data records that have been released for approval (DataSource CA_TS_IS_2)

If this link does not suit your requirements, the Business Add-In (BAdI) CATSBW_CUST_ISOURCE enables you to change or delete it. Furthermore, this BAdI also offers you additional options for controlling the transfer of time sheet data. For more information, see the documentation on the BAdI.

Origin Fields of the Extract Structure

Field in the Extract Structure

Field description in the extract structure

Table of Origin

Field in Table of Origin

PERNR

Personnel number

CATSDB

PERNR_D

SKOSTL

Sender cost center

CATSDB

SKOSTL

LSTAR

Activity type

CATSDB

LSTAR

LSTNR

Service number

CATSDB

LSTNR

SEBELN

Sending purchase order

CATSDB

SEBELN

SEBELP

Sending purchase order item

CATSDB

SEBELP

RKOSTL

Receiver cost center

CATSDB

EKOSTL

POSID

Work breakdown structure (WBS) element

CATSDB

EPROJ

RAUFNR

Receiver order

CATSDB

EAUFNR

RNPLNR

Network number

CATSDB

NW_AUFNR

VORNR

Activity number, network, and standard network

CATSDB

CO_AUFPL

ELEMENT

Number of an activity element (work/external/costs)

CATSDB

CO_APLZL

RKDAUF

Receiver sales order

CATSDB

EKDAU

RKDPOS

Item number in receiver sales order

CATSDB

EKDPO

RPRZNR

Receiver business process

CATSDB

EPRZNR

REPTT

Time type for Reporting

CATSDB

AWART, LGART

REINR

Trip number

CATSDB

REINR

KOKRS

Controlling area

CATSDB

KOKRS

ARBPL

Work center

CATSDB

OBJEKTID

TCURR

Transaction currency

CATSDB

TWAER

WERKS

Plant

CATSDB

WERKS_D

AUTYP

Order category

CATSDB

AUFTYP

APNAM

User name of the approver

CATSDB

CATSAPNAM

BELNR

Document number for CATS transfer to BW

CATSDB

CATSBELNR

LTXA1

Short text

CATSDB

CATSSHORTT

PRICE

Price in transaction currency for transfer to BW

CATSDB

CATSPRICE

TASKCOMPONENT

Task component

CATSDB

CATSTASKCOMPONENT

TASKCOUNTER

CATS: Task counter

CATSDB

CATSTASKCOUNTER

TASKLEVEL

Task level

CATSDB

CATSTASKLEVEL

TASKTYPE

Task type

CATSDB

CATSTASKTYPE

WORKDATE

Pricing date

CATSDB

CATSDATE

WAERS

Currency key

CATSDB

WAERS

MEINH

Unit of measure for display

CATSDB

MEINH

ALP_AMOUNT

Wage type amount for payments

CATSDB

AUFKN, TRTGR, TRFST, PRAKN, PRAKZ

CATSHOURS

Hours

CATSDB

CATSHOURS

UNIT

Unit of measurement

CATSDB

MSEHI

CATSAMOUNT

CATS amount

CATSDB

CATSAMOUNT

CATSQUANTITY

Time sheet data: number with reference to unit of measurement

CATSDB

CATSNUMBER

STATKEYFIG

Statistical key figure

CATSDB

STAGR

STATUS

Processing status

CATSDB

CATSSTATUS