CATSDB

CATS: Database Table for Time Sheet | #transactional | Component: Time Sheet

🔑 Keys (2)
💰 Amounts (3)
∑ Quantities (3)
📅 Dates (9)
☰ Categorical (9)
Other (68)
🔗 Relations (9)

Column Name	Description
MANDT FK	Client
COUNTER	Counter for Records in Time Recording

Column Name	Description
💲 Currency Key (WAERS):
BWGRL	Valuation basis
CATSAMOUNT	CATS Amount
💲 Transaction Currency (TCURR):
PRICE	Price in Transaction Currency

Column Name	Description
📏 Unit of Measure for Display (MEINH):
CATSHOURS	Hours
OFMNW	Remaining work
📏 Unit of Measurement (UNIT):
CATSQUANTITY	Time Sheet: Number (Unit of Measure)

Column Name	Description
WORKDATE	Date
ERSDA	Created On
ERSTM	Time of Entry
LAEDA	Date of Last Change
LAETM	Last Changed At
APDAT	Date of Approval
BEGUZ	Start time
ENDUZ	End time
PEDD	Forecast finish date of operation from confirmation

Column Name	Description
AUFKZ	Extra Pay Indicator	Show values
AUTYP	Order category	Show values
HRCOSTASG	Cost Accounting Variants	Show values
STATUS	Processing status	Show values
VTKEN	Previous Day Indicator	Show values
ALLDF	Record is for Full Day	Show values
AUERU	Partial/Final Confirmation	Show values
LONGTEXT	Long Text	Show values
ERUZU	Indicator: Partial confirmation	Show values

Column Name	Description	Domain name
PERNR	Personnel Number	PERNR
SKOSTL	Sender Cost Center	KOSTL
SEBELN	Sending purchase order	EBELN
SEBELP	Sending purchase order item	EBELP
SPRZNR	Sender Business Process	CO_PRZNR
LSTNR	Activity Number	ASNUM
RKOSTL	Receiver Cost Center	KOSTL
RPROJ	Receiver WBS Element	PS_POSNR
RAUFNR	Receiver Order	AUFNR
RNPLNR	Network number	AUFNR
RAUFPL	Routing number of operations in the order	AUFPL
RAPLZL	General counter for order	CO_APLZL
RKDAUF	Receiver sales order	VBELN
RKDPOS	Item number in receiver sales order	POSNR
RKSTR	Receiver cost object	KSTRG
RPRZNR	Receiver business process	CO_PRZNR
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR
FUND	Receiver Fund	BP_GEBER
FUNC_AREA	Receiving Functional Area	FKBER
GRANT_NBR	Receiver Grant	GM_GRANT_NBR
S_FUND	Sender fund	BP_GEBER
S_FUNC_AREA	Sending Functional Area	FKBER
S_GRANT_NBR	Sender Grant	GM_GRANT_NBR
BUDGET_PD	FM: Receiver Budget Period	FM_BUDGET_PERIOD
SBUDGET_PD	FM: Sender Budget Period	FM_BUDGET_PERIOD
SERVICE_DOC_TYPE	Service Document Type	CRM_PROCESS_TYPE
SERVICE_DOC_ID	Service Document ID	CRM_OBJECT_ID
SERVICE_DOC_ITEM_ID	Service Document Item ID	FCO_SRVDOC_ITEM_ID
OVERTIMECAT	Overtime Category	CATS_OVERTIME_CATEGORY
WORK_ITEM_ID	Work Item ID	/CPD/PFP_WORKITEM_ID
LGART	Wage Type	LGART
SPLIT	Split number	INT1
REINR	Trip Number	REINR
WABLNR	Number of Material Document	BELNR
TRFGR	Pay Scale Group	TRFGR
TRFST	Pay Scale Level	TRFST
PRAKN	Premium Number	PRAKN
PRAKZ	Premium Indicator	PRAKZ
ARBID	Object ID	NUM08
HRKOSTL	Cost Center	KOSTL
HRLSTAR	Activity Type	LSTAR
HRFUND	Master Fund	BP_GEBER
HRFUNC_AREA	Master Functional Area	FKBER
HRGRANT_NBR	Master Grant	GM_GRANT_NBR
STATKEYFIG	Statistical key figure	STAGR
TASKTYPE	Task Type	CATSTASKTYPE
TASKLEVEL	Task Level	CATSTASKLEVEL
TASKCOMPONENT	Task component	CATSTASKCOMPONENT
BUKRS	Company Code	BUKRS
CPR_GUID	Project GUID	SYSUUID_C
CPR_EXTID	External Project ID	CHAR24
CPR_OBJGUID	Object ID	SYSUUID_C
CPR_OBJGEXTID	External ID of Project Subobject	CHAR24
CPR_OBJTYPE	cProjects Object Type	CHAR3
HRBUDGET_PD	Master Budget Period	FM_BUDGET_PERIOD
ERNAM	User Creating Record	USNAM
AENAM	Name of Person Who Changed Object	USNAM
APNAM	Name of person who approved data	UNAME
WORKITEMID	Work item ID	SWW_WIID
REFCOUNTER	Reference Counter for Record to be Changed	CHAR12
REASON	Reason for rejection	CATSREASON
BELNR	Document no.	BELNR
EXTSYSTEM	Logical system of source document	LOGSYS
EXTAPPLICATION	External Application	HR_AWTYP
EXTDOCUMENTNO	Document number	AWKEY
TASKCOUNTER	CATS: Task Counter	BELNR
LTXA1	Short Text	TEXT40
DUMMY_INCL_EEW_PRS_CPILS	Dummy function in length 1	DUMMY

Master Data Relations	Join Conditions
Controlling Area	`CATSDB.MANDT == TKA01.MANDT` `CATSDB.KOKRS == TKA01.KOKRS`
Activity Type Controlling Area Activity Type ?	`CATSDB.MANDT == CSLA.MANDT` `CATSDB.KOKRS == CSLA.KOKRS` `CATSDB.LSTAR == CSLA.LSTAR` `CATSDB.[column in domain "DATBI"] == CSLA.DATBI`
Client	`CATSDB.MANDT == T000.MANDT`
Unit of Measure for Display	`CATSDB.MANDT == T006.MANDT` `CATSDB.MEINH == T006.MSEHI`
Object Type	`CATSDB.MANDT == T778O.MANDT` `CATSDB.OTYPE == T778O.OTYPE`
Transaction Currency	`CATSDB.MANDT == TCURC.MANDT` `CATSDB.TCURR == TCURC.WAERS`
Overtime Compensation Type	`CATSDB.MANDT == T555R.MANDT` `CATSDB.VERSL == T555R.VME`
Currency Key	`CATSDB.MANDT == TCURC.MANDT` `CATSDB.WAERS == TCURC.WAERS`
Plant	`CATSDB.MANDT == T001W.MANDT` `CATSDB.WERKS == T001W.WERKS`