CATSDB is a standard Time Sheet Transparent Table in SAP Cross Application application, which stores CATS: Database Table for Time Sheet data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for CATSDB. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

CATSDB — Meta Data

Description: CATS: Database Table for Time Sheet
Main Category: Cross Application
Sub Category: Time Sheet
Table type: Transparent Table (TRANSP)

CATSDB — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 .INCLUDE X 0
    2 MANDT Client X CLNT 3 T000
    3 COUNTER SAP Workload: Workload: RFC number of records X CHAR 12
    4 .INCLUDE 0
    5 PERNR Personnel No. NUMC 8
    6 WORKDATE Date DATS 8
    7 .INCLUDE 0
    8 SKOSTL Sender Cost Center CHAR 10 *
    9 LSTAR Activity Type CHAR 6 CSLA
    10 SEBELN Sending purchase order CHAR 10 *
    11 SEBELP Sending purchase order item NUMC 5 *
    12 SPRZNR Sender Business Process CHAR 12 *
    13 LSTNR Service Number CHAR 18 *
    14 RKOSTL Cost Center CHAR 10 *
    15 RPROJ Wbs Element NUMC 8 *
    16 RAUFNR Order Number CHAR 12 *
    17 RNPLNR Network number CHAR 12 *
    18 RAUFPL Routing number of operations in the order NUMC 10
    19 RAPLZL General counter for order NUMC 8 *
    20 RKDAUF Receiver sales order CHAR 10
    21 RKDPOS Item number in receiver sales order NUMC 6 *
    22 RKSTR Receiver cost object CHAR 12 *
    23 RPRZNR Receiver business process CHAR 12 *
    24 PAOBJNR Profitability Segment Number (CO-PA) NUMC 10
    25 FUND Fund CHAR 10 *
    26 FUNC_AREA Functional Area CHAR 16 *
    27 GRANT_NBR Grant CHAR 20
    28 S_FUND Sender fund CHAR 10 *
    29 S_FUNC_AREA Sending Functional Area CHAR 16 *
    30 S_GRANT_NBR Sender Grant CHAR 20
    31 BUDGET_PD Budget Period CHAR 10 *
    32 SBUDGET_PD Budget Period CHAR 10 *
    33 .INCLUDE 0
    34 WORK_ITEM_ID SWW_WIID (NUMC(12)) CHAR 10
    35 .INCLUDE 0
    36 AWART Attendance or Absence Type CHAR 4 *
    37 LGART Wage Type CHAR 4 *
    38 KAPID Capacity ID NUMC 8 *
    39 SPLIT WCR Split INT1 3
    40 REINR Trip Number NUMC 10
    41 WABLNR Number of Material Document CHAR 10
    42 VERSL Overtime Compensation Type CHAR 1 T555R
    43 WTART Tax area work center CHAR 4 *
    44 BWGRL Valuation Basis for Different Payment CURR 13
    45 WAERS Currency CUKY 5 TCURC
    46 AUFKZ Extra Pay Indicator CHAR 1
    47 TRFGR Pay Scale Group CHAR 8 *
    48 TRFST PS level CHAR 2 *
    49 PRAKN Premium Number CHAR 2 *
    50 PRAKZ Premium Indicator NUMC 4
    51 OTYPE Object Type CHAR 2 T778O
    52 PLANS Position NUMC 8 *
    53 KOKRS CO Area CHAR 4 TKA01
    54 MEINH Unit of Measure UNIT 3 T006
    55 TCURR Currency Key CUKY 5 TCURC
    56 PRICE Price CURR 11
    57 ARBID Operating resources object ID NUMC 8
    58 WERKS Plant CHAR 4 T001W
    59 AUTYP Order Category NUMC 2
    60 HRCOSTASG Cost Accounting Variants CHAR 1
    61 HRKOSTL Cost Center CHAR 10 *
    62 HRLSTAR Activity Type CHAR 6
    63 HRFUND Master Fund CHAR 10 *
    64 HRFUNC_AREA Master Functional Area CHAR 16 *
    65 HRGRANT_NBR Master Grant CHAR 20
    66 BEMOT Accounting Indicator CHAR 2 *
    67 UNIT Order unit UNIT 3 *
    68 STATKEYFIG Statistical key figure CHAR 6 *
    69 TASKTYPE SAP Workload: Accounting exit: Task type (from Release 3.0) CHAR 4
    70 TASKLEVEL Task Level CHAR 8
    71 TASKCOMPONENT Task component CHAR 8
    72 BUKRS Company Code CHAR 4
    73 CPR_GUID Generic project planning: GUID from external R/3 system CHAR 32
    74 CPR_EXTID External Project ID CHAR 24
    75 CPR_OBJGUID Object ID CHAR 32
    76 CPR_OBJGEXTID External ID of Project Subobject CHAR 24
    77 CPR_OBJTYPE cProjects Object Type CHAR 3
    78 HRBUDGET_PD Master Budget Period CHAR 10 *
    79 .INCLUDE 0
    80 ERSDA Character field, 8 characters long DATS 8
    81 ERSTM Time of Entry TIMS 6
    82 ERNAM Created by CHAR 12
    83 LAEDA Date of Last Change DATS 8
    84 LAETM Last Changed At TIMS 6
    85 AENAM Name of Person Who Changed Object CHAR 12
    86 APNAM Name of person who approved data CHAR 12
    87 APDAT Date of Approval DATS 8
    88 WORKITEMID Work item ID NUMC 12 *
    89 LOGSYS Logical system CHAR 10 *
    90 STATUS Indicates whether a Call-off is valid or invalid CHAR 2
    91 REFCOUNTER Reference Counter for Record to be Changed CHAR 12
    92 REASON Reason of Rejection CHAR 4 *
    93 BELNR Document Number CHAR 10
    94 EXTSYSTEM Logical system of source document CHAR 10 *
    95 EXTAPPLICATION External Application CHAR 5
    96 EXTDOCUMENTNO Document number CHAR 20
    97 TASKCOUNTER CATS: Task Counter CHAR 10
    98 .INCLUDE 0
    99 CATSHOURS Hours QUAN 4
    100 BEGUZ Start Time TIMS 6
    101 ENDUZ End Time TIMS 6
    102 VTKEN Previous Day Indicator CHAR 1
    103 ALLDF Record is for Full Day CHAR 1
    104 OFMNW Forecasted work (actual + remaining) QUAN 7
    105 PEDD Forecast finish date of operation from confirmation DATS 8
    106 AUERU Partial/Final Confirmation CHAR 1
    107 LTXA1 Opr. short text CHAR 40
    108 LONGTEXT Longtext CHAR 1
    109 ERUZU Indicator: Partial confirmation CHAR 1
    110 CATSAMOUNT CATS Amount CURR 13
    111 CATSQUANTITY Time Sheet: Number (Unit of Measure) QUAN 15
    112 .INCLUDE 0
    113 .INCLUDE 0
    114 .INCLUDE 0
    115 DUMMY_INCL_EEW_PRS_CPILS Dummy function in length 1 CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on CATSDB

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
PTEX2000 Interface Table for Attendances/Absences Infotype(2001/2002) Personnel Time Management - Personnel Time Management
PA0001 HR Master Record: Infotype 0001 (Org. Assignment) Personnel Mgmt - Personnel Administration
CATSCO Cross-Application Time Sheet (CATS): Transfer to CO Cross Application - Time Sheet
CATSPS Cross-Application Time Sheet (CATS): Transfer to PS Cross Application - Time Sheet
CI_CATSDB CATS customer extension
CATSPM Cross-Application Time Sheet (CATS): Transfer to PM/CS Cross Application - Time Sheet
T554T Absence and Attendance Texts Personnel Time Management - Personnel Time Management

