SAP table CATSCO (Cross-Application Time Sheet (CATS): Transfer to CO)
SAP table CATSCO has 3 primary key fields being MANDT,COUNTER,STOKZ.
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 | MANDT | ||||||||||||||
COUNTER | Counter for Records in Time Recording | CHAR | 12 | 0 | CATSCOUNTE | ||||||||||||||
STOKZ | Indicator: Document was reversed | CHAR | 1 | 0 | CO_STOKZ | ||||||||||||||
PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||||||||||||||
WORKDATE | Date | DATS | 8 | 0 | CATSDATE | ||||||||||||||
CATSHOURS | Hours | QUAN | 4 | 2 | CATSHOURS | ||||||||||||||
SKOSTL | Sender Cost Center | CHAR | 10 | 0 | SKOSTL | ||||||||||||||
LSTAR | Activity Type | CHAR | 6 | 0 | LSTAR | ||||||||||||||
SPRZNR | Sender Business Process | CHAR | 12 | 0 | SPRZNR | ||||||||||||||
RKOSTL | Receiver Cost Center | CHAR | 10 | 0 | EKOSTL | ||||||||||||||
RPROJ | Receiver WBS Element | NUMC | 8 | 0 | EPROJ | ||||||||||||||
RAUFNR | Receiver Order | CHAR | 12 | 0 | EAUFNR | ||||||||||||||
RAUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||||||||||||||
RAPLZL | General counter for order | NUMC | 8 | 0 | CO_APLZL | ||||||||||||||
RKDAUF | Receiver sales order | CHAR | 10 | 0 | EKDAU | ||||||||||||||
RKDPOS | Item number in receiver sales order | NUMC | 6 | 0 | EKDPO | ||||||||||||||
RKSTR | Receiver cost object | CHAR | 12 | 0 | EKSTR | ||||||||||||||
RNPLNR | Network number | CHAR | 12 | 0 | NW_AUFNR | ||||||||||||||
RPRZNR | Receiver business process | CHAR | 12 | 0 | EPRZNR | ||||||||||||||
PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||||||||||||||
KOKRS | Controlling Area | CHAR | 4 | 0 | KOKRS | ||||||||||||||
LTXA1 | Confirmation text | CHAR | 40 | 0 | CO_RTEXT | ||||||||||||||
LOGSYS | Logical system | CHAR | 10 | 0 | LOGSYS | ||||||||||||||
BELNR | Document no. | CHAR | 10 | 0 | CATSBELNR | ||||||||||||||
REFCOUNTER | Reference Counter for Record to be Changed | CHAR | 12 | 0 | CATSREFCOU | ||||||||||||||
TRANSFER | Data Transferred to the Target Component | CHAR | 1 | 0 | CATSTRANSF | ||||||||||||||
MEINH | Unit of Measure for Display | UNIT | 3 | 0 | MEINH | ||||||||||||||
PRICE | Price in Transaction Currency | CURR | 11 | 2 | CATSPRICE | ||||||||||||||
TCURR | Transaction Currency | CUKY | 5 | 0 | TWAER | ||||||||||||||
HRKOSTL | Cost Center | CHAR | 10 | 0 | CATSHRKOSTL | ||||||||||||||
HRLSTAR | Activity Type | CHAR | 6 | 0 | CATSHRLSTAR | ||||||||||||||
HRCOSTASG | Cost Accounting Variants | CHAR | 1 | 0 | CATSHRCO |
|
|||||||||||||
STATKEYFIG | Statistical key figure | CHAR | 6 | 0 | STAGR | ||||||||||||||
CATSQUANTITY | Time Sheet: Number (Unit of Measure) | QUAN | 15 | 3 | CATSNUMBER | ||||||||||||||
UNIT | Unit of Measurement | UNIT | 3 | 0 | MSEHI | ||||||||||||||
BEMOT | Accounting Indicator | CHAR | 2 | 0 | BEMOT | ||||||||||||||
FUND | Receiver Fund | CHAR | 10 | 0 | FM_EFONDS | ||||||||||||||
FUNC_AREA | Receiving Functional Area | CHAR | 16 | 0 | EFKTBER | ||||||||||||||
GRANT_NBR | Receiver Grant | CHAR | 20 | 0 | GM_GRANT_RECEIVER | ||||||||||||||
S_FUND | Sender fund | CHAR | 10 | 0 | FM_SFONDS | ||||||||||||||
S_FUNC_AREA | Sending Functional Area | CHAR | 16 | 0 | SFKTBER | ||||||||||||||
S_GRANT_NBR | Sender Grant | CHAR | 20 | 0 | GM_GRANT_SENDER | ||||||||||||||
HRFUND | Master Fund | CHAR | 10 | 0 | CATSHRFUND | ||||||||||||||
HRFUNC_AREA | Master Functional Area | CHAR | 16 | 0 | CATSHRFUNC_AREA | ||||||||||||||
HRGRANT_NBR | Master Grant | CHAR | 20 | 0 | CATSHRGRANT_NBR | ||||||||||||||
BUDGET_PD | FM: Receiver Budget Period | CHAR | 10 | 0 | FM_EBUDGET_PERIOD | ||||||||||||||
SBUDGET_PD | FM: Sender Budget Period | CHAR | 10 | 0 | FM_SBUDGET_PERIOD | ||||||||||||||
HRBUDGET_PD | Master Budget Period | CHAR | 10 | 0 | CATSHR_BUDGET_PERIOD | ||||||||||||||
SERVICE_DOC_TYPE | Service Document Type | CHAR | 4 | 0 | FCO_SRVDOC_TYPE | ||||||||||||||
SERVICE_DOC_ID | Service Document ID | CHAR | 10 | 0 | FCO_SRVDOC_ID | ||||||||||||||
SERVICE_DOC_ITEM_ID | Service Document Item ID | NUMC | 6 | 0 | FCO_SRVDOC_ITEM_ID | ||||||||||||||
OVERTIMECAT | Overtime Category | CHAR | 4 | 0 | CATS_OVERTIME_CATEGORY | ||||||||||||||
WORK_ITEM_ID | Work Item ID | CHAR | 10 | 0 | /CPD/PFP_WORKITEM_ID | ||||||||||||||
DUMMY_INCL_EEW_PRS_CPILS | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY | ||||||||||||||
FM_SPLIT_FLG | Line Is Result of Account Assignment Drilldown | CHAR | 1 | 0 | FMSP_SPLIT_RESULT_FLAG |