CATSDB - CATS: Database Table for Time Sheet

CATS: Database Table for Time Sheet information is stored in SAP table CATSDB.
It is part of development package CATS in software component CA-TS. This development package consists of objects that can be grouped under "".

Fields for table CATSDB

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CATS_KEY	0
MANDT	Client	X	MANDT	CLNT	6	T000
COUNTER	Counter for Records in Time Recording	X	CATSCOUNTE	CHAR	24
.INCLUDE				CATS_SEC_K	0
PERNR	Personnel Number		PERNR_D	NUMC	16
WORKDATE	Date		CATSDATE	DATS	16
.INCLUDE				CATS_OBJ	0
SKOSTL	Sender Cost Center		SKOSTL	CHAR	20	*
LSTAR	Activity Type		LSTAR	CHAR	12	CSLA
SEBELN	Sending purchase order		SEBELN	CHAR	20	*
SEBELP	Sending purchase order item		SEBELP	NUMC	10	*
SPRZNR	Sender Business Process		SPRZNR	CHAR	24	*
LSTNR	Activity Number		ASNUM	CHAR	36	*
RKOSTL	Receiver Cost Center		EKOSTL	CHAR	20	*
RPROJ	Receiver WBS Element		EPROJ	NUMC	16	*
RAUFNR	Receiver Order		EAUFNR	CHAR	24	*
RNPLNR	Network number		NW_AUFNR	CHAR	24	*
RAUFPL	Routing number of operations in the order		CO_AUFPL	NUMC	20
RAPLZL	General counter for order		CO_APLZL	NUMC	16	*
RKDAUF	Receiver sales order		EKDAU	CHAR	20
RKDPOS	Item number in receiver sales order		EKDPO	NUMC	12
RKSTR	Receiver cost object		EKSTR	CHAR	24	*
RPRZNR	Receiver business process		EPRZNR	CHAR	24	*
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
FUND	Receiver Fund		FM_EFONDS	CHAR	20	*
FUNC_AREA	Receiving Functional Area		EFKTBER	CHAR	32	*
GRANT_NBR	Receiver Grant		GM_GRANT_RECEIVER	CHAR	40	*
S_FUND	Sender fund		FM_SFONDS	CHAR	20	*
S_FUNC_AREA	Sending Functional Area		SFKTBER	CHAR	32	*
S_GRANT_NBR	Sender Grant		GM_GRANT_SENDER	CHAR	40	*
BUDGET_PD	FM: Receiver Budget Period		FM_EBUDGET_PERIOD	CHAR	20	*
SBUDGET_PD	FM: Sender Budget Period		FM_SBUDGET_PERIOD	CHAR	20	*
SERVICE_DOC_TYPE	Service Document Type		FCO_SRVDOC_TYPE	CHAR	8
SERVICE_DOC_ID	Service Document ID		FCO_SRVDOC_ID	CHAR	20
SERVICE_DOC_ITEM_ID	Service Document Item ID		FCO_SRVDOC_ITEM_ID	NUMC	12
OVERTIMECAT	Overtime Category		CATS_OVERTIME_CATEGORY	CHAR	8	*
.INCLUDE				/CPD/S_SS_PROJ_INCLUDE	0
WORK_ITEM_ID	Work Item ID		/CPD/PFP_WORKITEM_ID	CHAR	20
.INCLUDE				CATS_INCL1	0
AWART	Attendance or Absence Type		AWART	CHAR	8	*
LGART	Wage Type		LGART	CHAR	8	*
KAPID	Capacity ID		KAPID	NUMC	16	*
SPLIT	Split number		CY_SPLIT	INT1	1
REINR	Trip Number		REINR	NUMC	20
WABLNR	Number of Material Document		MBLNR	CHAR	20
VERSL	Overtime Compensation Type		VRSCH	CHAR	2	T555R
WTART	Tax area work center		HRWRKAR	CHAR	8	*
BWGRL	Valuation basis		CATSBWGRL	CURR	7
WAERS	Currency Key		WAERS	CUKY	10	TCURC
AUFKZ	Extra Pay Indicator		AUFKN	CHAR	2
TRFGR	Pay Scale Group		TRFGR	CHAR	16	*
TRFST	Pay Scale Level		TRFST	CHAR	4	*
PRAKN	Premium Number		PRAKN	CHAR	4	*
PRAKZ	Premium Indicator		PRAKZ	NUMC	8
OTYPE	Object Type		OTYPE	CHAR	4	T778O
PLANS	Position		PLANS	NUMC	16	*
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
MEINH	Unit of Measure for Display		MEINH	UNIT	6	T006
TCURR	Transaction Currency		TWAER	CUKY	10	TCURC
PRICE	Price in Transaction Currency		CATSPRICE	CURR	6
ARBID	Object ID		OBJEKTID	NUMC	16
WERKS	Plant		WERKS_D	CHAR	8	T001W
AUTYP	Order category		AUFTYP	NUMC	4
HRCOSTASG	Cost Accounting Variants		CATSHRCO	CHAR	2
HRKOSTL	Cost Center		CATSHRKOSTL	CHAR	20	*
HRLSTAR	Activity Type		CATSHRLSTAR	CHAR	12
HRFUND	Master Fund		CATSHRFUND	CHAR	20	*
HRFUNC_AREA	Master Functional Area		CATSHRFUNC_AREA	CHAR	32	*
HRGRANT_NBR	Master Grant		CATSHRGRANT_NBR	CHAR	40	*
BEMOT	Accounting Indicator		BEMOT	CHAR	4	*
UNIT	Unit of Measurement		MSEHI	UNIT	6	*
STATKEYFIG	Statistical key figure		STAGR	CHAR	12	*
TASKTYPE	Task Type		CATSTASKTYPE	CHAR	8
TASKLEVEL	Task Level		CATSTASKLEVEL	CHAR	16
TASKCOMPONENT	Task component		CATSTASKCOMPONENT	CHAR	16
BUKRS	Company Code		BUKRS	CHAR	8
CPR_GUID	Project GUID		CATS_CPR_GUID	CHAR	64
CPR_EXTID	External Project ID		CATS_CPR_EXTID	CHAR	48
CPR_OBJGUID	Object ID		CATS_CPR_OBJGUID	CHAR	64
CPR_OBJGEXTID	External ID of Project Subobject		CATS_CPR_OBJGEXTID	CHAR	48
CPR_OBJTYPE	cProjects Object Type		CATS_CPR_OBJTYPE	CHAR	6
HRBUDGET_PD	Master Budget Period		CATSHR_BUDGET_PERIOD	CHAR	20	*
.INCLUDE				CATS_INCL2	0
ERSDA	Created On		CATS_ERSDA	DATS	16
ERSTM	Time of Entry		CATS_CPUTM	TIMS	12
ERNAM	User Creating Record		CATS_ERNAM	CHAR	24
LAEDA	Date of Last Change		CATS_LAEDA	DATS	16
LAETM	Last Changed At		CATS_LAETM	TIMS	12
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
APNAM	Name of person who approved data		CATSAPNAM	CHAR	24
APDAT	Date of Approval		CATSAPDAT	DATS	16
WORKITEMID	Work item ID		SWW_WIID	NUMC	24	*
LOGSYS	Logical system		LOGSYS	CHAR	20	*
STATUS	Processing status		CATSSTATUS	CHAR	4
REFCOUNTER	Reference Counter for Record to be Changed		CATSREFCOU	CHAR	24
REASON	Reason for rejection		CATSREASON	CHAR	8	*
BELNR	Document no.		CATSBELNR	CHAR	20
EXTSYSTEM	Logical system of source document		HR_AWSYS	CHAR	20	*
EXTAPPLICATION	External Application		HR_AWTYP	CHAR	10
EXTDOCUMENTNO	Document number		HR_AWKEY	CHAR	40
TASKCOUNTER	CATS: Task Counter		CATSTASKCOUNTER	CHAR	20
.INCLUDE				CATS_CELL	0
CATSHOURS	Hours		CATSHOURS	QUAN	3
BEGUZ	Start time		CATSBEGUZ	TIMS	12
ENDUZ	End time		CATSENDUZ	TIMS	12
VTKEN	Previous Day Indicator		VTKEN	CHAR	2
ALLDF	Record is for Full Day		ALLDF	CHAR	2
OFMNW	Remaining work		REMNW	QUAN	4
PEDD	Forecast finish date of operation from confirmation		CO_PEDD	DATS	16
AUERU	Partial/Final Confirmation		AUERU_VS	CHAR	2
LTXA1	Short Text		CATSSHORTT	CHAR	80
LONGTEXT	Long Text		CATSLONGTE	CHAR	2
ERUZU	Indicator: Partial confirmation		ERUZU	CHAR	2
CATSAMOUNT	CATS Amount		CATSAMOUNT	CURR	7
CATSQUANTITY	Time Sheet: Number (Unit of Measure)		CATSNUMBER	QUAN	8
.INCLUDE				CI_CATSDB	0
.INCLU--AP				/PPA/T_CI_CATSDB_APPEND	0
.INCLUDE				/PPA/T_CI_CATSDB	0
/PPA/OBJKT	Object type: order/project/cost ctr/network/attendance		/PPA/T_OBJKT	CHAR	4
/PPA/SICHT	Entry view time/expenses/costs/material/billing suggestion		/PPA/T_SICHT	CHAR	2
/PPA/DAUER	Calculated duration in hours		/PPA/T_DAUER	QUAN	3
/PPA/MENGE	Quantity		/PPA/T_MENGE	DEC	7
/PPA/LSTNR	Service number		LSTNR	CHAR	80	MARA
/PPA/TAXKM	Tax classification material		TAXKM	CHAR	2	*
/PPA/MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
/PPA/KKART	Credit Card		/PPA/T_KKART	CHAR	12	/PPA/T_CIT
/PPA/RUECK	Completion confirmation number for the operation		CO_RUECK	NUMC	20
/PPA/ACTVY	Activity		/PPA/T_ACTIVITY	CHAR	60	/PPA/T_CT
/PPA/PLOSP	Location of activity output		/PPA/T_PLOSP	CHAR	30
/PPA/TICNR	Ticket No.		/PPA/T_TICNR	CHAR	40
/PPA/FLID	Billing layout control identification number		/PPA/T_FLID	CHAR	20
/PPA/ANSNR	Reservation (subtype by concurrent employment)		/PPA/THRANSNR	CHAR	8
/PPA/CLIENT	BAPI interface client (SAPGUI, WebDynpro, mobile, external�)		/PPA/T_BAPI_INTFCLIENT	CHAR	6
/PPA/VARIANT	Data Entry Profile		CATSVARIAN	CHAR	16	TCATS
/PPA/AL_ASSIGNED	ProTime: Archive- Item is attached to a CATS document		/PPA/T_AL_ASSIGNED	CHAR	2
/PPA/REF_ATAB_PT	Reference between Att/Abs and Perf.Time		/PPA/T_REF_ATTABS_PTIME	CHAR	24
/PPA/AUTO_ADDED	Automaticly inserted document		/PPA/T_AUTO_ADDED	CHAR	2
/PPA/CC_GROUP_ID	Credit Card Group ID		/PPA/T_CC_GROUP_ID	CHAR	16	/PPA/T_CC_STATUS
/PPA/CC_TRANS_REF	Credit Card Transaction Reference		/PPA/T_CC_TRANS_REF	CHAR	48
/PPA/CC_TRANS_DAT	Credit Card Transaction Date		/PPA/T_CC_TRANS_DAT	DATS	16
/PPA/OBJECT_TYPE	ProTime Core: Object type unique		/PPA/T_OBJECT_TYPE	CHAR	4
/PPA/OBJECT_KEY	ProTime Core: Object key unique		/PPA/T_OBJECT_KEY	CHAR	84
.INCLUDE				/PPA/T_STATOBJ	0
/PPA/RKOSTL	Receiver Cost Center		EKOSTL	CHAR	20	*
/PPA/RPROJ	Receiver WBS Element		EPROJ	NUMC	16	*
/PPA/RAUFNR	Receiver Order		EAUFNR	CHAR	24	*
/PPA/RNPLNR	Network number		NW_AUFNR	CHAR	24	*
/PPA/RAUFPL	Routing number of operations in the order		CO_AUFPL	NUMC	20
/PPA/RAPLZL	General counter for order		CO_APLZL	NUMC	16	*
/PPA/RKDAUF	Receiver sales order		EKDAU	CHAR	20
/PPA/RKDPOS	Item number in receiver sales order		EKDPO	NUMC	12
.INCLUDE				/PPA/T_CI_CATSDB_EXT	0
/PPA/DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE	CI_PRS_CPILS_1			INCL_EEW_PRS_CPILS_1_PS	0
.INCLUDE				CI_PRS_CPILS_1	0
DUMMY_INCL_EEW_PRS_CPILS	Dummy function in length 1		DUMMY	CHAR	2