CATSDB SAP (CATS: Database Table for Time Sheet) Table details
Dictionary Type: Table
Description: CATS: Database Table for Time Sheet
Description: CATS: Database Table for Time Sheet
Table field list including key, data, relationships and ABAP select examples
CATSDB is a standard SAP Table which is used to store CATS: Database Table for Time Sheet data and is available within R/3 SAP systems depending on the version and release level.
The CATSDB table consists of various fields, each holding specific information or linking keys about CATS: Database Table for Time Sheet data available in SAP. These include MANDT (Client), COUNTER (Counter for Records in Time Recording), PERNR (Personnel Number), WORKDATE (Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CATSDB table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
COUNTER | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
WORKDATE | Date | CATSDATE | DATS | 8 | DATUM | ||||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | CSLA | LSTAR | LAR | LART_EMPTY | |
SEBELN | Sending purchase order | SEBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
SEBELP | Sending purchase order item | SEBELP | NUMC | 5 | Assigned to domain | EBELP | |||
SPRZNR | Sender Business Process | SPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
LSTNR | Activity Number | ASNUM | CHAR | 18 | Assigned to domain | ALPHA | ASNUM | ASN | |
RKOSTL | Receiver Cost Center | EKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
RPROJ | Receiver WBS element | EPROJ | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
RAUFNR | Receiver Order | EAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
RNPLNR | Network number | NW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
RAUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
RAPLZL | General counter for order | CO_APLZL | NUMC | 8 | Assigned to domain | CO_APLZL | |||
RKDAUF | Receiver sales order | EKDAU | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
RKDPOS | Item number in receiver sales order | EKDPO | NUMC | 6 | Assigned to domain | POSNR | |||
RKSTR | Receiver cost object | EKSTR | CHAR | 12 | Assigned to domain | KSTRG | |||
RPRZNR | Receiver business process | EPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
FUND | Receiver fund | FM_EFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | RECEIVER_FUND | ||
FUNC_AREA | Receiving Functional Area | EFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
GRANT_NBR | Receiver Grant | GM_GRANT_RECEIVER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
S_FUND | Sender fund | FM_SFONDS | CHAR | 10 | Assigned to domain | BP_GEBER | SENDER_FUND | ||
S_FUNC_AREA | Sending Functional Area | SFKTBER | CHAR | 16 | Assigned to domain | FKBER | |||
S_GRANT_NBR | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
BUDGET_PD | FM: Receiver Budget Period | FM_EBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
SBUDGET_PD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
AWART | Attendance or Absence Type | AWART | CHAR | 4 | Assigned to domain | AWART | |||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
KAPID | Capacity ID | KAPID | NUMC | 8 | Assigned to domain | KAPID | |||
SPLIT | Split number | CY_SPLIT | INT1 | 3 | INT1 | ||||
REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
WABLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
VERSL | Overtime Compensation Type | VRSCH | CHAR | 1 | T555R | VRSCH | |||
WTART | Tax area work center | HRWRKAR | CHAR | 4 | Assigned to domain | HRWRKAR | |||
BWGRL | Valuation basis | CATSBWGRL | CURR | 13(2) | WERTV7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFKZ | Extra Pay Indicator | AUFKN | CHAR | 1 | AUFKN | ||||
TRFGR | Pay Scale Group | TRFGR | CHAR | 8 | Assigned to domain | TRFGR | |||
TRFST | Pay Scale Level | TRFST | CHAR | 2 | Assigned to domain | TRFST | |||
PRAKN | Premium Number | PRAKN | CHAR | 2 | Assigned to domain | PRAKN | |||
PRAKZ | Premium Indicator | PRAKZ | NUMC | 4 | PRAKZ | ||||
OTYPE | Object Type | OTYPE | CHAR | 2 | T778O | OTYPE | POT | ||
PLANS | Position | PLANS | NUMC | 8 | Assigned to domain | PLANS | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
MEINH | Unit of Measure for Display | MEINH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TCURR | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
PRICE | Price in Transaction Currency | CATSPRICE | CURR | 11(2) | WERTV6 | ||||
ARBID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
AUTYP | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
HRCOSTASG | Cost Accounting Variants | CATSHRCO | CHAR | 1 | CATSHRCO | ||||
HRKOSTL | Cost Center | CATSHRKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
HRLSTAR | Activity Type | CATSHRLSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART | |
HRFUND | Master Fund | CATSHRFUND | CHAR | 10 | Assigned to domain | BP_GEBER | |||
HRFUNC_AREA | Master Functional Area | CATSHRFUNC_AREA | CHAR | 16 | Assigned to domain | FKBER | |||
HRGRANT_NBR | Master Grant | CATSHRGRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | Assigned to domain | BEMOT | |||
UNIT | Unit of Measurement | MSEHI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STATKEYFIG | Statistical key figure | STAGR | CHAR | 6 | Assigned to domain | STAGR | STA | ||
TASKTYPE | Task Type | CATSTASKTYPE | CHAR | 4 | CATSTASKTYPE | ||||
TASKLEVEL | Task Level | CATSTASKLEVEL | CHAR | 8 | CATSTASKLEVEL | ||||
TASKCOMPONENT | Task component | CATSTASKCOMPONENT | CHAR | 8 | CATSTASKCOMPONENT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
CPR_GUID | Project GUID | CATS_CPR_GUID | CHAR | 32 | SYSUUID_C | ||||
CPR_EXTID | External Project ID | CATS_CPR_EXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJGUID | Object ID | CATS_CPR_OBJGUID | CHAR | 32 | SYSUUID_C | ||||
CPR_OBJGEXTID | External ID of Project Subobject | CATS_CPR_OBJGEXTID | CHAR | 24 | CHAR24 | ||||
CPR_OBJTYPE | cProjects Object Type | CATS_CPR_OBJTYPE | CHAR | 3 | CHAR3 | ||||
HRBUDGET_PD | Master Budget Period | CATSHR_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | |||
ERSDA | Created on | CATS_ERSDA | DATS | 8 | DATUM | ||||
ERSTM | Time of Entry | CATS_CPUTM | TIMS | 6 | UZEIT | ||||
ERNAM | User Who Created Data Record | CATS_ERNAM | CHAR | 12 | USNAM | ||||
LAEDA | Date of Last Change | CATS_LAEDA | DATS | 8 | DATUM | ||||
LAETM | Time of Last Change | CATS_LAETM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
APNAM | Name of person who approved data | CATSAPNAM | CHAR | 12 | UNAME | ||||
APDAT | Date of Approval | CATSAPDAT | DATS | 8 | DATUM | ||||
WORKITEMID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
STATUS | Processing status | CATSSTATUS | CHAR | 2 | CATSSTATUS | ||||
REFCOUNTER | Reference Counter for Record to be Changed | CATSREFCOU | CHAR | 12 | CHAR12 | ||||
REASON | Reason for rejection | CATSREASON | CHAR | 4 | Assigned to domain | CATSREASON | |||
BELNR | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
EXTSYSTEM | Logical system of source document | HR_AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
EXTAPPLICATION | External Application | HR_AWTYP | CHAR | 5 | HR_AWTYP | ||||
EXTDOCUMENTNO | Document number | HR_AWKEY | CHAR | 20 | AWKEY | ||||
TASKCOUNTER | CATS: Task Counter | CATSTASKCOUNTER | CHAR | 10 | ALPHA | BELNR | |||
CATSHOURS | Hours | CATSHOURS | QUAN | 4(2) | CATSHOURS | ||||
BEGUZ | Start time | CATSBEGUZ | TIMS | 6 | UZEIT | ||||
ENDUZ | End time | CATSENDUZ | TIMS | 6 | UZEIT | ||||
VTKEN | Previous Day Indicator | VTKEN | CHAR | 1 | XFELD | ||||
ALLDF | Record is for Full Day | ALLDF | CHAR | 1 | XFELD | ||||
OFMNW | Remaining work | REMNW | QUAN | 7(1) | ARBEIT | ||||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
AUERU | Partial/Final Confirmation | AUERU_VS | CHAR | 1 | AUERU_VS | ||||
LTXA1 | Short Text | CATSSHORTT | CHAR | 40 | TEXT40 | ||||
LONGTEXT | Long Text | CATSLONGTE | CHAR | 1 | XFELD | ||||
ERUZU | Indicator: Partial confirmation | ERUZU | CHAR | 1 | XFELD | ||||
CATSAMOUNT | CATS Amount | CATSAMOUNT | CURR | 13(2) | CATSAMOUNT | ||||
CATSQUANTITY | Time Sheet: Number (Unit of Measure) | CATSNUMBER | QUAN | 15(3) | CQUA8 | ||||
ZCPR_GUID | 0 | ||||||||
ZCPR_EXTID | 0 | ||||||||
ZCPR_OBJGUID | 0 | ||||||||
ZCPR_OBJGEXTID | 0 | ||||||||
ZCPR_OBJTYPE | 0 | ||||||||
YYRPM_REL_TYPE | Relation Type | Y23_RPM_REL_TYPE | CHAR | 3 | CHAR3 | ||||
YYRPM_PROJ_GUID | Project GUID (xRPM) | Y23_RPM_PROJ_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_PROJ_ID | Project ID (ext.) | Y23_RPM_PROJ_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_RES_GUID | Resource GUID (xRPM) | Y23_RPM_RES_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_RES_ID | Resource ID (ext.) | Y23_RPM_RES_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_ROLE_GUID | Role GUID (xRPM) | Y23_RPM_ROLE_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_ROLE_ID | Role ID (ext.) | Y23_RPM_ROLE_ID | CHAR | 24 | CHAR24 | ||||
YYRPM_TASK_GUID | Task GUID (xRPM) | Y23_RPM_TASK_GUID | CHAR | 32 | CHAR32 | ||||
YYRPM_TASK_ID | Task ID | Y23_RPM_TASK_ID | CHAR | 24 | CHAR24 | ||||
Z_PRS_OFFSHORE | 0 | ||||||||
Z_PRS_BILL_FLAG | 0 | ||||||||
Z_PRS_COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
Z_PRS_CHARGELEVL | 0 |
Key field | Non-key field |
How do I retrieve data from SAP table CATSDB using ABAP code
The following ABAP code Example will allow you to do a basic selection on CATSDB to SELECT all data from the tableDATA: WA_CATSDB TYPE CATSDB.
SELECT SINGLE *
FROM CATSDB
INTO CORRESPONDING FIELDS OF WA_CATSDB
WHERE...
How to access SAP table CATSDB
Within an ECC or HANA version of SAP you can also view further information about CATSDB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects