Time
Sheet Data (Approved)
Technical name: 0CA_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 0CA_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:
● 0CA_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.
● 0CA_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 0CA_TS_IS_1)
2. Data records that have been released for approval (DataSource 0CA_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 |
|
||||