SAP Time Sheet Tables
Are you looking for the right table related to SAP Time Sheet Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Time Sheet (CA-TS) module.
Top 10 tables in Time Sheet
| Table | Description |
|---|---|
| TCATX_COMP2TYPE | CATX: Assignment of Task Components to Task Type |
| PTRV_WAFLOG_CC | Offline Log File - Settings |
| TCATSDT | CATS: Text Table for Rejection Reasons |
| TCATS_EXC_RULE | Rules for Special Approval |
| TCATX_TASKTYPEST | CATX: Text Table for Task Types |
| CATS_REC_FIELDS | CATS: Table to hold CAC2 column set |
| CATS_APPR_PERSPT | CATS Approval: Text Table for Views |
| TCATS_EXC_RULET | Text Table for TCATS_EXC_RULE Table |
| CATS_MY_DOCU | CATS notebook: Create and Distribute HTML Documentation |
| TCATS_ITS | Time Sheet: Data Entry Profile ESS Scenario |
List of tables in Time Sheet
| Table | Description |
|---|---|
| TCATX_COMP2TYPE | CATX: Assignment of Task Components to Task Type |
| PTRV_WAFLOG_CC | Offline Log File - Settings |
| TCATSDT | CATS: Text Table for Rejection Reasons |
| TCATS_EXC_RULE | Rules for Special Approval |
| TCATX_TASKTYPEST | CATX: Text Table for Task Types |
| CATS_REC_FIELDS | CATS: Table to hold CAC2 column set |
| CATS_APPR_PERSPT | CATS Approval: Text Table for Views |
| TCATS_EXC_RULET | Text Table for TCATS_EXC_RULE Table |
| CATS_MY_DOCU | CATS notebook: Create and Distribute HTML Documentation |
| TCATS_ITS | Time Sheet: Data Entry Profile ESS Scenario |
| CATS_MY_UNITS | Units Used in CATS notebook |
| CATS_MY_PICKLIST | Additional Field Names for Which There Can Be Picklists |
| TCATX_COMP_DTL | CATX: Component Details |
| PTRV_OFFLINE_TXT | Texts for Download to Offline Creation Tools |
| CATSDEL | Table with Deletion Time of Deleted CATS Records |
| TCATX_LEVELST | CATX: Text Table for Task Levels |
| TCATX_TCR | CATX: Tabstrip Control |
| TCATP | Allowed Print Reports for CATS |
| TCATX_TCRT | CATX: Texts for Tabstrip Control |
| CATS_APPR_LINK | Link Between Approval Views and Profiles |
| TCATX_AKT | CATX: Access Key for Transaction Control |
| PTRV_APPL_KEY | Application |
| TCATX_GRID | CATX: Column Assignment for Data Entry Table |
| PTRV_WAFLOG | Log File for Inbound Container in Travel Management |
| TCATX_AK | CATX: Access Key for Transaction Control |
| TCATS_EXC_GROUP | Rule Groups for Special Approval |
| CATS_BIW_DELTA | Transfer Time Sheet Data to BW: Document Numbers |
| TCATSAT | CATS: Text for Profile Authorization Group |
| CATSMM | Cross-Application Time Sheet (CATS): Transfer to MM |
| CATS_BIW_SELOPT | Selection Criteria for Delta Management (CATS -> BW) |
| TCATX_TASKTYPES | CATX: Task Types |
| CATS_MY_TEXTS | Obsolete |
| TCATS_EXC_LINK | Link Between Rule Group and Rule (Special Approval) |
| PTRV_WAF_FSEL | Code Conversion: Screen Field Name into BAPI/Offline Names |
| CATS_ARCH_IDX | CATS Index Table for Data Object Selection |
| CATS_MY_PUSH | CATS notebook: Synchronize Static Objects |
| CATSDB | CATS: Database Table for Time Sheet |
| CCATSCOSUM | Settings: Summarization Time Sheet Data -> CO |
| CATS_MY_FIELDSEL | CATS notebook: Field Selections |
| CATS_APPR_CUSTT | CATS Approval: Text Table for Profiles |
| TAFLD | Assignment of Application Fields to Components |
| TCATX_ACCOBJ | Next Screen Processing: Account Assignment Object |
| CATSCO | Cross-Application Time Sheet (CATS): Transfer to CO |
| CATSPM | Cross-Application Time Sheet (CATS): Transfer to PM/CS |
| TCATX_COCONV | CATX: Conversion of CO Fields into CATS Fields |
| TCATX_SCRT | CATX: Texts for Subscreen Area Control |
| CATS_APPR_CUST | Storage of Information Not Dependent on Display |
| TCAFI | Additional Customer Fields in CATS |
| TCATX_COMPONENTT | CATX: Text Table for Task Components |
| CATS_GUID_KEY | Link: GUID and External Cats Key |
| CATS_DEF_ACCOUNT | CATS Default Accounting |
| TCATSA | CATS: Profile Authorization Groups |
| CATSOFFTRANSKEY | Table of CATS Offline Transaction Keys |
| CATS_MY_FIXTEXTS | Obsolete |
| TCAFI_SER_ATTR | Service Attribute Fields in CATS |
| CATS_APPR_FIELDS | CATS Approval: Fields for Consolidation |
| TCATSDLIST | CATS: Profile for Reporting (List Display) |
| CATS_APPR_PERSP | Approval Views |
| TXSSCAT_FIELD_C | CATS FACE: Field Selection Customizing |
| TCATS_EXC_GROUPT | Description of Rule Group |
| TCATX_COMPONENTS | CATX: Task Components |
| TCATX_LEVEL2TYPE | CATX: Assignment of Task Levels to Components |
| CATS_TEMP | CATS: Database Table for Templates |
| CABA_COMPONENT_T | Working Time Component |
| TCATS | CATS: Data Entry Profiles |
| TCATX_LEVELS | CATX: Task Levels |
| TCATPT | Texts for Allowed Print Reports for CATS |
| TCATSD | CATS: Rejection Reasons |
| CATS_MY_FIXTEXT2 | Fixed Texts for CATS notebook |
| BASICS_PICKLIST | Function Modules for Offline Picklists |
| TCATS_SHLP_ITS | Time Sheet: Possible Entries Help in Internet |
| TCATX_DEDUC | CATX: Data Derived from Type/Component/Level |
| CATS_MY_DATES | CATS notebook: Periods for Target Hours and Data Storage |
| PTRV_SYNC | Customizing Synchronization with Offline Device |
| CATS_MY_TEXTS_C | Customer-Specific Field Texts for CATS notebook |
| TCATX_SCR | CATX: Subscreen Control |
| CATS_MY_TEXTS2 | References to Data Elements for CATS notebook Field Texts |
| CATSCOSUM | Data Transfer: Time Sheet -> CO Summarization Table |
| CABAREF | CATS: Transfer from CATS II to PS, PM, and CO |
| PTRV_APPL_KEY_TX | Application text |
| TCATST | CATS: Text Table for Variants |
| CATSPS | Cross-Application Time Sheet (CATS): Transfer to PS |
| CATS_BW_TIME | Transfer Time Sheet into BW - Time Stamp |
| TCATX_CC | CATX: Central Functions |