CATSDB is a SAP table coming under CA module and SAP_APPL component.View details, Fields & related tables of CATSDB in SAP.
- Table description : CATS: Database Table for Time Sheet
- Module : CA-TS
- Parent Module : CA
- Package : CATS
- Software Component : SAP_APPL
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CATSDB Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
.INCLUDE | CATS: Key fields | ||
MANDT | Client | MANDT | MANDT |
COUNTER | Counter for Records in Time Recording | CATSCOUNTE | CHAR12 |
.INCLUDE | CATS: Secondary key | ||
PERNR | Personnel Number | PERNR_D | PERNR |
WORKDATE | Date | CATSDATE | DATUM |
.INCLUDE | CATS: Decoded Account Assignments | ||
SKOSTL | Sender Cost Center | SKOSTL | KOSTL |
LSTAR | Activity Type | LSTAR | LSTAR |
SEBELN | Sending purchase order | SEBELN | EBELN |
SEBELP | Sending purchase order item | SEBELP | EBELP |
SPRZNR | Sender Business Process | SPRZNR | CO_PRZNR |
LSTNR | Activity Number | ASNUM | ASNUM |
RKOSTL | Receiver Cost Center | EKOSTL | KOSTL |
RPROJ | Receiver WBS element | EPROJ | PS_POSNR |
RAUFNR | Receiver Order | EAUFNR | AUFNR |
RNPLNR | Network number | NW_AUFNR | AUFNR |
RAUFPL | Routing number of operations in the order | CO_AUFPL | AUFPL |
RAPLZL | General counter for order | CO_APLZL | CO_APLZL |
RKDAUF | Receiver sales order | EKDAU | VBELN |
RKDPOS | Item number in receiver sales order | EKDPO | POSNR |
RKSTR | Receiver cost object | EKSTR | KSTRG |
RPRZNR | Receiver business process | EPRZNR | CO_PRZNR |
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | RKEOBJNR |
FUND | Receiver fund | FM_EFONDS | BP_GEBER |
FUNC_AREA | Receiving Functional Area | EFKTBER | FKBER |
GRANT_NBR | Receiver Grant | GM_GRANT_RECEIVER | GM_GRANT_NBR |
S_FUND | Sender fund | FM_SFONDS | BP_GEBER |
S_FUNC_AREA | Sending Functional Area | SFKTBER | FKBER |
S_GRANT_NBR | Sender Grant | GM_GRANT_SENDER | GM_GRANT_NBR |
BUDGET_PD | FM: Receiver Budget Period | FM_EBUDGET_PERIOD | FM_BUDGET_PERIOD |
SBUDGET_PD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | FM_BUDGET_PERIOD |
.INCLUDE | CATS: Include Structure for "Genuine" Account Assignments | ||
AWART | Attendance or Absence Type | AWART | AWART |
LGART | Wage Type | LGART | LGART |
KAPID | Capacity ID | KAPID | KAPID |
SPLIT | Split number | CY_SPLIT | INT1 |
REINR | Trip Number | REINR | REINR |
WABLNR | Number of Material Document | MBLNR | BELNR |
VERSL | Overtime Compensation Type | VRSCH | VRSCH |
WTART | Tax area work center | HRWRKAR | HRWRKAR |
BWGRL | Valuation basis | CATSBWGRL | WERTV7 |
WAERS | Currency Key | WAERS | WAERS |
AUFKZ | Extra Pay Indicator | AUFKN | AUFKN |
TRFGR | Pay Scale Group | TRFGR | TRFGR |
TRFST | Pay Scale Level | TRFST | TRFST |
PRAKN | Premium Number | PRAKN | PRAKN |
PRAKZ | Premium Indicator | PRAKZ | PRAKZ |
OTYPE | Object Type | OTYPE | OTYPE |
PLANS | Position | PLANS | PLANS |
KOKRS | Controlling Area | KOKRS | CACCD |
MEINH | Unit of Measure for Display | MEINH | MEINS |
TCURR | Transaction Currency | TWAER | WAERS |
PRICE | Price in Transaction Currency | CATSPRICE | WERTV6 |
ARBID | Object ID | OBJEKTID | NUM08 |
WERKS | Plant | WERKS_D | WERKS |
AUTYP | Order category | AUFTYP | AUFTYP |
HRCOSTASG | Cost Accounting Variants | CATSHRCO | CATSHRCO |
HRKOSTL | Cost Center | CATSHRKOSTL | KOSTL |
HRLSTAR | Activity Type | CATSHRLSTAR | LSTAR |
HRFUND | Master Fund | CATSHRFUND | BP_GEBER |
HRFUNC_AREA | Master Functional Area | CATSHRFUNC_AREA | FKBER |
HRGRANT_NBR | Master Grant | CATSHRGRANT_NBR | GM_GRANT_NBR |
BEMOT | Accounting Indicator | BEMOT | BEMOT |
UNIT | Unit of Measurement | MSEHI | MEINS |
STATKEYFIG | Statistical key figure | STAGR | STAGR |
TASKTYPE | Task Type | CATSTASKTYPE | CATSTASKTYPE |
TASKLEVEL | Task Level | CATSTASKLEVEL | CATSTASKLEVEL |
TASKCOMPONENT | Task component | CATSTASKCOMPONENT | CATSTASKCOMPONENT |
BUKRS | Company Code | BUKRS | BUKRS |
CPR_GUID | Project GUID | CATS_CPR_GUID | SYSUUID_C |
CPR_EXTID | External Project ID | CATS_CPR_EXTID | CHAR24 |
CPR_OBJGUID | Object ID | CATS_CPR_OBJGUID | SYSUUID_C |
CPR_OBJGEXTID | External ID of Project Subobject | CATS_CPR_OBJGEXTID | CHAR24 |
CPR_OBJTYPE | cProjects Object Type | CATS_CPR_OBJTYPE | CHAR3 |
HRBUDGET_PD | Master Budget Period | CATSHR_BUDGET_PERIOD | FM_BUDGET_PERIOD |
.INCLUDE | CATS: Include structure for statistical information | ||
ERSDA | Created on | CATS_ERSDA | DATUM |
ERSTM | Time of Entry | CATS_CPUTM | UZEIT |
ERNAM | User Who Created Record | CATS_ERNAM | USNAM |
LAEDA | Date of Last Change | CATS_LAEDA | DATUM |
LAETM | Time of Last Change | CATS_LAETM | UZEIT |
AENAM | Name of Person Who Changed Object | AENAM | USNAM |
APNAM | Name of person who approved data | CATSAPNAM | UNAME |
APDAT | Date of Approval | CATSAPDAT | DATUM |
WORKITEMID | Work item ID | SWW_WIID | SWW_WIID |
LOGSYS | Logical system | LOGSYS | LOGSYS |
STATUS | Processing status | CATSSTATUS | CATSSTATUS |
REFCOUNTER | Reference Counter for Record to be Changed | CATSREFCOU | CHAR12 |
REASON | Reason for Rejection | CATSREASON | CATSREASON |
BELNR | Document number | CATSBELNR | BELNR |
EXTSYSTEM | Logical system of source document | HR_AWSYS | LOGSYS |
EXTAPPLICATION | External Application | HR_AWTYP | HR_AWTYP |
EXTDOCUMENTNO | Document number | HR_AWKEY | AWKEY |
TASKCOUNTER | CATS: Task Counter | CATSTASKCOUNTER | BELNR |
.INCLUDE | CATS: Include with Cell Information | ||
CATSHOURS | Hours | CATSHOURS | CATSHOURS |
BEGUZ | Start time | CATSBEGUZ | UZEIT |
ENDUZ | End time | CATSENDUZ | UZEIT |
VTKEN | Previous Day Indicator | VTKEN | XFELD |
ALLDF | Record is for Full Day | ALLDF | XFELD |
OFMNW | Remaining work | REMNW | ARBEIT |
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATUM |
AUERU | Partial/Final Confirmation | AUERU_VS | AUERU_VS |
LTXA1 | Short Text | CATSSHORTT | TEXT40 |
LONGTEXT | Long Text | CATSLONGTE | XFELD |
ERUZU | Indicator: Partial confirmation | ERUZU | XFELD |
CATSAMOUNT | CATS Amount | CATSAMOUNT | CATSAMOUNT |
CATSQUANTITY | Time Sheet: Number (Unit of Measure) | CATSNUMBER | CQUA8 |
.INCLUDE | |||
.INCLUDE |
CATSDB related tables
Table | Note |
---|---|
CATSDB | CATS: Database Table for Time Sheet |
CATSCO | Cross-Application Time Sheet (CATS): Transfer to CO |
CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR |
CATSMM | Cross-Application Time Sheet (CATS): Transfer to MM |
CATSPM | Cross-Application Time Sheet (CATS): Transfer to PM/CS |
CATSPS | Cross-Application Time Sheet (CATS): Transfer to PS |
CABAREF | CATS: Transfer from CATS II to PS, PM, and CO |
/SAPSLL/TLEPGS | Mapping of FS Grouping Item Cats to Customs Doc. Item Cats |
/SAPSLL/TLEPVS | Mapping of Feeder System Item Cats to Customs Doc. Item Cats |
CATS_TEMP | CATS: Database Table for Templates |
CATS_BW_TIME | Transfer Time Sheet into BW - Time Stamp |
TABWM | Asgnmt. hist. sheet (sub)groups to asset history sheet item |
CATSDEL | Table with Deletion Time of Deleted CATS Records |
MYABK | Bal. Sheet Valuation: Table of Database Commits Carried Out |
MYCOM | Bal. Sheet Valuation: Table of Database Commits Carried Out |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP