Time Sheet Data (old)

Technical name: 0CATS_IS_1

Available as of OLTP Release: 4.0B

For BW 3.0B, this DataSource will be replaced by two DataSources, 0CA_TS_IS_1 (Time Sheet Data (Approved)) and 0CA_TS_IS_2 (Time Sheet Data (Released for Approval)).

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.