CATSHR SAP (Cross-Application Time Sheet (CATS): Transfer to HR) Table details

Dictionary Type: Table
Description: Cross-Application Time Sheet (CATS): Transfer to HR




ABAP Code to SELECT data from CATSHR
Related tables to CATSHR
Access table CATSHR




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
COUNTERCounter for Records in Time Recording CATSCOUNTECHAR12CHAR12
STOKZIndicator: Document Has Been Reversed CO_STOKZCHAR1FLAG
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
WORKDATEDate CATSDATEDATS8DATUM
UNAME1User who wrote record to interface PW_UNAME1CHAR12UNAME
DATUM1Date on which record was written to interface PW_DATUM1DATS8DATUM
UZEIT1Time at which record was written to interface PW_UZEIT1TIMS6UZEIT
PGMID1Write Record to Interface Report PW_PGMID1CHAR40PROGNAME
UNAME2Name of user who initially accessed record PW_UNAME2CHAR12UNAME
DATUM2Date on which record was initially accessed PW_DATUM2DATS8DATUM
UZEIT2Time at which record was initially accessed PW_UZEIT2TIMS6UZEIT
PGMID2Report used to access record initially PW_PGMID2CHAR40PROGNAME
STATU2Log status when record was first accessed PW_STATU2CHAR1PW_STATU
UNAME3Last user to access record PW_UNAME3CHAR12UNAME
DATUM3Date on which record was last accessed PW_DATUM3DATS8DATUM
UZEIT3Time at which record was last accessed PW_UZEIT3TIMS6UZEIT
PGMID3Last Used to Access Record Program PW_PGMID3CHAR40PROGNAME
STATU3Log status when record was last accessed PW_STATU3CHAR1PW_STATU
UNAME4User who first retrieved the record successfully PW_UNAME4CHAR12UNAME
DATUM4Date on which record was first retrieved successfully PW_DATUM4DATS8DATUM
UZEIT4Time at which record was first retrieved successfully PW_UZEIT4TIMS6UZEIT
PGMID4Report first used to retrieve record successfully PW_PGMID4CHAR40PROGNAME
SKOSTLSender Cost Center SKOSTLCHAR10Assigned to domainALPHAKOSTLKSK
LSTARActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
SEBELNSending purchase order SEBELNCHAR10Assigned to domainALPHAEBELN
SEBELPSending purchase order item SEBELPNUMC5Assigned to domainEBELP
LSTNRService number LSTNRCHAR18Assigned to domainMATN1MATNRLST
SPRZNRSender Business Process SPRZNRCHAR12Assigned to domainALPHACO_PRZNR
RKOSTLReceiver Cost Center EKOSTLCHAR10Assigned to domainALPHAKOSTLKSK
RPROJEXTWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
RAUFNRReceiver Order EAUFNRCHAR12Assigned to domainALPHAAUFNR
RNPLNRNetwork number NW_AUFNRCHAR12Assigned to domainALPHAAUFNRANR
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
UVORNSuboperation UVORNCHAR4NUMCVVORNR
RKDAUFReceiver sales order EKDAUCHAR10Assigned to domainALPHAVBELN
RKDPOSItem number in receiver sales order EKDPONUMC6Assigned to domainPOSNR
RKSTRReceiver cost object EKSTRCHAR12Assigned to domainKSTRG
RPRZNRReceiver business process EPRZNRCHAR12Assigned to domainALPHACO_PRZNR
AWARTAttendance or Absence Type AWARTCHAR4T554SAWART
LGARTWage Type LGARTCHAR4Assigned to domainLGART
REINRTrip Number REINRNUMC10REINR
VERSLOvertime Compensation Type VRSCHCHAR1T555RVRSCH
BWGRLValuation basis CATSBWGRLCURR13(2) WERTV7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
AUFKZExtra Pay Indicator AUFKNCHAR1AUFKN
TRFGRPay Scale Group TRFGRCHAR8Assigned to domainTRFGR
TRFSTPay Scale Level TRFSTCHAR2Assigned to domainTRFST
PRAKNPremium Number PRAKNCHAR2Assigned to domainPRAKN
PRAKZPremium Indicator PRAKZNUMC4PRAKZ
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
PLANSPosition PLANSNUMC8T528BPLANS
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
MEINHUnit of Measure for Display MEINHUNIT3T006CUNITMEINS
TCURRTransaction Currency TWAERCUKY5TCURCWAERSFWS
PRICEPrice in Transaction Currency CATSPRICECURR11(2) WERTV6
ARBIDObject ID OBJEKTIDNUMC8NUM08PON
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
ERSDACreated on CATS_ERSDADATS8DATUM
ERSTMTime of Entry CATS_CPUTMTIMS6UZEIT
ERNAMUser Who Created Data Record CATS_ERNAMCHAR12USNAM
LAEDADate of Last Change CATS_LAEDADATS8DATUM
LAETMTime of Last Change CATS_LAETMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
APNAMName of person who approved data CATSAPNAMCHAR12UNAME
APDATDate of Approval CATSAPDATDATS8DATUM
WORKITEMIDWork item ID SWW_WIIDNUMC12Assigned to domainSWW_WIIDWID
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
STATUSProcessing status CATSSTATUSCHAR2CATSSTATUS
REFCOUNTERReference Counter for Record to be Changed CATSREFCOUCHAR12CHAR12
REASONReason for rejection CATSREASONCHAR4Assigned to domainCATSREASON
BELNRDocument Number CATSBELNRCHAR10ALPHABELNR
EXTSYSTEMLogical system of source document HR_AWSYSCHAR10Assigned to domainALPHALOGSYS
EXTAPPLICATIONExternal Application HR_AWTYPCHAR5HR_AWTYP
EXTDOCUMENTNODocument number HR_AWKEYCHAR20AWKEY
TASKCOUNTERCATS: Task Counter CATSTASKCOUNTERCHAR10ALPHABELNR
CATSHOURSHours CATSHOURSQUAN4(2) CATSHOURS
BEGUZStart time CATSBEGUZTIMS6UZEIT
ENDUZEnd time CATSENDUZTIMS6UZEIT
VTKENPrevious Day Indicator VTKENCHAR1XFELD
ALLDFRecord is for Full Day ALLDFCHAR1XFELD
LTXA1Short Text CATSSHORTTCHAR40TEXT40
ZCPR_GUID 0
ZCPR_EXTID 0
ZCPR_OBJGUID 0
ZCPR_OBJGEXTID 0
ZCPR_OBJTYPE 0
YYRPM_REL_TYPERelation Type Y23_RPM_REL_TYPECHAR3CHAR3
YYRPM_PROJ_GUIDProject GUID (xRPM) Y23_RPM_PROJ_GUIDCHAR32CHAR32
YYRPM_PROJ_IDProject ID (ext.) Y23_RPM_PROJ_IDCHAR24CHAR24
YYRPM_RES_GUIDResource GUID (xRPM) Y23_RPM_RES_GUIDCHAR32CHAR32
YYRPM_RES_IDResource ID (ext.) Y23_RPM_RES_IDCHAR24CHAR24
YYRPM_ROLE_GUIDRole GUID (xRPM) Y23_RPM_ROLE_GUIDCHAR32CHAR32
YYRPM_ROLE_IDRole ID (ext.) Y23_RPM_ROLE_IDCHAR24CHAR24
YYRPM_TASK_GUIDTask GUID (xRPM) Y23_RPM_TASK_GUIDCHAR32CHAR32
YYRPM_TASK_IDTask ID Y23_RPM_TASK_IDCHAR24CHAR24

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!