SAP Table CATSDB

CATS: Database Table for Time Sheet

CATSDB (CATS: Database Table for Time Sheet) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CATSDB to other SAP tables.

CATSDB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
COUNTER Counter for Records in Time Recording CATSCOUNTE CHAR 12 0
PERNR Personnel Number PERNR_D NUMC 8 0
WORKDATE Date CATSDATE DATS 8 0
SKOSTL Sender Cost Center SKOSTL CHAR 10 0
LSTAR Activity Type LSTAR CSLA CHAR 6 0
SEBELN Sending purchase order SEBELN CHAR 10 0
SEBELP Sending purchase order item SEBELP NUMC 5 0
SPRZNR Sender Business Process SPRZNR CHAR 12 0
LSTNR Activity Number ASNUM CHAR 18 0
RKOSTL Receiver Cost Center EKOSTL CHAR 10 0
RPROJ Receiver WBS element EPROJ NUMC 8 0
RAUFNR Receiver Order EAUFNR CHAR 12 0
RNPLNR Network number NW_AUFNR CHAR 12 0
RAUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
RAPLZL General counter for order CO_APLZL NUMC 8 0
RKDAUF Receiver sales order EKDAU CHAR 10 0
RKDPOS Item number in receiver sales order EKDPO NUMC 6 0
RKSTR Receiver cost object EKSTR CHAR 12 0
RPRZNR Receiver business process EPRZNR CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
FUND Receiver fund FM_EFONDS CHAR 10 0
FUNC_AREA Receiving Functional Area EFKTBER CHAR 16 0
GRANT_NBR Receiver Grant GM_GRANT_RECEIVER CHAR 20 0
S_FUND Sender fund FM_SFONDS CHAR 10 0
S_FUNC_AREA Sending Functional Area SFKTBER CHAR 16 0
S_GRANT_NBR Sender Grant GM_GRANT_SENDER CHAR 20 0
BUDGET_PD FM: Receiver Budget Period FM_EBUDGET_PERIOD CHAR 10 0
SBUDGET_PD FM: Sender Budget Period FM_SBUDGET_PERIOD CHAR 10 0
AWART Attendance or Absence Type AWART CHAR 4 0
LGART Wage Type LGART CHAR 4 0
KAPID Capacity ID KAPID NUMC 8 0
SPLIT Split number CY_SPLIT INT1 3 0
REINR Trip Number REINR NUMC 10 0
WABLNR Number of Material Document MBLNR CHAR 10 0
VERSL Overtime Compensation Type VRSCH T555R CHAR 1 0
WTART Tax area work center HRWRKAR CHAR 4 0
BWGRL Valuation basis CATSBWGRL CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
AUFKZ Extra Pay Indicator AUFKN CHAR 1 0
NULL No extra pay: Valuation basis used as is
- Valuation basis used as amount deducted
+ Valuation basis used as amount added
TRFGR Pay Scale Group TRFGR CHAR 8 0
TRFST Pay Scale Level TRFST CHAR 2 0
PRAKN Premium Number PRAKN CHAR 2 0
PRAKZ Premium Indicator PRAKZ NUMC 4 0
OTYPE Object Type OTYPE T778O CHAR 2 0
PLANS Position PLANS NUMC 8 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
MEINH Unit of Measure for Display MEINH T006 UNIT 3 0
TCURR Transaction Currency TWAER TCURC CUKY 5 0
PRICE Price in Transaction Currency CATSPRICE CURR 11 2
ARBID Object ID OBJEKTID NUMC 8 0
WERKS Plant WERKS_D T001W CHAR 4 0
AUTYP Order category AUFTYP NUMC 2 0
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
HRCOSTASG Cost Accounting Variants CATSHRCO CHAR 1 0
NULL 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 CATSHRKOSTL CHAR 10 0
HRLSTAR Activity Type CATSHRLSTAR CHAR 6 0
HRFUND Master Fund CATSHRFUND CHAR 10 0
HRFUNC_AREA Master Functional Area CATSHRFUNC_AREA CHAR 16 0
HRGRANT_NBR Master Grant CATSHRGRANT_NBR CHAR 20 0
BEMOT Accounting Indicator BEMOT CHAR 2 0
UNIT Unit of Measurement MSEHI UNIT 3 0
STATKEYFIG Statistical key figure STAGR CHAR 6 0
TASKTYPE Task Type CATSTASKTYPE CHAR 4 0
TASKLEVEL Task Level CATSTASKLEVEL CHAR 8 0
TASKCOMPONENT Task component CATSTASKCOMPONENT CHAR 8 0
BUKRS Company Code BUKRS CHAR 4 0
CPR_GUID Project GUID CATS_CPR_GUID CHAR 32 0
CPR_EXTID External Project ID CATS_CPR_EXTID CHAR 24 0
CPR_OBJGUID Object ID CATS_CPR_OBJGUID CHAR 32 0
CPR_OBJGEXTID External ID of Project Subobject CATS_CPR_OBJGEXTID CHAR 24 0
CPR_OBJTYPE cProjects Object Type CATS_CPR_OBJTYPE CHAR 3 0
HRBUDGET_PD Master Budget Period CATSHR_BUDGET_PERIOD CHAR 10 0
ERSDA Created on CATS_ERSDA DATS 8 0
ERSTM Time of Entry CATS_CPUTM TIMS 6 0
ERNAM User Who Created Data Record CATS_ERNAM CHAR 12 0
LAEDA Date of Last Change CATS_LAEDA DATS 8 0
LAETM Time of Last Change CATS_LAETM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
APNAM Name of person who approved data CATSAPNAM CHAR 12 0
APDAT Date of Approval CATSAPDAT DATS 8 0
WORKITEMID Work item ID SWW_WIID NUMC 12 0
LOGSYS Logical system LOGSYS CHAR 10 0
STATUS Processing status CATSSTATUS CHAR 2 0
10 In process
20 Released for approval
30 Approved
40 Approval rejected
50 Changed after approval
60 Cancelled
REFCOUNTER Reference Counter for Record to be Changed CATSREFCOU CHAR 12 0
REASON Reason for rejection CATSREASON CHAR 4 0
BELNR Document Number CATSBELNR CHAR 10 0
EXTSYSTEM Logical system of source document HR_AWSYS CHAR 10 0
EXTAPPLICATION External Application HR_AWTYP CHAR 5 0
EXTDOCUMENTNO Document number HR_AWKEY CHAR 20 0
TASKCOUNTER CATS: Task Counter CATSTASKCOUNTER CHAR 10 0
CATSHOURS Hours CATSHOURS QUAN 4 2
BEGUZ Start time CATSBEGUZ TIMS 6 0
ENDUZ End time CATSENDUZ TIMS 6 0
VTKEN Previous Day Indicator VTKEN CHAR 1 0
X Yes
NULL No
ALLDF Record is for Full Day ALLDF CHAR 1 0
X Yes
NULL No
OFMNW Remaining work REMNW QUAN 7 1
PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8 0
AUERU Partial/Final Confirmation AUERU_VS CHAR 1 0
NULL Partial confirmation
X Final confirmation
1 Automatic final confirmation
LTXA1 Short Text CATSSHORTT CHAR 40 0
LONGTEXT Long Text CATSLONGTE CHAR 1 0
X Yes
NULL No
ERUZU Indicator: Partial confirmation ERUZU CHAR 1 0
X Yes
NULL No
CATSAMOUNT CATS Amount CATSAMOUNT CURR 13 2
CATSQUANTITY Time Sheet: Number (Unit of Measure) CATSNUMBER QUAN 15 3
ZCPR_GUID cProjects: Projekt-GUID ZCPR_GUID CHAR 32 0
ZCPR_EXTID cProjects: Project Number ZCPR_EXTID CHAR 24 0
ZCPR_OBJGUID cProjects: Object GUID ZCPR_OBJGUID CHAR 32 0
ZCPR_OBJGEXTID cProjects: Object Name ZCPR_OBJGEXTID CHAR 24 0
ZCPR_OBJTYPE cProjects: Object Type ZCPR_OBJTYPE CHAR 3 0
YYRPM_REL_TYPE Relation Type Y23_RPM_REL_TYPE CHAR 3 0
YYRPM_PROJ_GUID Project GUID (xRPM) Y23_RPM_PROJ_GUID CHAR 32 0
YYRPM_PROJ_ID Project ID (ext.) Y23_RPM_PROJ_ID CHAR 24 0
YYRPM_RES_GUID Resource GUID (xRPM) Y23_RPM_RES_GUID CHAR 32 0
YYRPM_RES_ID Resource ID (ext.) Y23_RPM_RES_ID CHAR 24 0
YYRPM_ROLE_GUID Role GUID (xRPM) Y23_RPM_ROLE_GUID CHAR 32 0
YYRPM_ROLE_ID Role ID (ext.) Y23_RPM_ROLE_ID CHAR 24 0
YYRPM_TASK_GUID Task GUID (xRPM) Y23_RPM_TASK_GUID CHAR 32 0
YYRPM_TASK_ID Task ID Y23_RPM_TASK_ID CHAR 24 0
Z_PRS_OFFSHORE Professional Services: Delivery Type Z_PRS_OFFSHORE CHAR 1 0
1 Onshore
2 Nearshore
3 Offshore
Z_PRS_BILL_FLAG Professional Services: Billable/Non-Billable Z_PRS_BILLABLE_FLAG CHAR 1 0
X Yes
NULL No
Z_PRS_COUNTRY Country Key LAND1 CHAR 3 0
Z_PRS_CHARGELEVL Professional Services: Charge Level Z_PRS_CHARGELEVEL CHAR 2 0
L1 Trainee Level
L2 Junior Level
L3 Specialist Level
L4 Senior Level
L5 Partner Level

CATSDB foreign key relationships

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