SAP table CATSDB (CATS: Database Table for Time Sheet)

SAP table CATSDB has 2 primary key fields being MANDT,COUNTER.

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 T000 MANDT
COUNTER Counter for Records in Time Recording CHAR 12 0 CATSCOUNTE
PERNR Personnel Number NUMC 8 0 PERNR_D
WORKDATE Date DATS 8 0 CATSDATE
SKOSTL Sender Cost Center CHAR 10 0 * SKOSTL
LSTAR Activity Type CHAR 6 0 CSLA LSTAR
SEBELN Sending purchase order CHAR 10 0 * SEBELN
SEBELP Sending purchase order item NUMC 5 0 * SEBELP
SPRZNR Sender Business Process CHAR 12 0 * SPRZNR
LSTNR Activity Number CHAR 18 0 * ASNUM
RKOSTL Receiver Cost Center CHAR 10 0 * EKOSTL
RPROJ Receiver WBS Element NUMC 8 0 * EPROJ
RAUFNR Receiver Order CHAR 12 0 * EAUFNR
RNPLNR Network number CHAR 12 0 * NW_AUFNR
RAUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
RAPLZL General counter for order NUMC 8 0 * CO_APLZL
RKDAUF Receiver sales order CHAR 10 0 EKDAU
RKDPOS Item number in receiver sales order NUMC 6 0 EKDPO
RKSTR Receiver cost object CHAR 12 0 * EKSTR
RPRZNR Receiver business process CHAR 12 0 * EPRZNR
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
FUND Receiver Fund CHAR 10 0 * FM_EFONDS
FUNC_AREA Receiving Functional Area CHAR 16 0 * EFKTBER
GRANT_NBR Receiver Grant CHAR 20 0 * GM_GRANT_RECEIVER
S_FUND Sender fund CHAR 10 0 * FM_SFONDS
S_FUNC_AREA Sending Functional Area CHAR 16 0 * SFKTBER
S_GRANT_NBR Sender Grant CHAR 20 0 * GM_GRANT_SENDER
BUDGET_PD FM: Receiver Budget Period CHAR 10 0 * FM_EBUDGET_PERIOD
SBUDGET_PD FM: Sender Budget Period CHAR 10 0 * FM_SBUDGET_PERIOD
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
OVERTIMECAT Overtime Category CHAR 4 0 * CATS_OVERTIME_CATEGORY
WORK_ITEM_ID Work Item ID CHAR 10 0 /CPD/PFP_WORKITEM_ID
AWART Attendance or Absence Type CHAR 4 0 * AWART
LGART Wage Type CHAR 4 0 * LGART
KAPID Capacity ID NUMC 8 0 * KAPID
SPLIT Split number INT1 3 0 CY_SPLIT
REINR Trip Number NUMC 10 0 REINR
WABLNR Number of Material Document CHAR 10 0 MBLNR
VERSL Overtime Compensation Type CHAR 1 0 T555R VRSCH
WTART Tax area work center CHAR 4 0 * HRWRKAR
BWGRL Valuation basis CURR 13 2 CATSBWGRL
WAERS Currency Key CUKY 5 0 TCURC WAERS
AUFKZ Extra Pay Indicator CHAR 1 0 AUFKN
No extra pay: Valuation basis used as is
+ Valuation basis used as amount added
- Valuation basis used as amount deducted
TRFGR Pay Scale Group CHAR 8 0 * TRFGR
TRFST Pay Scale Level CHAR 2 0 * TRFST
PRAKN Premium Number CHAR 2 0 * PRAKN
PRAKZ Premium Indicator NUMC 4 0 PRAKZ
OTYPE Object Type CHAR 2 0 T778O OTYPE
PLANS Position NUMC 8 0 * PLANS
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
MEINH Unit of Measure for Display UNIT 3 0 T006 MEINH
TCURR Transaction Currency CUKY 5 0 TCURC TWAER
PRICE Price in Transaction Currency CURR 11 2 CATSPRICE
ARBID Object ID NUMC 8 0 OBJEKTID
WERKS Plant CHAR 4 0 T001W WERKS_D
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
HRCOSTASG Cost Accounting Variants CHAR 1 0 CATSHRCO
Assignment of personnel costs to the master cost center
A Assignment of personnel costs to the receiver object
B Assignment of personnel costs to sender cost center
C Pers. cost assgmt to sender; acct assgmt to activity type
D Activity allocation between master and sender cost center
E Acty alloc. master and sender; acct assgmt to activity type
HRKOSTL Cost Center CHAR 10 0 * CATSHRKOSTL
HRLSTAR Activity Type CHAR 6 0 CATSHRLSTAR
HRFUND Master Fund CHAR 10 0 * CATSHRFUND
HRFUNC_AREA Master Functional Area CHAR 16 0 * CATSHRFUNC_AREA
HRGRANT_NBR Master Grant CHAR 20 0 * CATSHRGRANT_NBR
BEMOT Accounting Indicator CHAR 2 0 * BEMOT
UNIT Unit of Measurement UNIT 3 0 * MSEHI
STATKEYFIG Statistical key figure CHAR 6 0 * STAGR
TASKTYPE Task Type CHAR 4 0 CATSTASKTYPE
TASKLEVEL Task Level CHAR 8 0 CATSTASKLEVEL
TASKCOMPONENT Task component CHAR 8 0 CATSTASKCOMPONENT
BUKRS Company Code CHAR 4 0 BUKRS
CPR_GUID Project GUID CHAR 32 0 CATS_CPR_GUID
CPR_EXTID External Project ID CHAR 24 0 CATS_CPR_EXTID
CPR_OBJGUID Object ID CHAR 32 0 CATS_CPR_OBJGUID
CPR_OBJGEXTID External ID of Project Subobject CHAR 24 0 CATS_CPR_OBJGEXTID
CPR_OBJTYPE cProjects Object Type CHAR 3 0 CATS_CPR_OBJTYPE
HRBUDGET_PD Master Budget Period CHAR 10 0 * CATSHR_BUDGET_PERIOD
ERSDA Created On DATS 8 0 CATS_ERSDA
ERSTM Time of Entry TIMS 6 0 CATS_CPUTM
ERNAM User Creating Record CHAR 12 0 CATS_ERNAM
LAEDA Date of Last Change DATS 8 0 CATS_LAEDA
LAETM Last Changed At TIMS 6 0 CATS_LAETM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
APNAM Name of person who approved data CHAR 12 0 CATSAPNAM
APDAT Date of Approval DATS 8 0 CATSAPDAT
WORKITEMID Work item ID NUMC 12 0 * SWW_WIID
LOGSYS Logical system CHAR 10 0 * LOGSYS
STATUS Processing status CHAR 2 0 CATSSTATUS
10 In process
20 Released for approval
30 Approved
40 Approval rejected
50 Changed after approval
60 Canceled
REFCOUNTER Reference Counter for Record to be Changed CHAR 12 0 CATSREFCOU
REASON Reason for rejection CHAR 4 0 * CATSREASON
BELNR Document no. CHAR 10 0 CATSBELNR
EXTSYSTEM Logical system of source document CHAR 10 0 * HR_AWSYS
EXTAPPLICATION External Application CHAR 5 0 HR_AWTYP
EXTDOCUMENTNO Document number CHAR 20 0 HR_AWKEY
TASKCOUNTER CATS: Task Counter CHAR 10 0 CATSTASKCOUNTER
CATSHOURS Hours QUAN 4 2 CATSHOURS
BEGUZ Start time TIMS 6 0 CATSBEGUZ
ENDUZ End time TIMS 6 0 CATSENDUZ
VTKEN Previous Day Indicator CHAR 1 0 VTKEN
ALLDF Record is for Full Day CHAR 1 0 ALLDF
OFMNW Remaining work QUAN 7 1 REMNW
PEDD Forecast finish date of operation from confirmation DATS 8 0 CO_PEDD
AUERU Partial/Final Confirmation CHAR 1 0 AUERU_VS
Partial confirmation
1 Automatic final confirmation
X Final confirmation
LTXA1 Short Text CHAR 40 0 CATSSHORTT
LONGTEXT Long Text CHAR 1 0 CATSLONGTE
ERUZU Indicator: Partial confirmation CHAR 1 0 ERUZU
CATSAMOUNT CATS Amount CURR 13 2 CATSAMOUNT
CATSQUANTITY Time Sheet: Number (Unit of Measure) QUAN 15 3 CATSNUMBER
DUMMY_INCL_EEW_PRS_CPILS Dummy function in length 1 CHAR 1 0 DUMMY

CATSDB foreign key relationships

Table Field Check Table Check Field
0 CATSDB KOKRS TKA01 Controlling Areas MANDT
1 CATSDB LSTAR CSLA Activity master MANDT
1 CATSDB LSTAR CSLA Activity master KOKRS
1 CATSDB LSTAR CSLA Activity master DATBI
0 CATSDB MANDT T000 Clients MANDT
1 CATSDB MEINH T006 Units of Measurement MANDT
1 CATSDB MEINH T006 Units of Measurement MSEHI
0 CATSDB OTYPE T778O Object Types MANDT
1 CATSDB TCURR TCURC Currency Codes MANDT
1 CATSDB TCURR TCURC Currency Codes WAERS
0 CATSDB VERSL T555R Overtime Compensation Types MANDT
0 CATSDB VERSL T555R Overtime Compensation Types VME
1 CATSDB WAERS TCURC Currency Codes MANDT
1 CATSDB WAERS TCURC Currency Codes WAERS
0 CATSDB WERKS T001W Plants/Branches WERKS