SAP Table CATSDB

CATS: Database Table for Time Sheet

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	*