CATSHR SAP (Cross-Application Time Sheet (CATS): Transfer to HR) Table details
Dictionary Type: Table
Description: Cross-Application Time Sheet (CATS): Transfer to HR
Description: Cross-Application Time Sheet (CATS): Transfer to HR
Table field list including key, data, relationships and ABAP select examples
CATSHR is a standard SAP Table which is used to store Cross-Application Time Sheet (CATS): Transfer to HR data and is available within R/3 SAP systems depending on the version and release level.
The CATSHR table consists of various fields, each holding specific information or linking keys about Cross-Application Time Sheet (CATS): Transfer to HR data available in SAP. These include MANDT (Client), COUNTER (Counter for Records in Time Recording), STOKZ (Indicator: Document Has Been Reversed), PERNR (Personnel Number).. 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 CATSHR 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 | Assigned to domain | MANDT | |||
COUNTER | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
STOKZ | Indicator: Document Has Been Reversed | CO_STOKZ | CHAR | 1 | FLAG | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
WORKDATE | Date | CATSDATE | DATS | 8 | DATUM | ||||
UNAME1 | User who wrote record to interface | PW_UNAME1 | CHAR | 12 | UNAME | ||||
DATUM1 | Date on which record was written to interface | PW_DATUM1 | DATS | 8 | DATUM | ||||
UZEIT1 | Time at which record was written to interface | PW_UZEIT1 | TIMS | 6 | UZEIT | ||||
PGMID1 | Write Record to Interface Report | PW_PGMID1 | CHAR | 40 | PROGNAME | ||||
UNAME2 | Name of user who initially accessed record | PW_UNAME2 | CHAR | 12 | UNAME | ||||
DATUM2 | Date on which record was initially accessed | PW_DATUM2 | DATS | 8 | DATUM | ||||
UZEIT2 | Time at which record was initially accessed | PW_UZEIT2 | TIMS | 6 | UZEIT | ||||
PGMID2 | Report used to access record initially | PW_PGMID2 | CHAR | 40 | PROGNAME | ||||
STATU2 | Log status when record was first accessed | PW_STATU2 | CHAR | 1 | PW_STATU | ||||
UNAME3 | Last user to access record | PW_UNAME3 | CHAR | 12 | UNAME | ||||
DATUM3 | Date on which record was last accessed | PW_DATUM3 | DATS | 8 | DATUM | ||||
UZEIT3 | Time at which record was last accessed | PW_UZEIT3 | TIMS | 6 | UZEIT | ||||
PGMID3 | Last Used to Access Record Program | PW_PGMID3 | CHAR | 40 | PROGNAME | ||||
STATU3 | Log status when record was last accessed | PW_STATU3 | CHAR | 1 | PW_STATU | ||||
UNAME4 | User who first retrieved the record successfully | PW_UNAME4 | CHAR | 12 | UNAME | ||||
DATUM4 | Date on which record was first retrieved successfully | PW_DATUM4 | DATS | 8 | DATUM | ||||
UZEIT4 | Time at which record was first retrieved successfully | PW_UZEIT4 | TIMS | 6 | UZEIT | ||||
PGMID4 | Report first used to retrieve record successfully | PW_PGMID4 | CHAR | 40 | PROGNAME | ||||
SKOSTL | Sender Cost Center | SKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | 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 | |||
LSTNR | Service number | LSTNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | LST | |
SPRZNR | Sender Business Process | SPRZNR | CHAR | 12 | Assigned to domain | ALPHA | CO_PRZNR | ||
RKOSTL | Receiver Cost Center | EKOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KSK | |
RPROJEXT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
RAUFNR | Receiver Order | EAUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
RNPLNR | Network number | NW_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
UVORN | Suboperation | UVORN | CHAR | 4 | NUMCV | VORNR | |||
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 | ||
AWART | Attendance or Absence Type | AWART | CHAR | 4 | T554S | AWART | |||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
VERSL | Overtime Compensation Type | VRSCH | CHAR | 1 | T555R | VRSCH | |||
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 | T528B | PLANS | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | 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 | Assigned to domain | WERKS | WRK | H_T001W_C | |
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 | ||||
LTXA1 | Short Text | CATSSHORTT | CHAR | 40 | TEXT40 | ||||
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 |
Key field | Non-key field |
How do I retrieve data from SAP table CATSHR using ABAP code
The following ABAP code Example will allow you to do a basic selection on CATSHR to SELECT all data from the tableDATA: WA_CATSHR TYPE CATSHR.
SELECT SINGLE *
FROM CATSHR
INTO CORRESPONDING FIELDS OF WA_CATSHR
WHERE...
How to access SAP table CATSHR
Within an ECC or HANA version of SAP you can also view further information about CATSHR 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