SAP ABAP View COVJL (CO Object: Line Items for Acty Types (by Year and Doc.Hdr))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KACC (Package) Cost Accounting: Cost collector RK-A

Basic Data

View Type	D	Database View
Database View	COVJL
Short Description	CO Object: Line Items for Acty Types (by Year and Doc.Hdr)
Root table	COEJL	CO Object: Line Items for Activity Types (by Fiscal Year)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	COEJL	COEJL
2	COBK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	COBK	MANDT	JL	EQ				0	0
2	COEJL	MANDT	JR	EQ			AND	0	0
3	COBK	KOKRS	JL	EQ				0	0
4	COEJL	KOKRS	JR	EQ			AND	0	0
5	COBK	BELNR	JL	EQ				0	0
6	COEJL	BELNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	COEJL	*		☐		☐
2	MANDT	COEJL	MANDT		☐	MANDT	☐	Client
3	KOKRS	COEJL	KOKRS		☐	KOKRS	☐	Controlling Area
4	BELNR	COEJL	BELNR		☐	CO_BELNR	☐	Document Number
5	BUZEI	COEJL	BUZEI		☐	CO_BUZEI	☐	Posting row
6	PERBL	COEJL	PERBL		☐	PERBL	☐	Period block
7	MEINH	COEJL	MEINH		☐	CO_MEINH_L	☐	Activity unit
8	LST001	COEJL	LST001		☐	LSTXX	☐	Activity Quantity
9	LST002	COEJL	LST002		☐	LSTXX	☐	Activity Quantity
10	LST003	COEJL	LST003		☐	LSTXX	☐	Activity Quantity
11	LST004	COEJL	LST004		☐	LSTXX	☐	Activity Quantity
12	LST005	COEJL	LST005		☐	LSTXX	☐	Activity Quantity
13	LST006	COEJL	LST006		☐	LSTXX	☐	Activity Quantity
14	LST007	COEJL	LST007		☐	LSTXX	☐	Activity Quantity
15	LST008	COEJL	LST008		☐	LSTXX	☐	Activity Quantity
16	LST009	COEJL	LST009		☐	LSTXX	☐	Activity Quantity
17	LST010	COEJL	LST010		☐	LSTXX	☐	Activity Quantity
18	LST011	COEJL	LST011		☐	LSTXX	☐	Activity Quantity
19	LST012	COEJL	LST012		☐	LSTXX	☐	Activity Quantity
20	LST013	COEJL	LST013		☐	LSTXX	☐	Activity Quantity
21	LST014	COEJL	LST014		☐	LSTXX	☐	Activity Quantity
22	LST015	COEJL	LST015		☐	LSTXX	☐	Activity Quantity
23	LST016	COEJL	LST016		☐	LSTXX	☐	Activity Quantity
24	MEINB	COEJL	MEINB		☐	CO_MEINB_L	☐	Posted Activity Unit
25	LSB001	COEJL	LSB001		☐	LSBXX	☐	Activity quantity in document
26	LSB002	COEJL	LSB002		☐	LSBXX	☐	Activity quantity in document
27	LSB003	COEJL	LSB003		☐	LSBXX	☐	Activity quantity in document
28	LSB004	COEJL	LSB004		☐	LSBXX	☐	Activity quantity in document
29	LSB005	COEJL	LSB005		☐	LSBXX	☐	Activity quantity in document
30	LSB006	COEJL	LSB006		☐	LSBXX	☐	Activity quantity in document
31	LSB007	COEJL	LSB007		☐	LSBXX	☐	Activity quantity in document
32	LSB008	COEJL	LSB008		☐	LSBXX	☐	Activity quantity in document
33	LSB009	COEJL	LSB009		☐	LSBXX	☐	Activity quantity in document
34	LSB010	COEJL	LSB010		☐	LSBXX	☐	Activity quantity in document
35	LSB011	COEJL	LSB011		☐	LSBXX	☐	Activity quantity in document
36	LSB012	COEJL	LSB012		☐	LSBXX	☐	Activity quantity in document
37	LSB013	COEJL	LSB013		☐	LSBXX	☐	Activity quantity in document
38	LSB014	COEJL	LSB014		☐	LSBXX	☐	Activity quantity in document
39	LSB015	COEJL	LSB015		☐	LSBXX	☐	Activity quantity in document
40	LSB016	COEJL	LSB016		☐	LSBXX	☐	Activity quantity in document
41	KAP001	COEJL	KAP001		☐	KAPXX	☐	Capacity
42	KAP002	COEJL	KAP002		☐	KAPXX	☐	Capacity
43	KAP003	COEJL	KAP003		☐	KAPXX	☐	Capacity
44	KAP004	COEJL	KAP004		☐	KAPXX	☐	Capacity
45	KAP005	COEJL	KAP005		☐	KAPXX	☐	Capacity
46	KAP006	COEJL	KAP006		☐	KAPXX	☐	Capacity
47	KAP007	COEJL	KAP007		☐	KAPXX	☐	Capacity
48	KAP008	COEJL	KAP008		☐	KAPXX	☐	Capacity
49	KAP009	COEJL	KAP009		☐	KAPXX	☐	Capacity
50	KAP010	COEJL	KAP010		☐	KAPXX	☐	Capacity
51	KAP011	COEJL	KAP011		☐	KAPXX	☐	Capacity
52	KAP012	COEJL	KAP012		☐	KAPXX	☐	Capacity
53	KAP013	COEJL	KAP013		☐	KAPXX	☐	Capacity
54	KAP014	COEJL	KAP014		☐	KAPXX	☐	Capacity
55	KAP015	COEJL	KAP015		☐	KAPXX	☐	Capacity
56	KAP016	COEJL	KAP016		☐	KAPXX	☐	Capacity
57	AUSEH	COEJL	AUSEH		☐	AUSEH	☐	Output Unit
58	AUS001	COEJL	AUS001		☐	AUSXX	☐	Output
59	AUS002	COEJL	AUS002		☐	AUSXX	☐	Output
60	AUS003	COEJL	AUS003		☐	AUSXX	☐	Output
61	AUS004	COEJL	AUS004		☐	AUSXX	☐	Output
62	AUS005	COEJL	AUS005		☐	AUSXX	☐	Output
63	AUS006	COEJL	AUS006		☐	AUSXX	☐	Output
64	AUS007	COEJL	AUS007		☐	AUSXX	☐	Output
65	AUS008	COEJL	AUS008		☐	AUSXX	☐	Output
66	AUS009	COEJL	AUS009		☐	AUSXX	☐	Output
67	AUS010	COEJL	AUS010		☐	AUSXX	☐	Output
68	AUS011	COEJL	AUS011		☐	AUSXX	☐	Output
69	AUS012	COEJL	AUS012		☐	AUSXX	☐	Output
70	AUS013	COEJL	AUS013		☐	AUSXX	☐	Output
71	AUS014	COEJL	AUS014		☐	AUSXX	☐	Output
72	AUS015	COEJL	AUS015		☐	AUSXX	☐	Output
73	AUS016	COEJL	AUS016		☐	AUSXX	☐	Output
74	AUBEH	COEJL	AUBEH		☐	CO_MEINB_A	☐	Posted output unit
75	AUB001	COEJL	AUB001		☐	AUBXX	☐	Posted output quantity
76	AUB002	COEJL	AUB002		☐	AUBXX	☐	Posted output quantity
77	AUB003	COEJL	AUB003		☐	AUBXX	☐	Posted output quantity
78	AUB004	COEJL	AUB004		☐	AUBXX	☐	Posted output quantity
79	AUB005	COEJL	AUB005		☐	AUBXX	☐	Posted output quantity
80	AUB006	COEJL	AUB006		☐	AUBXX	☐	Posted output quantity
81	AUB007	COEJL	AUB007		☐	AUBXX	☐	Posted output quantity
82	AUB008	COEJL	AUB008		☐	AUBXX	☐	Posted output quantity
83	AUB009	COEJL	AUB009		☐	AUBXX	☐	Posted output quantity
84	AUB010	COEJL	AUB010		☐	AUBXX	☐	Posted output quantity
85	AUB011	COEJL	AUB011		☐	AUBXX	☐	Posted output quantity
86	AUB012	COEJL	AUB012		☐	AUBXX	☐	Posted output quantity
87	AUB013	COEJL	AUB013		☐	AUBXX	☐	Posted output quantity
88	AUB014	COEJL	AUB014		☐	AUBXX	☐	Posted output quantity
89	AUB015	COEJL	AUB015		☐	AUBXX	☐	Posted output quantity
90	AUB016	COEJL	AUB016		☐	AUBXX	☐	Posted output quantity
91	DIS001	COEJL	DIS001		☐	DISXX	☐	Scheduled Activity
92	DIS002	COEJL	DIS002		☐	DISXX	☐	Scheduled Activity
93	DIS003	COEJL	DIS003		☐	DISXX	☐	Scheduled Activity
94	DIS004	COEJL	DIS004		☐	DISXX	☐	Scheduled Activity
95	DIS005	COEJL	DIS005		☐	DISXX	☐	Scheduled Activity
96	DIS006	COEJL	DIS006		☐	DISXX	☐	Scheduled Activity
97	DIS007	COEJL	DIS007		☐	DISXX	☐	Scheduled Activity
98	DIS008	COEJL	DIS008		☐	DISXX	☐	Scheduled Activity
99	DIS009	COEJL	DIS009		☐	DISXX	☐	Scheduled Activity
100	DIS010	COEJL	DIS010		☐	DISXX	☐	Scheduled Activity
101	DIS011	COEJL	DIS011		☐	DISXX	☐	Scheduled Activity
102	DIS012	COEJL	DIS012		☐	DISXX	☐	Scheduled Activity
103	DIS013	COEJL	DIS013		☐	DISXX	☐	Scheduled Activity
104	DIS014	COEJL	DIS014		☐	DISXX	☐	Scheduled Activity
105	DIS015	COEJL	DIS015		☐	DISXX	☐	Scheduled Activity
106	DIS016	COEJL	DIS016		☐	DISXX	☐	Scheduled Activity
107	LEDNR	COEJL	LEDNR		☐	LEDNR	☐	Ledger for Controlling objects
108	OBJNR	COEJL	OBJNR		☐	J_OBJNR	☐	Object number
109	GJAHR	COEJL	GJAHR		☐	GJAHR	☐	Fiscal Year
110	WRTTP	COEJL	WRTTP		☐	CO_WRTTP	☐	Value Type
111	VERSN	COEJL	VERSN		☐	VERSN	☐	Version
112	VRGNG	COEJL	VRGNG		☐	CO_VORGANG	☐	CO Business Transaction
113	SGTXT	COEJL	SGTXT		☐	CO_SGTXT	☐	Segment text
114	REFBZ	COEJL	REFBZ		☐	CO_REFBZ	☐	Posting row of reference document
115	ZLENR	COEJL	ZLENR		☐	DZLENR	☐	Document Item Number
116	AEQ001	COEJL	AEQ001		☐	AEQXX	☐	Equivalence Numbers
117	AEQ002	COEJL	AEQ002		☐	AEQXX	☐	Equivalence Numbers
118	AEQ003	COEJL	AEQ003		☐	AEQXX	☐	Equivalence Numbers
119	AEQ004	COEJL	AEQ004		☐	AEQXX	☐	Equivalence Numbers
120	AEQ005	COEJL	AEQ005		☐	AEQXX	☐	Equivalence Numbers
121	AEQ006	COEJL	AEQ006		☐	AEQXX	☐	Equivalence Numbers
122	AEQ007	COEJL	AEQ007		☐	AEQXX	☐	Equivalence Numbers
123	AEQ008	COEJL	AEQ008		☐	AEQXX	☐	Equivalence Numbers
124	AEQ009	COEJL	AEQ009		☐	AEQXX	☐	Equivalence Numbers
125	AEQ010	COEJL	AEQ010		☐	AEQXX	☐	Equivalence Numbers
126	AEQ011	COEJL	AEQ011		☐	AEQXX	☐	Equivalence Numbers
127	AEQ012	COEJL	AEQ012		☐	AEQXX	☐	Equivalence Numbers
128	AEQ013	COEJL	AEQ013		☐	AEQXX	☐	Equivalence Numbers
129	AEQ014	COEJL	AEQ014		☐	AEQXX	☐	Equivalence Numbers
130	AEQ015	COEJL	AEQ015		☐	AEQXX	☐	Equivalence Numbers
131	AEQ016	COEJL	AEQ016		☐	AEQXX	☐	Equivalence Numbers
132	*	COBK	*		☐		☐
133	-	COBK	MANDT		☐	MANDT	☐	Client
134	-	COBK	KOKRS		☐	KOKRS	☐	Controlling Area
135	-	COBK	BELNR		☐	CO_BELNR	☐	Document Number
136	PERAB	COBK	PERAB		☐	CO_PERAB	☐	From Period
137	PERBI	COBK	PERBI		☐	CO_PERBI	☐	To period
138	BLDAT	COBK	BLDAT		☐	CO_BLDAT	☐	Document Date
139	BUDAT	COBK	BUDAT		☐	CO_BUDAT	☐	Posting Date
140	CPUDT	COBK	CPUDT		☐	CO_CPUDT	☐	Date Document Was Created
141	USNAM	COBK	USNAM		☐	SYUNAME	☐	User Name
142	BLTXT	COBK	BLTXT		☐	CO_BLTXT	☐	Document Header Text
143	STFLG	COBK	STFLG		☐	CO_STFLG	☐	Identifier for reversal document
144	STOKZ	COBK	STOKZ		☐	CO_STOKZ	☐	Indicator: Document Has Been Reversed
145	REFBT	COBK	REFBT		☐	CO_REFBT	☐	Document type of reference document
146	REFBN	COBK	REFBN		☐	CO_REFBN	☐	Reference Document Number
147	REFBK	COBK	REFBK		☐	CO_REFBK	☐	Company code of FI document
148	REFGJ	COBK	REFGJ		☐	CO_REFGJ	☐	Fiscal year of reference document
149	BLART	COBK	BLART		☐	CO_REFBA	☐	Document type of FI reference document
150	ORGVG	COBK	ORGVG		☐	CO_ORGVG	☐	Original CO business transaction
151	SUMBZ	COBK	SUMBZ		☐	CO_SUMBZ	☐	Number of posting lines for local objects
152	DELBZ	COBK	DELBZ		☐	CO_DELBZ	☐	Number of deleted line items
153	WSDAT	COBK	WSDAT		☐	WSDAT	☐	Value Date for Currency Translation
154	KURST	COBK	KURST		☐	KURST	☐	Exchange Rate Type
155	VARNR	COBK	VARNR		☐	CO_VARNR	☐	CO actual postings fast input: Variant
156	KWAER	COBK	KWAER		☐	KWAER	☐	Controlling area currency
157	CTYP1	COBK	CTYP1		☐	CO_CTYP1	☐	Currency Type 1 in CO Standard Ledger
158	CTYP2	COBK	CTYP2		☐	CO_CTYP2	☐	Currency Type 2 in CO Standard Ledger
159	CTYP3	COBK	CTYP3		☐	CO_CTYP3	☐	Currency Type 3 in CO Standard Ledger
160	CTYP4	COBK	CTYP4		☐	CO_CTYP4	☐	Currency Type 4 in CO Standard Ledger
161	AWTYP	COBK	AWTYP		☐	AWTYP	☐	Reference procedure
162	AWORG	COBK	AWORG		☐	AWORG	☐	Reference organisational units
163	LOGSYSTEM	COBK	LOGSYSTEM		☐	LOGSYSTEM	☐	Logical System
164	CPUTM	COBK	CPUTM		☐	CPUTM	☐	Time of data entry
165	ALEBZ	COBK	ALEBZ		☐	CO_ALEBZ	☐	Number of posting rows sent to external systems
166	ALEBN	COBK	ALEBN		☐	CO_ALEBN	☐	For ALE: CO Document Number in Generating System
167	AWSYS	COBK	AWSYS		☐	AWSYS	☐	Logical system of source document
168	AWREF_REV	COBK	AWREF_REV		☐	AWREF_REV	☐	Reversal: Reverse Document Reference Document Number
169	AWORG_REV	COBK	AWORG_REV		☐	AWORG_REV	☐	Reversal: Reverse Document Reference Organization
170	VALDT	COBK	VALDT		☐	CO_VALDT	☐	Special Valuation Date for Cost Accounting
171	K_GJAHR	COBK	GJAHR		☐	GJAHR	☐	Fiscal Year
172	K_VERSN	COBK	VERSN		☐	VERSN_COBK	☐	Version in CO Document Header
173	K_VRGNG	COBK	VRGNG		☐	CO_VORGANG	☐	CO Business Transaction
174	K_TIMESTMP	COBK	TIMESTMP		☐	RKE_HZSTMP	☐	Time created (Greenwich Meantime)

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