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