SAP Table CATSFIELDS

Work Fields for CATS

CATSFIELDS (Work Fields for CATS) 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 CATSFIELDS to other SAP tables.

CATSFIELDS table fields

Field Data element Checktable Datatype Length Decimals
INPUTDATE Key Date for Time Recording CATSINPDAT DATS 8 0
ENAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
DETAILNAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
LISTNAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
PERNR Personnel Number PERNR_D NUMC 8 0
HDRKOSTL Cost Center KOSTL CHAR 10 0
KOSTLLTXT Description KLTXT CHAR 40 0
SBMOD Administrator Group SBMOD T526 CHAR 4 0
SACHZ Time Recording Administrator RP51E_SACH T526 CHAR 3 0
OTYPE Object Type OTYPE T778O CHAR 2 0
OBJID Search Term SEARK CHAR 12 0
OTEXT Object Name STEXT CHAR 40 0
MEINH Unit of Measure for Display MEINH T006 UNIT 3 0
CATSWEEK Factory calendar: Week KWEEK ACCP 6 0
CATSWEEKEX External Week Display CATSWEEKEX CHAR 7 0
CATSDATE Date DATUM DATS 8 0
DATEFROM From Date of Data Entry Period CATSDATEFR DATS 8 0
DATETO To Date of Data Entry Period CATSDATETO DATS 8 0
CLOCK New Data Records CATSLOCK CHAR 1 0
X Yes
NULL No
FREE Records Released for Approval CATSFREE CHAR 1 0
X Yes
NULL No
APPR Records that Are Approved CATSAPPR_D CHAR 1 0
X Yes
NULL No
REJE Records That Were Not Approved CATSREJE CHAR 1 0
X Yes
NULL No
CHNG Record that Was Changed and Has a Follow-On Record CATSCHANGE CHAR 1 0
X Yes
NULL No
VOID Cancelled Records CATSVOID CHAR 1 0
X Yes
NULL No
DATELEFT Earliest start date of data entry period CATSDATELE DATS 8 0
DATERIGHT Latest end date of data entry period CATSDATERI DATS 8 0
MARK Selection Column CATSMARK CHAR 1 0
X Yes
NULL No
ASTERISK Line Type on Data Entry Screen CATSASTERI CHAR 132 0
PERMARK Selection Column CATSMARK CHAR 1 0
X Yes
NULL No
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
WORKSINCE CATS: Worklist - From Date CATSSINCE DATS 8 0
POOL Confirmation pool AFRUV CHAR 20 0
RVOPE Operations outstanding from the confirmation pool RVOPE CHAR 1 0
X Yes
NULL No
RVCLO Confirmed Operations from the Confirmation Pool RVCLO CHAR 1 0
X Yes
NULL No
RVALL All Operations from Confirmation Pool RVALL CHAR 1 0
X Yes
NULL No
DISTFROM From Date of Distribution Period CATSDISTFR DATS 8 0
DISTTO To Date of Distribution Period CATSDISTTO DATS 8 0
DISTFUNC Distr.cap.reqmts (plant maint.,process order, network) CR_VERTN TC29 CHAR 8 0
DISTARBEIT Hours to Be Distributed DISTHOUR QUAN 7 1
DISTMODE Hours per Line DISTMODE CHAR 1 0
X Yes
NULL No
DISTDIST Calculate Hours Using Distribution Function DISTDIST CHAR 1 0
X Yes
NULL No
DISTDAY Hours per Cell DISTDAY CHAR 1 0
X Yes
NULL No
LINE1 Line for Short Message CATSLINE CHAR 80 0
LINE2 Line for Short Message CATSLINE CHAR 80 0
LINE3 Line for Short Message CATSLINE CHAR 80 0
LINE4 Line for Short Message CATSLINE CHAR 80 0
LINE5 Line for Short Message CATSLINE CHAR 80 0
LINE6 Line for Short Message CATSLINE CHAR 80 0
LINE7 Line for Short Message CATSLINE CHAR 80 0
LINE8 Line for Short Message CATSLINE CHAR 80 0
LINE9 Line for Short Message CATSLINE CHAR 80 0
PERTEXT Explanatory short text DDTEXT CHAR 60 0
SEARCH Search Term CATSSEARCH CHAR 25 0
SELKOSTL Cost Center KOSTL CSKS CHAR 10 0
YESORNO Yes/No Switch with Values 'SPACE' and 'X' CATSYESORN CHAR 1 0
X Yes
NULL No
DISPTEXT1 Text, 40 Characters Long TEXT40 CHAR 40 0
DISPTEXT2 Text, 40 Characters Long TEXT40 CHAR 40 0
DISPTEXTW1 Text, 40 Characters Long TEXT40 CHAR 40 0
DISPTEXTW2 Text, 40 Characters Long TEXT40 CHAR 40 0
AUSTAT Determine Status ID Automatically AUSTAT CHAR 1 0
X Yes
NULL No
SELREPVAR Variant for Person Selection Report CATSREPVAR CHAR 14 0
WF_OBJECT Time Sheet: Workflow Object Type CATS_WF_OBJECT CHAR 2 0
S Position
US User
A Work center
C Job
O Organizational unit
ERGOBJEKT Detailed Info on Profitability Segment CATS_PAOBJNR CHAR 4 0
CPR_TEXT cProject Description CATS_CPR_TEXT CHAR 40 0
CPR_OBJTEXT Description of Project Subobject CATS_CPR_OBJTEXT CHAR 40 0

CATSFIELDS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CATSFIELDS DISTFUNC SYST MANDT TC29 Distribution key for capacity load MANDT
CATSFIELDS DISTFUNC CATSFIELDS DISTFUNC TC29 Distribution key for capacity load VERTL
CATSFIELDS KOKRS CATS_KEY MANDT TKA01 Controlling Areas MANDT
CATSFIELDS KOKRS CATSFIELDS KOKRS TKA01 Controlling Areas KOKRS
CATSFIELDS MEINH SY MANDT T006 Units of Measurement MANDT
CATSFIELDS MEINH CATSFIELDS MEINH T006 Units of Measurement MSEHI
CATSFIELDS OTYPE SY MANDT T778O Object Types MANDT
CATSFIELDS OTYPE CATSFIELDS OTYPE T778O Object Types OTYPE
CATSFIELDS SACHZ CATSFIELDS SBMOD T526 Administrators WERKS
CATSFIELDS SACHZ CATSFIELDS SACHZ T526 Administrators SACHX
CATSFIELDS SACHZ * T526 Administrators MANDT
CATSFIELDS SBMOD * T526 Administrators MANDT
CATSFIELDS SBMOD CATSFIELDS SBMOD T526 Administrators WERKS
CATSFIELDS SBMOD CATSFIELDS SACHZ T526 Administrators SACHX
CATSFIELDS SELKOSTL CATSFIELDS SELKOSTL CSKS Cost Center Master Data KOSTL
CATSFIELDS SELKOSTL * CSKS Cost Center Master Data DATBI
CATSFIELDS SELKOSTL CATS_KEY MANDT CSKS Cost Center Master Data MANDT
CATSFIELDS SELKOSTL CATSFIELDS KOKRS CSKS Cost Center Master Data KOKRS