1. Home
  2. Resources
  3. SAP Tables
  4. CATSHR - Cross-Application Time Sheet (CATS): Transfer to HR

SAP Table CATSHR

Cross-Application Time Sheet (CATS): Transfer to HR

CATSHR (Cross-Application Time Sheet (CATS): Transfer to HR) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CATSHR to other SAP tables.

CATSHR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
COUNTER Counter for Records in Time Recording CATSCOUNTE CHAR 12 0
STOKZ Indicator: Document Has Been Reversed CO_STOKZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PERNR Personnel Number PERNR_D NUMC 8 0
WORKDATE Date CATSDATE DATS 8 0
UNAME1 User who wrote record to interface PW_UNAME1 CHAR 12 0
DATUM1 Date on which record was written to interface PW_DATUM1 DATS 8 0
UZEIT1 Time at which record was written to interface PW_UZEIT1 TIMS 6 0
PGMID1 Write Record to Interface Report PW_PGMID1 CHAR 40 0
UNAME2 Name of user who initially accessed record PW_UNAME2 CHAR 12 0
DATUM2 Date on which record was initially accessed PW_DATUM2 DATS 8 0
UZEIT2 Time at which record was initially accessed PW_UZEIT2 TIMS 6 0
PGMID2 Report used to access record initially PW_PGMID2 CHAR 40 0
STATU2 Log status when record was first accessed PW_STATU2 CHAR 1 0
NULL Record is new
1 Record was transferred
2 Record contains errors
3 Record is locked
4 Record was canceled
UNAME3 Last user to access record PW_UNAME3 CHAR 12 0
DATUM3 Date on which record was last accessed PW_DATUM3 DATS 8 0
UZEIT3 Time at which record was last accessed PW_UZEIT3 TIMS 6 0
PGMID3 Last Used to Access Record Program PW_PGMID3 CHAR 40 0
STATU3 Log status when record was last accessed PW_STATU3 CHAR 1 0
NULL Record is new
1 Record was transferred
2 Record contains errors
3 Record is locked
4 Record was canceled
UNAME4 User who first retrieved the record successfully PW_UNAME4 CHAR 12 0
DATUM4 Date on which record was first retrieved successfully PW_DATUM4 DATS 8 0
UZEIT4 Time at which record was first retrieved successfully PW_UZEIT4 TIMS 6 0
PGMID4 Report first used to retrieve record successfully PW_PGMID4 CHAR 40 0
SKOSTL Sender Cost Center SKOSTL CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 0
SEBELN Sending purchase order SEBELN CHAR 10 0
SEBELP Sending purchase order item SEBELP NUMC 5 0
LSTNR Service number LSTNR CHAR 18 0
SPRZNR Sender Business Process SPRZNR CHAR 12 0
RKOSTL Receiver Cost Center EKOSTL CHAR 10 0
RPROJEXT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
RAUFNR Receiver Order EAUFNR CHAR 12 0
RNPLNR Network number NW_AUFNR CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
UVORN Suboperation UVORN CHAR 4 0
RKDAUF Receiver sales order EKDAU CHAR 10 0
RKDPOS Item number in receiver sales order EKDPO NUMC 6 0
RKSTR Receiver cost object EKSTR CHAR 12 0
RPRZNR Receiver business process EPRZNR CHAR 12 0
AWART Attendance or Absence Type AWART T554S CHAR 4 0
LGART Wage Type LGART CHAR 4 0
REINR Trip Number REINR NUMC 10 0
VERSL Overtime Compensation Type VRSCH T555R CHAR 1 0
BWGRL Valuation basis CATSBWGRL CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
AUFKZ Extra Pay Indicator AUFKN CHAR 1 0
NULL No extra pay: Valuation basis used as is
- Valuation basis used as amount deducted
+ Valuation basis used as amount added
TRFGR Pay Scale Group TRFGR CHAR 8 0
TRFST Pay Scale Level TRFST CHAR 2 0
PRAKN Premium Number PRAKN CHAR 2 0
PRAKZ Premium Indicator PRAKZ NUMC 4 0
OTYPE Object Type OTYPE T778O CHAR 2 0
PLANS Position PLANS T528B NUMC 8 0
KOKRS Controlling Area KOKRS CHAR 4 0
MEINH Unit of Measure for Display MEINH T006 UNIT 3 0
TCURR Transaction Currency TWAER TCURC CUKY 5 0
PRICE Price in Transaction Currency CATSPRICE CURR 11 2
ARBID Object ID OBJEKTID NUMC 8 0
WERKS Plant WERKS_D CHAR 4 0
ERSDA Created on CATS_ERSDA DATS 8 0
ERSTM Time of Entry CATS_CPUTM TIMS 6 0
ERNAM User Who Created Data Record CATS_ERNAM CHAR 12 0
LAEDA Date of Last Change CATS_LAEDA DATS 8 0
LAETM Time of Last Change CATS_LAETM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
APNAM Name of person who approved data CATSAPNAM CHAR 12 0
APDAT Date of Approval CATSAPDAT DATS 8 0
WORKITEMID Work item ID SWW_WIID NUMC 12 0
LOGSYS Logical system LOGSYS CHAR 10 0
STATUS Processing status CATSSTATUS CHAR 2 0
10 In process
20 Released for approval
30 Approved
40 Approval rejected
50 Changed after approval
60 Cancelled
REFCOUNTER Reference Counter for Record to be Changed CATSREFCOU CHAR 12 0
REASON Reason for rejection CATSREASON CHAR 4 0
BELNR Document Number CATSBELNR CHAR 10 0
EXTSYSTEM Logical system of source document HR_AWSYS CHAR 10 0
EXTAPPLICATION External Application HR_AWTYP CHAR 5 0
EXTDOCUMENTNO Document number HR_AWKEY CHAR 20 0
TASKCOUNTER CATS: Task Counter CATSTASKCOUNTER CHAR 10 0
CATSHOURS Hours CATSHOURS QUAN 4 2
BEGUZ Start time CATSBEGUZ TIMS 6 0
ENDUZ End time CATSENDUZ TIMS 6 0
VTKEN Previous Day Indicator VTKEN CHAR 1 0
X Yes
NULL No
ALLDF Record is for Full Day ALLDF CHAR 1 0
X Yes
NULL No
LTXA1 Short Text CATSSHORTT CHAR 40 0
ZCPR_GUID cProjects: Projekt-GUID ZCPR_GUID CHAR 32 0
ZCPR_EXTID cProjects: Project Number ZCPR_EXTID CHAR 24 0
ZCPR_OBJGUID cProjects: Object GUID ZCPR_OBJGUID CHAR 32 0
ZCPR_OBJGEXTID cProjects: Object Name ZCPR_OBJGEXTID CHAR 24 0
ZCPR_OBJTYPE cProjects: Object Type ZCPR_OBJTYPE CHAR 3 0
YYRPM_REL_TYPE Relation Type Y23_RPM_REL_TYPE CHAR 3 0
YYRPM_PROJ_GUID Project GUID (xRPM) Y23_RPM_PROJ_GUID CHAR 32 0
YYRPM_PROJ_ID Project ID (ext.) Y23_RPM_PROJ_ID CHAR 24 0
YYRPM_RES_GUID Resource GUID (xRPM) Y23_RPM_RES_GUID CHAR 32 0
YYRPM_RES_ID Resource ID (ext.) Y23_RPM_RES_ID CHAR 24 0
YYRPM_ROLE_GUID Role GUID (xRPM) Y23_RPM_ROLE_GUID CHAR 32 0
YYRPM_ROLE_ID Role ID (ext.) Y23_RPM_ROLE_ID CHAR 24 0
YYRPM_TASK_GUID Task GUID (xRPM) Y23_RPM_TASK_GUID CHAR 32 0
YYRPM_TASK_ID Task ID Y23_RPM_TASK_ID CHAR 24 0

