SAP table TCATS (CATS: Data Entry Profiles)

SAP table TCATS has 2 primary key fields being MANDT,VARIANT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

TCATS foreign key relationships

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