Technical name: 0CATS_IS_1
Available as of OLTP Release: 4.0B

For BW 3.0B, this DataSource will be replaced by two DataSources,
Use
This DataSource contains approved time sheet data.
Technical Data
|
Field in Extraction Structure |
Description |
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 element (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 |
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 |
Remarks on Delta Compatibility of the DataSource
This DataSource is able to deliver delta records.