SAP ABAP Table CE2S_AL (Airline Route Profit)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-PA (Application Component) Profitability Analysis
     ⤷ KEG2 (Package) Profitability Analysis: Generated Objects (Transportable)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CE2S_AL	Table Relationship Diagram
Short Description	Airline Route Profit

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PALEDGER	☑	LEDBO	LEDBO	CHAR	2	0	Currency type for an operating concern	TKEL
3	VRGAR	☑	RKE_VRGAR	VRGAR	CHAR	1	0	Record Type	TVGA
4	VERSI	☑	RKEVERSI	COVERSI	CHAR	3	0	Plan version (CO-PA)	TKVS
5	PAOBJNR	☑	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
6	PASUBNR	☑	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
7	BELNR	☑	RKE_BELNR	BELNR	CHAR	10	0	Document number of line item in Profitability Analysis
8	PERBL	☑	JAHRPERBL	JAHRPER	NUMC	7	0	Fiscal year/period block
9	HZDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	USNAM	☐	ERFASSER	USNAM	CHAR	12	0	Created by
11	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
12	PAPAOBJNR	☐	RKEPOBJ	RKEOBJNR	NUMC	10	0	Partner profitability segment number (CO-PA)
13	PAPASUBNR	☐	RKEPSUBNR	RKESUBNR	NUMC	4	0	Changes to partner profitability segments (CO-PA)
14	KNDNR	☐	KUNDE_PA	KUNNR	CHAR	10	0	Customer	KNA1
15	ARTNR	☐	ARTNR	MATNR	CHAR	18	0	Product number	MARA
16	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
17	FRWAE	☐	FRWAE	WAERS	CUKY	5	0	Foreign currency key	TCURC
18	REC_WAERS	☐	RKE_REC_WAERS	WAERS	CUKY	5	0	Currency of the data record	TCURC
19	KAUFN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
20	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
21	RKAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
22	SKOST	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
23	PRZNR	☐	SEPRZ	CO_PRZNR	CHAR	12	0	Sender Business Process	CBPR
24	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
25	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
26	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
27	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
28	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
29	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
30	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
31	HRKFT	☐	RKEHERK	RKEHERK	CHAR	4	0	Origins (CO-PA)
32	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKA
33	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
34	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
35	RBELN	☐	RKERFBELNR	BELNR	CHAR	10	0	Reference document number for CO-PA line item
36	RPOSN	☐	RKERFPOSNR	RKE_POSNR	CHAR	6	0	Item number from reference document (CO-PA)
37	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
38	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
39	RKESTATU	☐	RKESTATU	RKESTATU	CHAR	10	0	Update status for CO-PA line items
40	TIMESTMP	☐	RKE_HZSTMP	RKE_TSTMP	DEC	16	0	Time created (Greenwich Meantime)
41	KMATYP	☐	RKESKMATYP	RKESKMATYP	NUMC	2	0	Aircraft Type	T2209
42	KMDEST	☐	RKESKMDEST	RKESKMDEST	CHAR	5	0	Destination	T2211
43	KMFLTN	☐	RKESKMFLTN	RKESKMFLTN	CHAR	6	0	Flight Number	T2215
44	KMFLTY	☐	RKESKMFLTY	RKESKMFLTY	CHAR	4	0	Flight Type	T2216
45	KMIATA	☐	RKESKMIATA	RKESKMIATA	CHAR	5	0	IATA Season	T2207
46	KMLEGS	☐	RKESKMLEGS	RKESKMLEGS	CHAR	7	0	Route Segment	T2213
47	KMOPDY	☐	RKESKMOPDY	RKESKMOPDY	CHAR	2	0	Day of Operation	T2208
48	KMORIG	☐	RKESKMORIG	RKESKMORIG	CHAR	5	0	Departure Location	T2212
49	KMROUT	☐	RKESKMROUT	RKESKMROUT	CHAR	5	0	Rotation	T2210
50	KMZONE	☐	RKESKMZONE	RKESKMZONE	CHAR	5	0	Zone	T2214
51	KWBLOK_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
52	KWFLHR_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
53	KWFLKM_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
54	KWFUEL_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
55	KWPAXS_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
56	KWSEAT_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
57	KWBKPZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
58	KWBLKS001	☐	RKESKWBLKS	WERTV8	CURR	15	2	Revenue: Block Seats
59	KWBLOK001	☐	RKESKWBLOK	MENGV15_3	QUAN	15	3	Block Hours
60	KWCATR001	☐	RKESKWCATR	WERTV8	CURR	15	2	Catering
61	KWCRWK001	☐	RKESKWCRWK	WERTV8	CURR	15	2	Crew Expenses
62	KWDEPR001	☐	RKESKWDEPR	WERTV8	CURR	15	2	Depreciation
63	KWEURO001	☐	RKESKWEURO	WERTV8	CURR	15	2	Overflight Fees
64	KWEXLR001	☐	RKESKWEXLR	WERTV8	CURR	15	2	Excess Luggage
65	KWFLHR001	☐	RKESKWFLHR	MENGV15_3	QUAN	15	3	Flight Hours
66	KWFLKM001	☐	RKESKWFLKM	MENGV15_3	QUAN	15	3	Number of Kilometers Flown
67	KWFLSC001	☐	RKESKWFLSC	WERTV8	CURR	15	2	Flight Cost of Sales
68	KWFLSR001	☐	RKESKWFLSR	WERTV8	CURR	15	2	In Flight Sales
69	KWFRGR001	☐	RKESKWFRGR	WERTV8	CURR	15	2	Freight
70	KWFUEL001	☐	RKESKWFUEL	MENGV15_3	QUAN	15	3	Fuel Consumption
71	KWFULK001	☐	RKESKWFULK	WERTV8	CURR	15	2	Fuel Costs
72	KWINSR001	☐	RKESKWINSR	WERTV8	CURR	15	2	Insurance
73	KWIREG001	☐	RKESKWIREG	WERTV8	CURR	15	2	Flight Irregularities
74	KWLFEE001	☐	RKESKWLFEE	WERTV8	CURR	15	2	Landing Fees
75	KWPAXR001	☐	RKESKWPAXR	WERTV8	CURR	15	2	Passenger Revenue
76	KWPAXS001	☐	RKESKWPAXS	MENGV15_3	QUAN	15	3	Number of Passengers
77	KWPXHD001	☐	RKESKWPXHD	WERTV8	CURR	15	2	Passenger Handling
78	KWRESV001	☐	RKESKWRESV	WERTV8	CURR	15	2	Reservation Costs
79	KWSEAT001	☐	RKESKWSEAT	MENGV15_3	QUAN	15	3	Number of Available Seats
80	KWVERW001	☐	RKESKWVERW	WERTV8	CURR	15	2	Administration Costs
81	KWAGTK001	☐	RKESKWAGTK	WERTV8	CURR	15	2	Sales Agent Commission
82	KWWTFX001	☐	RKESKWWTFX	WERTV8	CURR	15	2	Fixed Maintenance Costs
83	KWWTVA001	☐	RKESKWWTVA	WERTV8	CURR	15	2	Variable Maintenance Costs
84	KWCRGK001	☐	RKESKWCRGK	WERTV8	CURR	15	2	Crew Salaries
85	KWSMKT001	☐	RKESKWSMKT	WERTV8	CURR	15	2	Sales & Marketing
86	KWGRHD001	☐	RKESKWGRHD	WERTV8	CURR	15	2	Ground Handling
87	KWBKPZ001	☐	RKESKWBKPZ	MENGV15_3	QUAN	15	3	Number of Block Seats

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CE2S_AL	ARTNR	MARA	MATNR	REF	C	CN
2	CE2S_AL	BUKRS	T001	BUKRS	REF	C	CN
3	CE2S_AL	FKART	TVFK	FKART	REF	C	CN
4	CE2S_AL	FRWAE	TCURC	WAERS	REF	C	CN
5	CE2S_AL	GSBER	TGSB	GSBER	REF	C	CN
6	CE2S_AL	KAUFN	VBUK	VBELN	REF	C	CN
7	CE2S_AL	KMATYP	T2209	KMATYP	REF	C	CN
8	CE2S_AL	KMDEST	T2211	KMDEST	REF	C	CN
9	CE2S_AL	KMFLTN	T2215	KMFLTN	REF	C	CN
10	CE2S_AL	KMFLTY	T2216	KMFLTY	REF	C	CN
11	CE2S_AL	KMIATA	T2207	KMIATA	REF	C	CN
12	CE2S_AL	KMLEGS	T2213	KMLEGS	REF	C	CN
13	CE2S_AL	KMOPDY	T2208	KMOPDY	REF	C	CN
14	CE2S_AL	KMORIG	T2212	KMORIG	REF	C	CN
15	CE2S_AL	KMROUT	T2210	KMROUT	REF	C	CN
16	CE2S_AL	KMZONE	T2214	KMZONE	REF	C	CN
17	CE2S_AL	KNDNR	KNA1	KUNNR	REF	C	CN
18	CE2S_AL	KOKRS	TKA01	KOKRS	REF	C	CN
19	CE2S_AL	KSTAR	CSKA	KSTAR	REF	C	CN
20	CE2S_AL	KSTRG	CKPH	KSTRG	REF	C	CN
21	CE2S_AL	KWBKPZ_ME	T006	MSEHI	REF	C	CN
22	CE2S_AL	KWBLOK_ME	T006	MSEHI	REF	C	CN
23	CE2S_AL	KWFLHR_ME	T006	MSEHI	REF	C	CN
24	CE2S_AL	KWFLKM_ME	T006	MSEHI	REF	C	CN
25	CE2S_AL	KWFUEL_ME	T006	MSEHI	REF	C	CN
26	CE2S_AL	KWPAXS_ME	T006	MSEHI	REF	C	CN
27	CE2S_AL	KWSEAT_ME	T006	MSEHI	REF	C	CN
28	CE2S_AL	MANDT	T000	MANDT	KEY	1	CN
29	CE2S_AL	PALEDGER	TKEL	PALEDGER	KEY	1	CN
30	CE2S_AL	PPRCTR	CEPC	PRCTR	REF	C	CN
31	CE2S_AL	PRCTR	CEPC	PRCTR	REF	C	CN
32	CE2S_AL	PRZNR	CBPR	PRZNR	REF	C	CN
33	CE2S_AL	PSPNR	PRPS	PSPNR	REF	C	CN
34	CE2S_AL	REC_WAERS	TCURC	WAERS	REF	C	CN
35	CE2S_AL	RKAUFNR	AUFK	AUFNR	REF	C	CN
36	CE2S_AL	SKOST	CSKS	KOSTL	REF	C	CN
37	CE2S_AL	SPART	TSPA	SPART	REF	C	CN
38	CE2S_AL	VERSI	TKVS	VERSI	KEY	1	CN
39	CE2S_AL	VKORG	TVKO	VKORG	REF	C	CN
40	CE2S_AL	VRGAR	TVGA	VRGAR	KEY	1	CN
41	CE2S_AL	VTWEG	TVTW	VTWEG	REF	C	CN
42	CE2S_AL	WERKS	T001W	WERKS	REF	C	CN

History

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