CATSHR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CATSHR AWART CATS_KEY MANDT T554S Attendance and Absence Types MANDT
CATSHR AWART * T554S Attendance and Absence Types MOABW
CATSHR AWART CATSHR AWART T554S Attendance and Absence Types SUBTY
CATSHR AWART * T554S Attendance and Absence Types ENDDA
CATSHR MEINH CATS_KEY MANDT T006 Units of Measurement MANDT
CATSHR MEINH CATSHR MEINH T006 Units of Measurement MSEHI
CATSHR OTYPE CATS_KEY MANDT T778O Object Types MANDT
CATSHR OTYPE CATSHR OTYPE T778O Object Types OTYPE
CATSHR PLANS CATSHR PLANS T528B Positions PLANS
CATSHR PLANS * T528B Positions ENDDA
CATSHR PLANS SYST MANDT T528B Positions MANDT
CATSHR PLANS CATSHR OTYPE T528B Positions OTYPE
CATSHR TCURR CATSHR TCURR TCURC Currency Codes WAERS
CATSHR TCURR CATS_KEY MANDT TCURC Currency Codes MANDT
CATSHR VERSL CATS_KEY MANDT T555R Overtime Compensation Types MANDT
CATSHR VERSL CATSHR VERSL T555R Overtime Compensation Types VME
CATSHR WAERS CATS_KEY MANDT TCURC Currency Codes MANDT
CATSHR WAERS CATSHR WAERS TCURC Currency Codes WAERS