Transaction Codes for SAP Table CATSDB

TCODE Description Functional Area
CATS CATS: Cross-Application Time CA - Arbeitszeitblatt
CAT2 Time Sheet: Maintain Times Cross Application - Time Sheet
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
CAT6 Transfer External -> Time Management PT - Attendances/Absences
CAC1 Time Sheet: Maintain Profiles CA - Arbeitszeitblatt
CATA Transfer to Target Components PT - Attendances/Absences
CAC2 Time Sheet: Field Selection CA - Arbeitszeitblatt
CADO Time Sheet: Display Data CA - Arbeitszeitblatt

FMs for SAP Table CATSDB

FM Description Functional Area
BAPI_CATIMESHEETMGR_INSERT CATS: Insert data records Cross Application - Time Sheet
BAPI_CATIMESHEETMGR_CHANGE CATS: Change data records Cross Application - Time Sheet
BAPI_CATIMESHEETMGR_DELETE CATS: Delete Data Records Cross Application - Time Sheet
MASTER_IDOC_DISTRIBUTE Application interface to the ALE layer on outbound processing side Basis - ALE Integration Technology
BAPI_CATIMESHEETRECORD_GETLIST Time Sheet: Data Record List Cross Application - Time Sheet
BAPI_TRANSACTION_COMMIT Execute external Commit when using BAPIs Basis - ALE Integration Technology
EXIT_SAPLCATS_008 CATS: Import Data from Customer Dialog Box Cross Application - Time Sheet
USER_SETTINGS User settings Basis - Terminology/Glossary

ABAP Reports for SAP Table CATSDB

ABAP REPORT Description Functional Area
RPTEXTPT Transfer Time Data to HR Time Management Personnel Time Management - Personnel Time Management
SELECTION Include SELECTION SD - POS Interface
CATSSHOW Display Time Sheet Data Cross Application - Time Sheet
RCATSRIF Reorganize Time Sheet Interface Tables Cross Application - Time Sheet
SPRSL TEXT 630 - Workbench Tools: Editors
SAPLCATS Cross-Application Time Sheet
RCATSTCO CATS: Transfer to Controlling Cross Application - Time Sheet
RCATSDEL Time Sheet: Delete Transaction Data Cross Application - Time Sheet

BW Datasources for SAP Table CATSDB

BW DATASOURCE Description Functional Area
0CA_TS_IS_1 Extractor CATS -
0CA_TS_IS_2 CATS Extractor (Records for Approval) -
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0HR_PT_2 Actual personnel times Personnel Time Management - Personnel Time Management
0HR_PA_OS_1 Staffing Assignments -
0CO_OM_CCA_9 Cost Centers: Actual Costs Using Delta Extraction CO - Cost Center Accounting
0CO_OM_WBS_3 WBS elements: Overall plan CO - Overhead Projects
0HR_PA_1 Personnel Actions Personnel Mgmt - Personnel Administration

Authorization Objects for SAP Table CATSDB

AUTHORIZATION OBJECT Description Functional Area
P_PERNR HR: Master Data - Personnel Number Check
S_TABU_DIS Table Maintenance (via standard tools such as SM30)
CMS_CAG Authorization object for CAG
J_1IEWT_HC health check for Migration to EWT
L_LGNUM Warehouse Number / Storage Type
P_ORGXX HR: Master Data - Extended Check
S_DEVELOP ABAP Workbench
ECM_REQ Change Management: Change Request