SAP ABAP Table HRMSS_CAT_APPR_CATSDB_EXT_DET (CATS Approval: CATSDB Fields for Display)
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷ CA-TS (Application Component) Time Sheet
⤷ PAOC_CATS_APPR_CUSTOMIZING (Package) CATS Consolidation Approval: Customizing
⤷ CA-TS (Application Component) Time Sheet
⤷ PAOC_CATS_APPR_CUSTOMIZING (Package) CATS Consolidation Approval: Customizing
Basic Data
Table Category | INTTAB | Structure |
Structure | HRMSS_CAT_APPR_CATSDB_EXT_DET | Table Relationship Diagram |
Short Description | CATS Approval: CATSDB Fields for Display |
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 | COUNTER | CATSCOUNTE | CHAR12 | CHAR | 12 | 0 | Counter for Records in Time Recording | ||
2 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
3 | WORKDATE | CATSDATE | DATUM | DATS | 8 | 0 | Date | ||
4 | SKOSTL | SKOSTL | KOSTL | CHAR | 10 | 0 | Sender Cost Center | * | |
5 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | CSLA | |
6 | SEBELN | SEBELN | EBELN | CHAR | 10 | 0 | Sending purchase order | * | |
7 | SEBELP | SEBELP | EBELP | NUMC | 5 | 0 | Sending purchase order item | * | |
8 | SPRZNR | SPRZNR | CO_PRZNR | CHAR | 12 | 0 | Sender Business Process | * | |
9 | LSTNR | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | * | |
10 | RKOSTL | EKOSTL | KOSTL | CHAR | 10 | 0 | Receiver Cost Center | * | |
11 | RAUFNR | EAUFNR | AUFNR | CHAR | 12 | 0 | Receiver Order | * | |
12 | RNPLNR | NW_AUFNR | AUFNR | CHAR | 12 | 0 | Network number | * | |
13 | RKDAUF | EKDAU | VBELN | CHAR | 10 | 0 | Receiver sales order | * | |
14 | RKDPOS | EKDPO | POSNR | NUMC | 6 | 0 | Item number in receiver sales order | * | |
15 | RKSTR | EKSTR | KSTRG | CHAR | 12 | 0 | Receiver cost object | * | |
16 | RPRZNR | EPRZNR | CO_PRZNR | CHAR | 12 | 0 | Receiver business process | * | |
17 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
18 | FUND | FM_EFONDS | BP_GEBER | CHAR | 10 | 0 | Receiver fund | * | |
19 | FUNC_AREA | EFKTBER | FKBER | CHAR | 16 | 0 | Receiving Functional Area | * | |
20 | GRANT_NBR | GM_GRANT_RECEIVER | GM_GRANT_NBR | CHAR | 20 | 0 | Receiver Grant | ||
21 | S_FUND | FM_SFONDS | BP_GEBER | CHAR | 10 | 0 | Sender fund | * | |
22 | S_FUNC_AREA | SFKTBER | FKBER | CHAR | 16 | 0 | Sending Functional Area | * | |
23 | S_GRANT_NBR | GM_GRANT_SENDER | GM_GRANT_NBR | CHAR | 20 | 0 | Sender Grant | ||
24 | AWART | AWART | AWART | CHAR | 4 | 0 | Attendance or Absence Type | * | |
25 | LGART | LGART | LGART | CHAR | 4 | 0 | Wage Type | * | |
26 | SPLIT | CY_SPLIT | INT1 | INT1 | 3 | 0 | Split number | ||
27 | REINR | REINR | REINR | NUMC | 10 | 0 | Trip Number | ||
28 | WABLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
29 | VERSL | VRSCH | VRSCH | CHAR | 1 | 0 | Overtime Compensation Type | T555R | |
30 | WTART | HRWRKAR | HRWRKAR | CHAR | 4 | 0 | Tax area work center | ||
31 | BWGRL | CATSBWGRL | WERTV7 | CURR | 13 | 2 | Valuation basis | ||
32 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
33 | AUFKZ | AUFKN | AUFKN | CHAR | 1 | 0 | Extra Pay Indicator | ||
34 | TRFGR | TRFGR | TRFGR | CHAR | 8 | 0 | Pay Scale Group | * | |
35 | TRFST | TRFST | TRFST | CHAR | 2 | 0 | Pay Scale Level | * | |
36 | PRAKN | PRAKN | PRAKN | CHAR | 2 | 0 | Premium Number | * | |
37 | PRAKZ | PRAKZ | PRAKZ | NUMC | 4 | 0 | Premium Indicator | ||
38 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
39 | PLANS | PLANS | PLANS | NUMC | 8 | 0 | Position | * | |
40 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
41 | MEINH | MEINH | MEINS | UNIT | 3 | 0 | Unit of Measure for Display | T006 | |
42 | TCURR | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
43 | PRICE | CATSPRICE | WERTV6 | CURR | 11 | 2 | Price in Transaction Currency | ||
44 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
45 | HRCOSTASG | CATSHRCO | CATSHRCO | CHAR | 1 | 0 | Cost Accounting Variants | ||
46 | HRKOSTL | CATSHRKOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
47 | HRLSTAR | CATSHRLSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | * | |
48 | HRFUND | CATSHRFUND | BP_GEBER | CHAR | 10 | 0 | Master Fund | * | |
49 | HRFUNC_AREA | CATSHRFUNC_AREA | FKBER | CHAR | 16 | 0 | Master Functional Area | * | |
50 | HRGRANT_NBR | CATSHRGRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Master Grant | ||
51 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
52 | UNIT | MSEHI | MEINS | UNIT | 3 | 0 | Unit of Measurement | * | |
53 | STATKEYFIG | STAGR | STAGR | CHAR | 6 | 0 | Statistical key figure | * | |
54 | CPR_EXTID | CATS_CPR_EXTID | CHAR24 | CHAR | 24 | 0 | External Project ID | ||
55 | CPR_OBJGEXTID | CATS_CPR_OBJGEXTID | CHAR24 | CHAR | 24 | 0 | External ID of Project Subobject | ||
56 | TASKTYPE | CATSTASKTYPE | CATSTASKTYPE | CHAR | 4 | 0 | Task Type | ||
57 | TASKLEVEL | CATSTASKLEVEL | CATSTASKLEVEL | CHAR | 8 | 0 | Task Level | ||
58 | TASKCOMPONENT | CATSTASKCOMPONENT | CATSTASKCOMPONENT | CHAR | 8 | 0 | Task component | ||
59 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
60 | ERSDA | CATS_ERSDA | DATUM | DATS | 8 | 0 | Created on | ||
61 | ERSTM | CATS_CPUTM | UZEIT | TIMS | 6 | 0 | Time of Entry | ||
62 | ERNAM | CATS_ERNAM | USNAM | CHAR | 12 | 0 | User Who Created Record | ||
63 | LAEDA | CATS_LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
64 | LAETM | CATS_LAETM | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
65 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
66 | APNAM | CATSAPNAM | UNAME | CHAR | 12 | 0 | Name of person who approved data | ||
67 | APDAT | CATSAPDAT | DATUM | DATS | 8 | 0 | Date of Approval | ||
68 | WORKITEMID | SWW_WIID | SWW_WIID | NUMC | 12 | 0 | Work item ID | * | |
69 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
70 | STATUS | CATSSTATUS | CATSSTATUS | CHAR | 2 | 0 | Processing status | ||
71 | REFCOUNTER | CATSREFCOU | CHAR12 | CHAR | 12 | 0 | Reference Counter for Record to be Changed | ||
72 | REASON | CATSREASON | CATSREASON | CHAR | 4 | 0 | Reason for Rejection | * | |
73 | BELNR | CATSBELNR | BELNR | CHAR | 10 | 0 | Document number | ||
74 | EXTSYSTEM | HR_AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
75 | EXTAPPLICATION | HR_AWTYP | HR_AWTYP | CHAR | 5 | 0 | External Application | ||
76 | EXTDOCUMENTNO | HR_AWKEY | AWKEY | CHAR | 20 | 0 | Document number | ||
77 | TASKCOUNTER | CATSTASKCOUNTER | BELNR | CHAR | 10 | 0 | CATS: Task Counter | ||
78 | CATSHOURS | CATSHOURS | CATSHOURS | QUAN | 4 | 2 | Hours | ||
79 | BEGUZ | CATSBEGUZ | UZEIT | TIMS | 6 | 0 | Start time | ||
80 | ENDUZ | CATSENDUZ | UZEIT | TIMS | 6 | 0 | End time | ||
81 | VTKEN | VTKEN | XFELD | CHAR | 1 | 0 | Previous Day Indicator | ||
82 | ALLDF | ALLDF | XFELD | CHAR | 1 | 0 | Record is for Full Day | ||
83 | OFMNW | REMNW | ARBEIT | QUAN | 7 | 1 | Remaining work | ||
84 | PEDD | CO_PEDD | DATUM | DATS | 8 | 0 | Forecast finish date of operation from confirmation | ||
85 | AUERU | AUERU_VS | AUERU_VS | CHAR | 1 | 0 | Partial/Final Confirmation | ||
86 | LTXA1 | CATSSHORTT | TEXT40 | CHAR | 40 | 0 | Short Text | ||
87 | ERUZU | ERUZU | XFELD | CHAR | 1 | 0 | Indicator: Partial confirmation | ||
88 | CATSAMOUNT | CATSAMOUNT | CATSAMOUNT | CURR | 13 | 2 | CATS Amount | ||
89 | CATSQUANTITY | CATSNUMBER | CQUA8 | QUAN | 15 | 3 | Time Sheet: Number (Unit of Measure) | ||
90 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
91 | UVORN | UVORN | VORNR | CHAR | 4 | 0 | Suboperation | ||
92 | KAPAR | KAPART | KAPART | CHAR | 3 | 0 | Capacity category | * | |
93 | ARBPL | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
94 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
95 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRMSS_CAT_APPR_CATSDB_EXT_DET | KOKRS | TKA01 | KOKRS | |||
2 | HRMSS_CAT_APPR_CATSDB_EXT_DET | LSTAR | CSLA | LSTAR | |||
3 | HRMSS_CAT_APPR_CATSDB_EXT_DET | MEINH | T006 | MSEHI | |||
4 | HRMSS_CAT_APPR_CATSDB_EXT_DET | OTYPE | T778O | OTYPE | |||
5 | HRMSS_CAT_APPR_CATSDB_EXT_DET | TCURR | TCURC | WAERS | |||
6 | HRMSS_CAT_APPR_CATSDB_EXT_DET | VERSL | T555R | VME | |||
7 | HRMSS_CAT_APPR_CATSDB_EXT_DET | WAERS | TCURC | WAERS | |||
8 | HRMSS_CAT_APPR_CATSDB_EXT_DET | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |