Menu

SAP Table CATSDB

CATS: Database Table for Time Sheet

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table CATSDB (CATS: Database Table for Time Sheet) is a standard table in SAP ERP. It belongs to the package CATS.

Technical Information

Table CATSDB
Short Text CATS: Database Table for Time Sheet
Package CATS
Table Type Transparent Table

Fields for Table CATSDB

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
COUNTER Counter for Records in Time Recording CATSCOUNTE CHAR 12
PERNR Personnel Number PERNR_D NUMC 8
WORKDATE Date CATSDATE DATS 8
SKOSTL Sender Cost Center SKOSTL CHAR 10 *
LSTAR Activity Type LSTAR CHAR 6 CSLA
SEBELN Sending purchase order SEBELN CHAR 10 *
SEBELP Sending purchase order item SEBELP NUMC 5 *
SPRZNR Sender Business Process SPRZNR CHAR 12 *
LSTNR Activity Number ASNUM CHAR 18 *
RKOSTL Receiver Cost Center EKOSTL CHAR 10 *
RPROJ Receiver WBS element EPROJ NUMC 8 *
RAUFNR Receiver Order EAUFNR CHAR 12 *
RNPLNR Network number NW_AUFNR CHAR 12 *
RAUFPL Routing number of operations in the order CO_AUFPL NUMC 10
RAPLZL General counter for order CO_APLZL NUMC 8 *
RKDAUF Receiver sales order EKDAU CHAR 10 *
RKDPOS Item number in receiver sales order EKDPO NUMC 6 *
RKSTR Receiver cost object EKSTR CHAR 12 *
RPRZNR Receiver business process EPRZNR CHAR 12 *
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10
FUND Receiver fund FM_EFONDS CHAR 10 *
FUNC_AREA Receiving Functional Area EFKTBER CHAR 16 *
GRANT_NBR Receiver Grant GM_GRANT_RECEIVER CHAR 20
S_FUND Sender fund FM_SFONDS CHAR 10 *
S_FUNC_AREA Sending Functional Area SFKTBER CHAR 16 *
S_GRANT_NBR Sender Grant GM_GRANT_SENDER CHAR 20
BUDGET_PD FM: Receiver Budget Period FM_EBUDGET_PERIOD CHAR 10 *
SBUDGET_PD FM: Sender Budget Period FM_SBUDGET_PERIOD CHAR 10 *
AWART Attendance or Absence Type AWART CHAR 4 *
LGART Wage Type LGART CHAR 4 *
KAPID Capacity ID KAPID NUMC 8 *
SPLIT Split number CY_SPLIT INT1 3
REINR Trip Number REINR NUMC 10
WABLNR Number of Material Document MBLNR CHAR 10
VERSL Overtime Compensation Type VRSCH CHAR 1 T555R
WTART Tax area work center HRWRKAR CHAR 4 *
BWGRL Valuation basis CATSBWGRL CURR 13
WAERS Currency Key WAERS CUKY 5 TCURC
AUFKZ Extra Pay Indicator AUFKN CHAR 1
TRFGR Pay Scale Group TRFGR CHAR 8 *
TRFST Pay Scale Level TRFST CHAR 2 *
PRAKN Premium Number PRAKN CHAR 2 *
PRAKZ Premium Indicator PRAKZ NUMC 4
OTYPE Object Type OTYPE CHAR 2 T778O
PLANS Position PLANS NUMC 8 *
KOKRS Controlling Area KOKRS CHAR 4 TKA01
MEINH Unit of Measure for Display MEINH UNIT 3 T006
TCURR Transaction Currency TWAER CUKY 5 TCURC
PRICE Price in Transaction Currency CATSPRICE CURR 11
ARBID Object ID OBJEKTID NUMC 8
WERKS Plant WERKS_D CHAR 4 T001W
AUTYP Order category AUFTYP NUMC 2
HRCOSTASG Cost Accounting Variants CATSHRCO CHAR 1
HRKOSTL Cost Center CATSHRKOSTL CHAR 10 *
HRLSTAR Activity Type CATSHRLSTAR CHAR 6 *
HRFUND Master Fund CATSHRFUND CHAR 10 *
HRFUNC_AREA Master Functional Area CATSHRFUNC_AREA CHAR 16 *
HRGRANT_NBR Master Grant CATSHRGRANT_NBR CHAR 20
BEMOT Accounting Indicator BEMOT CHAR 2 *
UNIT Unit of Measurement MSEHI UNIT 3 *
STATKEYFIG Statistical key figure STAGR CHAR 6 *
TASKTYPE Task Type CATSTASKTYPE CHAR 4
TASKLEVEL Task Level CATSTASKLEVEL CHAR 8
TASKCOMPONENT Task component CATSTASKCOMPONENT CHAR 8
BUKRS Company Code BUKRS CHAR 4 *
CPR_GUID Project GUID CATS_CPR_GUID CHAR 32
CPR_EXTID External Project ID CATS_CPR_EXTID CHAR 24
CPR_OBJGUID Object ID CATS_CPR_OBJGUID CHAR 32
CPR_OBJGEXTID External ID of Project Subobject CATS_CPR_OBJGEXTID CHAR 24
CPR_OBJTYPE cProjects Object Type CATS_CPR_OBJTYPE CHAR 3
HRBUDGET_PD Master Budget Period CATSHR_BUDGET_PERIOD CHAR 10 *
ERSDA Created on CATS_ERSDA DATS 8
ERSTM Time of Entry CATS_CPUTM TIMS 6
ERNAM User Who Created Data Record CATS_ERNAM CHAR 12
LAEDA Date of Last Change CATS_LAEDA DATS 8
LAETM Time of Last Change CATS_LAETM TIMS 6
AENAM Name of Person Who Changed Object AENAM CHAR 12
APNAM Name of person who approved data CATSAPNAM CHAR 12
APDAT Date of Approval CATSAPDAT DATS 8
WORKITEMID Work item ID SWW_WIID NUMC 12 *
LOGSYS Logical system LOGSYS CHAR 10 *
STATUS Processing status CATSSTATUS CHAR 2
REFCOUNTER Reference Counter for Record to be Changed CATSREFCOU CHAR 12
REASON Reason for rejection CATSREASON CHAR 4 *
BELNR Document Number CATSBELNR CHAR 10
EXTSYSTEM Logical system of source document HR_AWSYS CHAR 10 *
EXTAPPLICATION External Application HR_AWTYP CHAR 5
EXTDOCUMENTNO Document number HR_AWKEY CHAR 20
TASKCOUNTER CATS: Task Counter CATSTASKCOUNTER CHAR 10
Include Structure: CATS_CELL
CATSHOURS Hours CATSHOURS QUAN 4
BEGUZ Start time CATSBEGUZ TIMS 6
ENDUZ End time CATSENDUZ TIMS 6
VTKEN Previous Day Indicator VTKEN CHAR 1
ALLDF Record is for Full Day ALLDF CHAR 1
OFMNW Remaining work REMNW QUAN 7
PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8
AUERU Partial/Final Confirmation AUERU_VS CHAR 1
LTXA1 Short Text CATSSHORTT CHAR 40
LONGTEXT Long Text CATSLONGTE CHAR 1
ERUZU Indicator: Partial confirmation ERUZU CHAR 1
CATSAMOUNT CATS Amount CATSAMOUNT CURR 13
CATSQUANTITY Time Sheet: Number (Unit of Measure) CATSNUMBER QUAN 15
Z_PRS_COUNTRY Country Key LAND1 CHAR 3 *