SAP Table TCATS

CATS: Data Entry Profiles

TCATS (CATS: Data Entry Profiles) 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 TCATS to other SAP tables.

TCATS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VARIANT Data Entry Profile CATSVARIAN CHAR 8 0
CHANGABLE Profile Can Be Changed CATSPROFCH CHAR 1 0
X Yes
NULL No
PERNRLIST Display List of Personnel Numbers CATSPERLIS CHAR 1 0
X Yes
NULL No
MULTPER Enter for Several Personnel Numbers CATSMULTPE CHAR 1 0
X Yes
NULL No
TIMECLERK Person Selection by Time Administrator CATSTIMECL CHAR 1 0
X Yes
NULL No
ORGOBJ Person Selection by Organizational Unit CATSORGOBJ CHAR 1 0
X Yes
NULL No
SELKOSTL Person Selection by Cost Center CATSSELCOS CHAR 1 0
X Yes
NULL No
SELWORKPL NOT USED ! Person Selection via Work Center CATSSELWRK CHAR 1 0
X Yes
NULL No
SELCUSTOM NOT USED ! Person Selection via Customer Enhancement CATSSELCUS CHAR 1 0
X Yes
NULL No
PERTYPE Type of Data Entry Period CATSPERTYP CHAR 1 0
1 Daily data entry
2 Weekly data entry
3 Semimonthly data entry
4 Monthly data entry
CATSPERIOD Number of Days/Weeks on Screen CATSPERIOD NUMC 2 0
FIRSTDAYOF First Day of Week CATSFIRSTD NUMC 1 0
0 Monday
1 Sunday
2 Saturday
3 Friday
4 Thursday
5 Wednesday
6 Tuesday
PERLEFT Number of Screens You Can Scroll Down CATSPERLEF NUMC 2 0
PERRIGHT Number of Screens You Can Scroll Up CATSPERRIG NUMC 2 0
RELDATE Key Date Relative to Current Date CATSRELDAT DEC 1 0
REJEBRIGHT Rejected Records Highlighted and Display-Only CATSBRIGHT CHAR 1 0
X Yes
NULL No
ADDINFOBRI Highlight Records with Additional Information CATSADDINF CHAR 1 0
X Yes
NULL No
DAYTEXT Display Weekdays CATSDAYTEX CHAR 1 0
X Yes
NULL No
BRGRU Profile Authorization Group CATSPROFAG TCATSA CHAR 4 0
BEGEND Data Entry with Clock Times CATSBEGEN_ CHAR 1 0
X Yes
NULL No
TARGETROW Line with Target Hours per Day CATSTARGET CHAR 1 0
X Yes
NULL No
TIMETYPE Time Type for Target Hours (Default: Day's Planned Hours) CATSTIMETY T555A CHAR 4 0
SUBHRTIMES Subtract HR Attendance or Absence Hours from Target Hours CATSSUBHR CHAR 1 0
X Yes
NULL No
UNDERTARGE Max. Percentage by Which Value May Fall Below Target Hours CATSUNDERT NUMC 3 0
UNDERREACT Reaction if Downward Tolerance Is Not Observed CATSUNDERR CHAR 1 0
NULL Standard Reaction
E Error Message
W Warning
N No Message
OVERTARGET Max. Percentage by Which Value May Exceed Target Hours CATSOVERTA NUMC 3 0
OVERREACT Reaction if Upward Tolerance Is Not Observed CATSOVERRE CHAR 1 0
NULL Standard Reaction
E Error Message
W Warning
N No Message
SUMROW Line with Totals for Each Day CATSSUMROW CHAR 1 0
X Yes
NULL No
CALENDAR Data Entry for Workdays only CATSCALE CHAR 1 0
X Yes
NULL No
FUTURE Release Future Times CATSFUTURE CHAR 1 0
X Yes
NULL No
WORKLIST Display Worklist CATSWRKLST CHAR 1 0
X Yes
NULL No
ASSIGNED Worklist from Resource Planning CATSASSIGN CHAR 1 0
X Yes
NULL No
WORKCENTRE Worklist Based on Work Center Assignment CATSWORKCT CHAR 1 0
X Yes
NULL No
WORKING Worklist with Operations that Are in Process CATSWORKNG CHAR 1 0
X Yes
NULL No
WORKSINCE CATS: Worklist - From CATSSINCEP DEC 3 0
FROMPOOL Worklist with Pool of Confirmations CATSPOOL CHAR 1 0
X Yes
NULL No
FROMEXIT Set Up Worklist Using an SAP Enhancement CATSEXITWL CHAR 1 0
X Yes
NULL No
WORKWITH Copy from Worklist Without Hours WORKWITH CHAR 1 0
X Yes
NULL No
WF_APPR Workflow for Approval CATSWFAPPR CHAR 1 0
X Yes
NULL No
FREEATSAVE Release Records on Saving CATSFREEAT CHAR 1 0
X Yes
NULL No
APPROVAL Approval Required CATSAPPROV CHAR 1 0
X Yes
NULL No
DEFKOKRSCO Propose Controlling Area from HR Master Record CATSKOKRSC CHAR 1 0
X Yes
NULL No
DEFCOSTCO Propose Master Cost Center from HR Master Record CATSCOSTCO CHAR 1 0
X Yes
NULL No
DEFCOSTCC Propose Cost Center from HR Master Record CATSCOSTCC CHAR 1 0
X Yes
NULL No
DEFACTTY Propose Activity Type from HR Master Record CATSACTTY CHAR 1 0
X Yes
NULL No
DEFPUROR Propose Purchase Order from HR Master Record CATSPUROR CHAR 1 0
X Yes
NULL No
DEFLSTST Propose Service Master from HR Master Record CATSLSTLS CHAR 1 0
X Yes
NULL No
DEFATYPE Propose Attendance/Absence Type CATSATYPE CHAR 1 0
X Yes
NULL No
DEFAWART Attendance or Absence Type AWART T554S CHAR 4 0
DEFWTYPE Propose Wage Type CATSWTYPE CHAR 1 0
X Yes
NULL No
DEFLGART Wage Type LGART T512Z CHAR 4 0
TASK Task ID SWW_TASK CHAR 14 0
KONTIREACT Reaction if Quota Is Insufficient CATSQUOTAR CHAR 1 0
NULL Standard Reaction
E Error Message
W Warning
N No Message
KOLLIREACT Reaction if CATS Records Collide CATSCOLLIR CHAR 1 0
NULL Standard Reaction
E Error Message
W Warning
N No Message
KOLHRREACT Reaction if CATS Records Collide with HR Records CATSCOLHRR CHAR 1 0
NULL Standard Reaction
E Error Message
W Warning
N No Message
MAXHRREACT Reaction if More than 24 Hours Are Entered for a Day CATSMAXHRR CHAR 1 0
NULL Standard Reaction
E Error Message
W Warning
N No Message
DIRECTHR Immediate Transfer to HR DIRECTHR CHAR 1 0
X Yes
NULL No
CATSPRINT Print Program for the Time Sheet CATSPRINT TCATP CHAR 40 0
SELREPORT Time Sheet: Report for Person Selection CATSSELRP CHAR 40 0
HRCOSTASG Cost Accounting Variants CATSHRCO CHAR 1 0
NULL Assignment of personnel costs to the master cost center
A Assignment of personnel costs to the receiver object
B Assignment of personnel costs to sender cost center
C Pers. cost assgmt to sender; acct assgmt to activity type
D Activity allocation between master and sender cost center
E Acty alloc. master and sender; acct assgmt to activity type
SELREP Person Selection Using Selection Report CATSSELREP CHAR 1 0
X Yes
NULL No
CALENDAR_W Distribution of Hours in Worklist for Workdays Only CATSCALE_W CHAR 1 0
X Yes
NULL No
NOBREAKDED No Deduction of Breaks when Calculating Hours CATSNOBRKS CHAR 1 0
X Yes
NULL No
ADDOVERTIME Add Overtime from HR to Target Hours CATSADDOVER CHAR 1 0
X Yes
NULL No
WF_AUTO Automatic Recipient Determination CATSWFAUTO CHAR 1 0
X Yes
NULL No
NOCHANGE Approved Records Cannot Be Changed CATSNOCHNG CHAR 1 0
X Yes
NULL No
SKIPISCR Skip Initial Screen CATSSKIPISCR CHAR 1 0
X Yes
NULL No
DEFSPRZNR Propose Sender Business Process from HR Master Record CATSSPRZNR CHAR 1 0
X Yes
NULL No
CATSCELL_SIZE Time Sheet: Cell Length CATSCELL_SIZE NUMC 2 0
T_SCHEMA Trip schema RSCHE T706S CHAR 2 0
TEMPLATE Personal Templates CATSTEMPLATE CHAR 1 0
X Yes
NULL No
PERLOCK Include CO Period Lock CATSPERLOCK CHAR 1 0
X Yes
NULL No
EXC_GROUP Rule Group for Special Approval CATS_EXC_GROUP TCATS_EXC_GROUP CHAR 8 0
SPECIAL_APPROVAL Approval Required CATSAPPROV CHAR 1 0
X Yes
NULL No
WORKCPRO Worklist from Project Assignment CATSCPRO CHAR 1 0
X Yes
NULL No
ASSIGNDB Worklist from Staff Assignments CATSASGNDB CHAR 1 0
X Yes
NULL No
CHECKASDB Input Checks from Staff Assignments CATSCHKADB CHAR 1 0
X Yes
NULL No
HRENABLED Enable HR information in CATS CATSHRE CHAR 1 0
X Yes
NULL No
DATADISPLAY Display options for data entry in CATS WDA CATSDDISP CHAR 1 0
NULL Horizontal display
V Vertical display
CUTOFFDT Time recording cut-off date at the end of payroll period CATSPPE CHAR 1 0
NULL None
A Payroll period end date
C End of current calendar month
I Custom implementation
OFFSETPD Cut-off end date for time recording in CATS CATSODD CHAR 2 0
01 01 before
02 02 before
03 03 before
04 04 before
05 05 before
06 06 before
07 07 before
08 08 before
09 09 before
10 10 before
11 01 after
12 02 after
13 03 after
14 04 after
15 05 after
16 06 after
17 07 after
18 08 after
19 09 after
20 10 after
NULL
PUBLICHOLTY Public holiday type for HR-Enabled CATS CATSHABSTY T554S CHAR 4 0

TCATS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCATS BRGRU TCATS BRGRU TCATSA CATS: Profile Authorization Groups CATSPROFAG
TCATS BRGRU TCATS MANDT TCATSA CATS: Profile Authorization Groups MANDT
TCATS CATSPRINT TCATS MANDT TCATP Allowed Print Reports for CATS MANDT
TCATS CATSPRINT TCATS CATSPRINT TCATP Allowed Print Reports for CATS CATSPRINT
TCATS DEFAWART TCATS DEFAWART T554S Attendance and Absence Types SUBTY
TCATS DEFAWART * T554S Attendance and Absence Types ENDDA
TCATS DEFAWART TCATS MANDT T554S Attendance and Absence Types MANDT
TCATS DEFAWART * T554S Attendance and Absence Types MOABW
TCATS DEFLGART '2010' T512Z Permissibility of Wage Types per Infotype INFTY
TCATS DEFLGART * T512Z Permissibility of Wage Types per Infotype MOLGA
TCATS DEFLGART TCATS DEFLGART T512Z Permissibility of Wage Types per Infotype LGART
TCATS DEFLGART * T512Z Permissibility of Wage Types per Infotype ENDDA
TCATS DEFLGART TCATS MANDT T512Z Permissibility of Wage Types per Infotype MANDT
TCATS EXC_GROUP TCATS MANDT TCATS_EXC_GROUP Rule Groups for Special Approval MANDT
TCATS EXC_GROUP TCATS EXC_GROUP TCATS_EXC_GROUP Rule Groups for Special Approval GROUP_ID
TCATS MANDT TCATS MANDT T000 Clients MANDT
TCATS PUBLICHOLTY * T554S Attendance and Absence Types ENDDA
TCATS PUBLICHOLTY TCATS MANDT T554S Attendance and Absence Types MANDT
TCATS PUBLICHOLTY * T554S Attendance and Absence Types MOABW
TCATS PUBLICHOLTY TCATS PUBLICHOLTY T554S Attendance and Absence Types SUBTY
TCATS TIMETYPE TCATS MANDT T555A Time Types MANDT
TCATS TIMETYPE * T555A Time Types MOBDE
TCATS TIMETYPE TCATS TIMETYPE T555A Time Types ZTART
TCATS TIMETYPE * T555A Time Types ENDDA
TCATS T_SCHEMA TCATS MANDT T706S Trip Schema MANDT
TCATS T_SCHEMA * T706S Trip Schema MOREI
TCATS T_SCHEMA TCATS T_SCHEMA T706S Trip Schema SCHEM