SAP table CATSPM (Cross-Application Time Sheet (CATS): Transfer to PM/CS)
SAP table CATSPM has 3 primary key fields being MANDT,COUNTER,STOKZ.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
*
MANDT
COUNTER
Counter for Records in Time Recording
CHAR
12
0
CATSCOUNTE
STOKZ
Indicator: Document was reversed
CHAR
1
0
CO_STOKZ
PERNR
Personnel Number
NUMC
8
0
PERNR_D
WORKDATE
Date
DATS
8
0
CATSDATE
RAUFNR
Receiver Order
CHAR
12
0
AUFK
EAUFNR
RAUFPL
Routing number of operations in the order
NUMC
10
0
CO_AUFPL
RAPLZL
General counter for order
NUMC
8
0
*
CO_APLZL
KAPID
Capacity ID
NUMC
8
0
*
KAPID
SPLIT
Split number
INT1
3
0
CY_SPLIT
ARBID
Object ID
NUMC
8
0
OBJEKTID
WERKS
Plant
CHAR
4
0
*
WERKS_D
CATSHOURS
Hours
QUAN
4
2
CATSHOURS
MEINH
Unit of Measure for Display
UNIT
3
0
*
MEINH
OFMNW
Remaining work
QUAN
7
1
REMNW
PEDD
Forecast finish date of operation from confirmation
DATS
8
0
CO_PEDD
LSTAR
Activity Type
CHAR
6
0
*
LSTAR
BEGUZ
Start time
TIMS
6
0
CATSBEGUZ
ENDUZ
End time
TIMS
6
0
CATSENDUZ
LTXA1
Confirmation text
CHAR
40
0
CO_RTEXT
AUERU
Partial/Final Confirmation
CHAR
1
0
AUERU_VS
Possible values
Partial confirmation
1
Automatic final confirmation
X
Final confirmation
BELNR
Document no.
CHAR
10
0
CATSBELNR
TRANSFER
Data Transferred to the Target Component
CHAR
1
0
CATSTRANSF
LGART
Wage Type
CHAR
4
0
*
LGART
PRICE
Price in Transaction Currency
CURR
11
2
CATSPRICE
TCURR
Transaction Currency
CUKY
5
0
*
TWAER
ERUZU
Indicator: Partial confirmation
CHAR
1
0
ERUZU
ERSDA
Created On
DATS
8
0
ERSDA
ERSTM
Time of Entry
TIMS
6
0
CATS_CPUTM
BEMOT
Accounting Indicator
CHAR
2
0
*
BEMOT
KOKRS
Controlling Area
CHAR
4
0
*
KOKRS
SKOSTL
Sender Cost Center
CHAR
10
0
*
SKOSTL
FM_SPLIT_FLG
Line Is Result of Account Assignment Drilldown
CHAR
1
0
FMSP_SPLIT_RESULT_FLAG
CATSPM foreign key relationships
Table
Field
Check Table
Check Field
0 CATSPM
RAUFNR
AUFK
Order master data
AUFNR