SAP ABAP Table HRCCE_CATSDB_ALV_CE (Time Sheet Data - Layout for ALV Reporting)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-TS (Application Component) Time Sheet
     ⤷ CATS_MISC (Package) Customizing and Reporting for the Time Sheet

Basic Data

Table Category	INTTAB	Structure
Structure	HRCCE_CATSDB_ALV_CE	Table Relationship Diagram
Short Description	Time Sheet Data - Layout for ALV Reporting

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	.INCLUDE	☐				0	0	CATS: CATSDB Extended with Additional Information
2	.INCLUDE	☐				0	0	CATS: Database Table for Time Sheet
3	.INCLUDE	☐				0	0	CATS: Key fields
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
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: Include structure for statistical information
80	ERSDA	☐	CATS_ERSDA	DATUM	DATS	8	0	Created on
81	ERSTM	☐	CATS_CPUTM	UZEIT	TIMS	6	0	Time of Entry
82	ERNAM	☐	CATS_ERNAM	USNAM	CHAR	12	0	User Who Created Record
83	LAEDA	☐	CATS_LAEDA	DATUM	DATS	8	0	Date of Last Change
84	LAETM	☐	CATS_LAETM	UZEIT	TIMS	6	0	Time of Last Change
85	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
86	APNAM	☐	CATSAPNAM	UNAME	CHAR	12	0	Name of person who approved data
87	APDAT	☐	CATSAPDAT	DATUM	DATS	8	0	Date of Approval
88	WORKITEMID	☐	SWW_WIID	SWW_WIID	NUMC	12	0	Work item ID	*
89	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
90	STATUS	☐	CATSSTATUS	CATSSTATUS	CHAR	2	0	Processing status
91	REFCOUNTER	☐	CATSREFCOU	CHAR12	CHAR	12	0	Reference Counter for Record to be Changed
92	REASON	☐	CATSREASON	CATSREASON	CHAR	4	0	Reason for Rejection	*
93	BELNR	☐	CATSBELNR	BELNR	CHAR	10	0	Document number
94	EXTSYSTEM	☐	HR_AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
95	EXTAPPLICATION	☐	HR_AWTYP	HR_AWTYP	CHAR	5	0	External Application
96	EXTDOCUMENTNO	☐	HR_AWKEY	AWKEY	CHAR	20	0	Document number
97	TASKCOUNTER	☐	CATSTASKCOUNTER	BELNR	CHAR	10	0	CATS: Task Counter
98	.INCLUDE	☐				0	0	CATS: Include with Cell Information
99	CATSHOURS	☐	CATSHOURS	CATSHOURS	QUAN	4	2	Hours
100	BEGUZ	☐	CATSBEGUZ	UZEIT	TIMS	6	0	Start time
101	ENDUZ	☐	CATSENDUZ	UZEIT	TIMS	6	0	End time
102	VTKEN	☐	VTKEN	XFELD	CHAR	1	0	Previous Day Indicator
103	ALLDF	☐	ALLDF	XFELD	CHAR	1	0	Record is for Full Day
104	OFMNW	☐	REMNW	ARBEIT	QUAN	7	1	Remaining work
105	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
106	AUERU	☐	AUERU_VS	AUERU_VS	CHAR	1	0	Partial/Final Confirmation
107	LTXA1	☐	CATSSHORTT	TEXT40	CHAR	40	0	Short Text
108	LONGTEXT	☐	CATSLONGTE	XFELD	CHAR	1	0	Long Text
109	ERUZU	☐	ERUZU	XFELD	CHAR	1	0	Indicator: Partial confirmation
110	CATSAMOUNT	☐	CATSAMOUNT	CATSAMOUNT	CURR	13	2	CATS Amount
111	CATSQUANTITY	☐	CATSNUMBER	CQUA8	QUAN	15	3	Time Sheet: Number (Unit of Measure)
112	.INCLUDE	☐				0	0
113	.INCLUDE	☐				0	0
114	.INCLUDE	☐				0	0	CATS: Derived Account Assignment Information
115	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
116	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
117	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
118	KAPAR	☐	KAPART	KAPART	CHAR	3	0	Capacity category	*
119	ARBPL	☐	ARBPL	ARBPL	CHAR	8	0	Work center
120	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
121	ROW	☐	BAPI_LINE	INT4	INT4	10	0	Lines in parameter
122	PFLAG_ICON	☐	CATSXT_PFLAG_ICON		STRG	0	0	Status and Processing Indicator
123	LONGTEXT_ICON	☐	CATSXT_LONGTEXT_ICON		STRG	0	0	Long Text
124	TASKTYPE_TEXT	☐	CATSXT_TASKTYPE_TEXT	TEXT25	CHAR	25	0	Task Type
125	TASKLEVEL_TEXT	☐	CATSXT_TASKLEVEL_TEXT	TEXT25	CHAR	25	0	Task Level
126	TASKCOMPONENT_TEXT	☐	CATSXT_TASKCOMPONENT_TEXT	TEXT25	CHAR	25	0	Task Component
127	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
128	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
129	RACCOBJ	☐	CATSXT_RACCOBJ_TEXT	TEXT25	CHAR	25	0	Account Assignment (Receiver)
130	RACCOBJ_TEXT	☐	CATSXT_RACCOBJ_TEXT1		STRG	0	0	Account Assignment Description (Receiver)
131	RACCOBJ_GENREC	☐	GEN_REC	CHAR_35	CHAR	35	0	General Receiver
132	REASON_TEXT	☐	CATSRETEXT	TEXT50	CHAR	50	0	Text for Rejection Reason
133	TMP_KEY	☐	CATSCOUNTE	CHAR12	CHAR	12	0	Counter for Records in Time Recording
134	CORR_ICON	☐	CATSXT_CORR_ICON		STRG	0	0	Correction Indicator
135	ADDITIONAL_RECEIVERS	☐	CATSXT_ADDITIONAL_RECEIVERS		STRG	0	0	Multiple Account Assignment
136	CO_TRANSFER	☐	CATSXT_CO_TRANSFER	XFELD	CHAR	1	0	CO Transmission Takes Place 'X' = Yes
137	INVOICED	☐	CATSXT_INVOICED	XFELD	CHAR	1	0	Billing Document Being Processed 'X' = Yes
138	CPR_TEXT	☐	CATS_CPR_TEXT	CHAR40	CHAR	40	0	cProject Description
139	CPR_OBJTEXT	☐	CATS_CPR_TEXT	CHAR40	CHAR	40	0	cProject Description
140	PERSONID_EXT	☐	PERSONID_EXT_ABA	PERSONID_EXT_ABA	CHAR	20	0	External Person ID
141	PRTXT	☐	HRCCE_PADCE_PRTXT	HRCCE_PADCE_PRTXT	CHAR	80	0	Personnel assignment text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRCCE_CATSDB_ALV_CE	KOKRS	TKA01	KOKRS
2	HRCCE_CATSDB_ALV_CE	LSTAR	CSLA	LSTAR
3	HRCCE_CATSDB_ALV_CE	MANDT	T000	MANDT	KEY	1	CN
4	HRCCE_CATSDB_ALV_CE	MEINH	T006	MSEHI
5	HRCCE_CATSDB_ALV_CE	OTYPE	T778O	OTYPE
6	HRCCE_CATSDB_ALV_CE	TCURR	TCURC	WAERS
7	HRCCE_CATSDB_ALV_CE	VERSL	T555R	VME
8	HRCCE_CATSDB_ALV_CE	WAERS	TCURC	WAERS
9	HRCCE_CATSDB_ALV_CE	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in	604