SAP ABAP Table CATSDB (CATS: Database Table for Time Sheet)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ CA-TS (Application Component) Time Sheet
⤷ CATS (Package) Cross-application time sheet
⤷ CA-TS (Application Component) Time Sheet
⤷ CATS (Package) Cross-application time sheet
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CATSDB | Table Relationship Diagram |
Short Description | CATS: Database Table for Time Sheet |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | CATS: Key fields | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | COUNTER | CATSCOUNTE | CHAR12 | CHAR | 12 | 0 | Counter for Records in Time Recording | ||
4 | .INCLUDE | 0 | 0 | CATS: Secondary key | |||||
5 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
6 | WORKDATE | CATSDATE | DATUM | DATS | 8 | 0 | Date | ||
7 | .INCLUDE | 0 | 0 | CATS: Decoded Account Assignments | |||||
8 | SKOSTL | SKOSTL | KOSTL | CHAR | 10 | 0 | Sender Cost Center | * | |
9 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | CSLA | |
10 | SEBELN | SEBELN | EBELN | CHAR | 10 | 0 | Sending purchase order | * | |
11 | SEBELP | SEBELP | EBELP | NUMC | 5 | 0 | Sending purchase order item | * | |
12 | SPRZNR | SPRZNR | CO_PRZNR | CHAR | 12 | 0 | Sender Business Process | * | |
13 | LSTNR | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | * | |
14 | RKOSTL | EKOSTL | KOSTL | CHAR | 10 | 0 | Receiver Cost Center | * | |
15 | RPROJ | EPROJ | PS_POSNR | NUMC | 8 | 0 | Receiver WBS element | * | |
16 | RAUFNR | EAUFNR | AUFNR | CHAR | 12 | 0 | Receiver Order | * | |
17 | RNPLNR | NW_AUFNR | AUFNR | CHAR | 12 | 0 | Network number | * | |
18 | RAUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
19 | RAPLZL | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
20 | RKDAUF | EKDAU | VBELN | CHAR | 10 | 0 | Receiver sales order | * | |
21 | RKDPOS | EKDPO | POSNR | NUMC | 6 | 0 | Item number in receiver sales order | * | |
22 | RKSTR | EKSTR | KSTRG | CHAR | 12 | 0 | Receiver cost object | * | |
23 | RPRZNR | EPRZNR | CO_PRZNR | CHAR | 12 | 0 | Receiver business process | * | |
24 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
25 | FUND | FM_EFONDS | BP_GEBER | CHAR | 10 | 0 | Receiver fund | * | |
26 | FUNC_AREA | EFKTBER | FKBER | CHAR | 16 | 0 | Receiving Functional Area | * | |
27 | GRANT_NBR | GM_GRANT_RECEIVER | GM_GRANT_NBR | CHAR | 20 | 0 | Receiver Grant | ||
28 | S_FUND | FM_SFONDS | BP_GEBER | CHAR | 10 | 0 | Sender fund | * | |
29 | S_FUNC_AREA | SFKTBER | FKBER | CHAR | 16 | 0 | Sending Functional Area | * | |
30 | S_GRANT_NBR | GM_GRANT_SENDER | GM_GRANT_NBR | CHAR | 20 | 0 | Sender Grant | ||
31 | BUDGET_PD | FM_EBUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Receiver Budget Period | * | |
32 | SBUDGET_PD | FM_SBUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Sender Budget Period | * | |
33 | .INCLUDE | 0 | 0 | CATS: Include Structure for "Genuine" Account Assignments | |||||
34 | AWART | AWART | AWART | CHAR | 4 | 0 | Attendance or Absence Type | * | |
35 | LGART | LGART | LGART | CHAR | 4 | 0 | Wage Type | * | |
36 | KAPID | KAPID | KAPID | NUMC | 8 | 0 | Capacity ID | * | |
37 | SPLIT | CY_SPLIT | INT1 | INT1 | 3 | 0 | Split number | ||
38 | REINR | REINR | REINR | NUMC | 10 | 0 | Trip Number | ||
39 | WABLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
40 | VERSL | VRSCH | VRSCH | CHAR | 1 | 0 | Overtime Compensation Type | T555R | |
41 | WTART | HRWRKAR | HRWRKAR | CHAR | 4 | 0 | Tax area work center | * | |
42 | BWGRL | CATSBWGRL | WERTV7 | CURR | 13 | 2 | Valuation basis | ||
43 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
44 | AUFKZ | AUFKN | AUFKN | CHAR | 1 | 0 | Extra Pay Indicator | ||
45 | TRFGR | TRFGR | TRFGR | CHAR | 8 | 0 | Pay Scale Group | * | |
46 | TRFST | TRFST | TRFST | CHAR | 2 | 0 | Pay Scale Level | * | |
47 | PRAKN | PRAKN | PRAKN | CHAR | 2 | 0 | Premium Number | * | |
48 | PRAKZ | PRAKZ | PRAKZ | NUMC | 4 | 0 | Premium Indicator | ||
49 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
50 | PLANS | PLANS | PLANS | NUMC | 8 | 0 | Position | * | |
51 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
52 | MEINH | MEINH | MEINS | UNIT | 3 | 0 | Unit of Measure for Display | T006 | |
53 | TCURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
54 | PRICE | CATSPRICE | WERTV6 | CURR | 11 | 2 | Price in Transaction Currency | ||
55 | ARBID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
56 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
57 | AUTYP | AUFTYP | AUFTYP | NUMC | 2 | 0 | Order category | ||
58 | HRCOSTASG | CATSHRCO | CATSHRCO | CHAR | 1 | 0 | Cost Accounting Variants | ||
59 | HRKOSTL | CATSHRKOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
60 | HRLSTAR | CATSHRLSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
61 | HRFUND | CATSHRFUND | BP_GEBER | CHAR | 10 | 0 | Master Fund | * | |
62 | HRFUNC_AREA | CATSHRFUNC_AREA | FKBER | CHAR | 16 | 0 | Master Functional Area | * | |
63 | HRGRANT_NBR | CATSHRGRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Master Grant | ||
64 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
65 | UNIT | MSEHI | MEINS | UNIT | 3 | 0 | Unit of Measurement | * | |
66 | STATKEYFIG | STAGR | STAGR | CHAR | 6 | 0 | Statistical key figure | * | |
67 | TASKTYPE | CATSTASKTYPE | CATSTASKTYPE | CHAR | 4 | 0 | Task Type | ||
68 | TASKLEVEL | CATSTASKLEVEL | CATSTASKLEVEL | CHAR | 8 | 0 | Task Level | ||
69 | TASKCOMPONENT | CATSTASKCOMPONENT | CATSTASKCOMPONENT | CHAR | 8 | 0 | Task component | ||
70 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
71 | CPR_GUID | CATS_CPR_GUID | SYSUUID_C | CHAR | 32 | 0 | Project GUID | ||
72 | CPR_EXTID | CATS_CPR_EXTID | CHAR24 | CHAR | 24 | 0 | External Project ID | ||
73 | CPR_OBJGUID | CATS_CPR_OBJGUID | SYSUUID_C | CHAR | 32 | 0 | Object ID | ||
74 | CPR_OBJGEXTID | CATS_CPR_OBJGEXTID | CHAR24 | CHAR | 24 | 0 | External ID of Project Subobject | ||
75 | CPR_OBJTYPE | CATS_CPR_OBJTYPE | CHAR3 | CHAR | 3 | 0 | cProjects Object Type | ||
76 | HRBUDGET_PD | CATSHR_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | Master Budget Period | * | |
77 | .INCLUDE | 0 | 0 | CATS: Include structure for statistical information | |||||
78 | ERSDA | CATS_ERSDA | DATUM | DATS | 8 | 0 | Created on | ||
79 | ERSTM | CATS_CPUTM | UZEIT | TIMS | 6 | 0 | Time of Entry | ||
80 | ERNAM | CATS_ERNAM | USNAM | CHAR | 12 | 0 | User Who Created Record | ||
81 | LAEDA | CATS_LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
82 | LAETM | CATS_LAETM | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
83 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
84 | APNAM | CATSAPNAM | UNAME | CHAR | 12 | 0 | Name of person who approved data | ||
85 | APDAT | CATSAPDAT | DATUM | DATS | 8 | 0 | Date of Approval | ||
86 | WORKITEMID | SWW_WIID | SWW_WIID | NUMC | 12 | 0 | Work item ID | * | |
87 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
88 | STATUS | CATSSTATUS | CATSSTATUS | CHAR | 2 | 0 | Processing status | ||
89 | REFCOUNTER | CATSREFCOU | CHAR12 | CHAR | 12 | 0 | Reference Counter for Record to be Changed | ||
90 | REASON | CATSREASON | CATSREASON | CHAR | 4 | 0 | Reason for Rejection | * | |
91 | BELNR | CATSBELNR | BELNR | CHAR | 10 | 0 | Document number | ||
92 | EXTSYSTEM | HR_AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
93 | EXTAPPLICATION | HR_AWTYP | HR_AWTYP | CHAR | 5 | 0 | External Application | ||
94 | EXTDOCUMENTNO | HR_AWKEY | AWKEY | CHAR | 20 | 0 | Document number | ||
95 | TASKCOUNTER | CATSTASKCOUNTER | BELNR | CHAR | 10 | 0 | CATS: Task Counter | ||
96 | .INCLUDE | 0 | 0 | CATS: Include with Cell Information | |||||
97 | CATSHOURS | CATSHOURS | CATSHOURS | QUAN | 4 | 2 | Hours | ||
98 | BEGUZ | CATSBEGUZ | UZEIT | TIMS | 6 | 0 | Start time | ||
99 | ENDUZ | CATSENDUZ | UZEIT | TIMS | 6 | 0 | End time | ||
100 | VTKEN | VTKEN | XFELD | CHAR | 1 | 0 | Previous Day Indicator | ||
101 | ALLDF | ALLDF | XFELD | CHAR | 1 | 0 | Record is for Full Day | ||
102 | OFMNW | REMNW | ARBEIT | QUAN | 7 | 1 | Remaining work | ||
103 | PEDD | CO_PEDD | DATUM | DATS | 8 | 0 | Forecast finish date of operation from confirmation | ||
104 | AUERU | AUERU_VS | AUERU_VS | CHAR | 1 | 0 | Partial/Final Confirmation | ||
105 | LTXA1 | CATSSHORTT | TEXT40 | CHAR | 40 | 0 | Short Text | ||
106 | LONGTEXT | CATSLONGTE | XFELD | CHAR | 1 | 0 | Long Text | ||
107 | ERUZU | ERUZU | XFELD | CHAR | 1 | 0 | Indicator: Partial confirmation | ||
108 | CATSAMOUNT | CATSAMOUNT | CATSAMOUNT | CURR | 13 | 2 | CATS Amount | ||
109 | CATSQUANTITY | CATSNUMBER | CQUA8 | QUAN | 15 | 3 | Time Sheet: Number (Unit of Measure) | ||
110 | .INCLUDE | 0 | 0 | ||||||
111 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CATSDB | KOKRS | TKA01 | KOKRS | |||
2 | CATSDB | LSTAR | CSLA | LSTAR | |||
3 | CATSDB | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | CATSDB | MEINH | T006 | MSEHI | |||
5 | CATSDB | OTYPE | T778O | OTYPE | |||
6 | CATSDB | TCURR | TCURC | WAERS | |||
7 | CATSDB | VERSL | T555R | VME | |||
8 | CATSDB | WAERS | TCURC | WAERS | |||
9 | CATSDB | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |