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 |
Possible values
|
||||||||||||
FREE | Records Released for Approval | CATSFREE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
APPR | Records that Are Approved | CATSAPPR_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||
REJE | Records That Were Not Approved | CATSREJE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
CHNG | Record that Was Changed and Has a Follow-On Record | CATSCHANGE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
VOID | Cancelled Records | CATSVOID | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
ASTERISK | Line Type on Data Entry Screen | CATSASTERI | CHAR | 132 | 0 | |||||||||||||
PERMARK | Selection Column | CATSMARK | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
RVCLO | Confirmed Operations from the Confirmation Pool | RVCLO | CHAR | 1 | 0 |
Possible values
|
||||||||||||
RVALL | All Operations from Confirmation Pool | RVALL | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
DISTDIST | Calculate Hours Using Distribution Function | DISTDIST | CHAR | 1 | 0 |
Possible values
|
||||||||||||
DISTDAY | Hours per Cell | DISTDAY | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
SELREPVAR | Variant for Person Selection Report | CATSREPVAR | CHAR | 14 | 0 | |||||||||||||
WF_OBJECT | Time Sheet: Workflow Object Type | CATS_WF_OBJECT | CHAR | 2 | 0 |
Possible values
|
||||||||||||
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 |