SAP ABAP View V_CATSDB (CATX: Restricted View of CATSDB)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-TS (Application Component) Time Sheet
     ⤷ CATX (Package) Enhancements for the Cross-Application Time Sheet (CATS)

Basic Data

View Type	D	Database View
Database View	V_CATSDB
Short Description	CATX: Restricted View of CATSDB
Root table	CATSDB	CATS: Database Table for Time Sheet

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CATSDB	CATSDB

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	CATSDB	*		☐		☐
2	MANDT	CATSDB	MANDT		☐	MANDT	☐	Client
3	-	CATSDB	COUNTER		☐	CATSCOUNTE	☐	Counter for Records in Time Recording
4	PERNR	CATSDB	PERNR		☐	PERNR_D	☐	Personnel Number
5	WORKDATE	CATSDB	WORKDATE		☐	CATSDATE	☐	Date
6	SKOSTL	CATSDB	SKOSTL		☐	SKOSTL	☐	Sender Cost Center
7	-	CATSDB	LSTAR		☐	LSTAR	☐	Activity Type
8	SEBELN	CATSDB	SEBELN		☐	SEBELN	☐	Sending purchase order
9	SEBELP	CATSDB	SEBELP		☐	SEBELP	☐	Sending purchase order item
10	-	CATSDB	SPRZNR		☐	SPRZNR	☐	Sender Business Process
11	-	CATSDB	LSTNR		☐	ASNUM	☐	Activity Number
12	RKOSTL	CATSDB	RKOSTL		☐	EKOSTL	☐	Receiver Cost Center
13	RPROJ	CATSDB	RPROJ		☐	EPROJ	☐	Receiver WBS element
14	RAUFNR	CATSDB	RAUFNR		☐	EAUFNR	☐	Receiver Order
15	RNPLNR	CATSDB	RNPLNR		☐	NW_AUFNR	☐	Network number
16	RAUFPL	CATSDB	RAUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
17	RAPLZL	CATSDB	RAPLZL		☐	CO_APLZL	☐	General counter for order
18	RKDAUF	CATSDB	RKDAUF		☐	EKDAU	☐	Receiver sales order
19	RKDPOS	CATSDB	RKDPOS		☐	EKDPO	☐	Item number in receiver sales order
20	RKSTR	CATSDB	RKSTR		☐	EKSTR	☐	Receiver cost object
21	RPRZNR	CATSDB	RPRZNR		☐	EPRZNR	☐	Receiver business process
22	PAOBJNR	CATSDB	PAOBJNR		☐	RKEOBJNR	☐	Profitability Segment Number (CO-PA)
23	FUND	CATSDB	FUND		☐	FM_EFONDS	☐	Receiver fund
24	FUNC_AREA	CATSDB	FUNC_AREA		☐	EFKTBER	☐	Receiving Functional Area
25	GRANT_NBR	CATSDB	GRANT_NBR		☐	GM_GRANT_RECEIVER	☐	Receiver Grant
26	S_FUND	CATSDB	S_FUND		☐	FM_SFONDS	☐	Sender fund
27	S_FUNC_AREA	CATSDB	S_FUNC_AREA		☐	SFKTBER	☐	Sending Functional Area
28	S_GRANT_NBR	CATSDB	S_GRANT_NBR		☐	GM_GRANT_SENDER	☐	Sender Grant
29	BUDGET_PD	CATSDB	BUDGET_PD		☐	FM_EBUDGET_PERIOD	☐	FM: Receiver Budget Period
30	SBUDGET_PD	CATSDB	SBUDGET_PD		☐	FM_SBUDGET_PERIOD	☐	FM: Sender Budget Period
31	-	CATSDB	AWART		☐	AWART	☐	Attendance or Absence Type
32	-	CATSDB	LGART		☐	LGART	☐	Wage Type
33	-	CATSDB	KAPID		☐	KAPID	☐	Capacity ID
34	-	CATSDB	SPLIT		☐	CY_SPLIT	☐	Split number
35	REINR	CATSDB	REINR		☐	REINR	☐	Trip Number
36	WABLNR	CATSDB	WABLNR		☐	MBLNR	☐	Number of Material Document
37	-	CATSDB	VERSL		☐	VRSCH	☐	Overtime Compensation Type
38	-	CATSDB	WTART		☐	HRWRKAR	☐	Tax area work center
39	-	CATSDB	BWGRL		☐	CATSBWGRL	☐	Valuation basis
40	-	CATSDB	WAERS		☐	WAERS	☐	Currency Key
41	-	CATSDB	AUFKZ		☐	AUFKN	☐	Extra Pay Indicator
42	-	CATSDB	TRFGR		☐	TRFGR	☐	Pay Scale Group
43	-	CATSDB	TRFST		☐	TRFST	☐	Pay Scale Level
44	-	CATSDB	PRAKN		☐	PRAKN	☐	Premium Number
45	-	CATSDB	PRAKZ		☐	PRAKZ	☐	Premium Indicator
46	-	CATSDB	OTYPE		☐	OTYPE	☐	Object Type
47	-	CATSDB	PLANS		☐	PLANS	☐	Position
48	KOKRS	CATSDB	KOKRS		☐	KOKRS	☐	Controlling Area
49	-	CATSDB	MEINH		☐	MEINH	☐	Unit of Measure for Display
50	-	CATSDB	TCURR		☐	TWAER	☐	Transaction Currency
51	-	CATSDB	PRICE		☐	CATSPRICE	☐	Price in Transaction Currency
52	-	CATSDB	ARBID		☐	OBJEKTID	☐	Object ID
53	-	CATSDB	WERKS		☐	WERKS_D	☐	Plant
54	AUTYP	CATSDB	AUTYP		☐	AUFTYP	☐	Order category
55	HRCOSTASG	CATSDB	HRCOSTASG		☐	CATSHRCO	☐	Cost Accounting Variants
56	-	CATSDB	HRKOSTL		☐	CATSHRKOSTL	☐	Cost Center
57	-	CATSDB	HRLSTAR		☐	CATSHRLSTAR	☐	Activity Type
58	-	CATSDB	HRFUND		☐	CATSHRFUND	☐	Master Fund
59	-	CATSDB	HRFUNC_AREA		☐	CATSHRFUNC_AREA	☐	Master Functional Area
60	-	CATSDB	HRGRANT_NBR		☐	CATSHRGRANT_NBR	☐	Master Grant
61	-	CATSDB	BEMOT		☐	BEMOT	☐	Accounting Indicator
62	-	CATSDB	UNIT		☐	MSEHI	☐	Unit of Measurement
63	-	CATSDB	STATKEYFIG		☐	STAGR	☐	Statistical key figure
64	TASKTYPE	CATSDB	TASKTYPE		☐	CATSTASKTYPE	☐	Task Type
65	TASKLEVEL	CATSDB	TASKLEVEL		☐	CATSTASKLEVEL	☐	Task Level
66	-	CATSDB	TASKCOMPONENT		☐	CATSTASKCOMPONENT	☐	Task component
67	BUKRS	CATSDB	BUKRS		☐	BUKRS	☐	Company Code
68	CPR_GUID	CATSDB	CPR_GUID		☐	CATS_CPR_GUID	☐	Project GUID
69	CPR_EXTID	CATSDB	CPR_EXTID		☐	CATS_CPR_EXTID	☐	External Project ID
70	CPR_OBJGUID	CATSDB	CPR_OBJGUID		☐	CATS_CPR_OBJGUID	☐	Object ID
71	CPR_OBJGEXTID	CATSDB	CPR_OBJGEXTID		☐	CATS_CPR_OBJGEXTID	☐	External ID of Project Subobject
72	CPR_OBJTYPE	CATSDB	CPR_OBJTYPE		☐	CATS_CPR_OBJTYPE	☐	cProjects Object Type
73	HRBUDGET_PD	CATSDB	HRBUDGET_PD		☐	CATSHR_BUDGET_PERIOD	☐	Master Budget Period
74	-	CATSDB	ERSDA		☐	CATS_ERSDA	☐	Created on
75	-	CATSDB	ERSTM		☐	CATS_CPUTM	☐	Time of Entry
76	-	CATSDB	ERNAM		☐	CATS_ERNAM	☐	User Who Created Record
77	-	CATSDB	LAEDA		☐	CATS_LAEDA	☐	Date of Last Change
78	-	CATSDB	LAETM		☐	CATS_LAETM	☐	Time of Last Change
79	-	CATSDB	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
80	-	CATSDB	APNAM		☐	CATSAPNAM	☐	Name of person who approved data
81	-	CATSDB	APDAT		☐	CATSAPDAT	☐	Date of Approval
82	-	CATSDB	WORKITEMID		☐	SWW_WIID	☐	Work item ID
83	LOGSYS	CATSDB	LOGSYS		☐	LOGSYS	☐	Logical system
84	-	CATSDB	STATUS		☐	CATSSTATUS	☐	Processing status
85	-	CATSDB	REFCOUNTER		☐	CATSREFCOU	☐	Reference Counter for Record to be Changed
86	-	CATSDB	REASON		☐	CATSREASON	☐	Reason for Rejection
87	-	CATSDB	BELNR		☐	CATSBELNR	☐	Document number
88	EXTSYSTEM	CATSDB	EXTSYSTEM		☐	HR_AWSYS	☐	Logical system of source document
89	EXTAPPLICATION	CATSDB	EXTAPPLICATION		☐	HR_AWTYP	☐	External Application
90	EXTDOCUMENTNO	CATSDB	EXTDOCUMENTNO		☐	HR_AWKEY	☐	Document number
91	TASKCOUNTER	CATSDB	TASKCOUNTER		☐	CATSTASKCOUNTER	☐	CATS: Task Counter
92	-	CATSDB	CATSHOURS		☐	CATSHOURS	☐	Hours
93	-	CATSDB	BEGUZ		☐	CATSBEGUZ	☐	Start time
94	-	CATSDB	ENDUZ		☐	CATSENDUZ	☐	End time
95	-	CATSDB	VTKEN		☐	VTKEN	☐	Previous Day Indicator
96	-	CATSDB	ALLDF		☐	ALLDF	☐	Record is for Full Day
97	-	CATSDB	OFMNW		☐	REMNW	☐	Remaining work
98	-	CATSDB	PEDD		☐	CO_PEDD	☐	Forecast finish date of operation from confirmation
99	-	CATSDB	AUERU		☐	AUERU_VS	☐	Partial/Final Confirmation
100	LTXA1	CATSDB	LTXA1		☐	CATSSHORTT	☐	Short Text
101	-	CATSDB	LONGTEXT		☐	CATSLONGTE	☐	Long Text
102	-	CATSDB	ERUZU		☐	ERUZU	☐	Indicator: Partial confirmation
103	-	CATSDB	CATSAMOUNT		☐	CATSAMOUNT	☐	CATS Amount
104	-	CATSDB	CATSQUANTITY		☐	CATSNUMBER	☐	Time Sheet: Number (Unit of Measure)
105	-	CATSDB	UNIT		☐	MSEHI	☐	Unit of Measurement

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C