SAP ABAP Table CE3S_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	CE3S_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	PAOBJNR	☑	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
3	PALEDGER	☑	LEDBO	LEDBO	CHAR	2	0	Currency type for an operating concern	TKEL
4	VRGAR	☑	RKE_VRGAR	VRGAR	CHAR	1	0	Record Type	TVGA
5	PLIKZ	☑	PLIKZ	PLIKZ	CHAR	1	0	Plan/Actual Indicator
6	VERSI	☑	RKEVERSI	COVERSI	CHAR	3	0	Plan version (CO-PA)	TKVS
7	PERBL	☑	JAHRPERBL	JAHRPER	NUMC	7	0	Fiscal year/period block
8	PASUBNR	☑	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
9	PAPAOBJNR	☑	RKEPOBJ	RKEOBJNR	NUMC	10	0	Partner profitability segment number (CO-PA)
10	PAPASUBNR	☑	RKEPSUBNR	RKESUBNR	NUMC	4	0	Changes to partner profitability segments (CO-PA)
11	HRKFT	☑	RKEHERK	RKEHERK	CHAR	4	0	Origins (CO-PA)
12	UPDAT	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
13	USNAM	☐	AENNM	USNAM	CHAR	12	0	Last changed by
14	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
15	REC_WAERS	☐	RKE_REC_WAERS	WAERS	CUKY	5	0	Currency of the data record	*
16	TIMESTMP	☐	RKE_HZSTMP	RKE_TSTMP	DEC	16	0	Time created (Greenwich Meantime)
17	KWBLKS001	☐	RKESKWBLKS	WERTV8	CURR	15	2	Revenue: Block Seats
18	KWBLOK001	☐	RKESKWBLOK	MENGV15_3	QUAN	15	3	Block Hours
19	KWCATR001	☐	RKESKWCATR	WERTV8	CURR	15	2	Catering
20	KWCRWK001	☐	RKESKWCRWK	WERTV8	CURR	15	2	Crew Expenses
21	KWDEPR001	☐	RKESKWDEPR	WERTV8	CURR	15	2	Depreciation
22	KWEURO001	☐	RKESKWEURO	WERTV8	CURR	15	2	Overflight Fees
23	KWEXLR001	☐	RKESKWEXLR	WERTV8	CURR	15	2	Excess Luggage
24	KWFLHR001	☐	RKESKWFLHR	MENGV15_3	QUAN	15	3	Flight Hours
25	KWFLKM001	☐	RKESKWFLKM	MENGV15_3	QUAN	15	3	Number of Kilometers Flown
26	KWFLSC001	☐	RKESKWFLSC	WERTV8	CURR	15	2	Flight Cost of Sales
27	KWFLSR001	☐	RKESKWFLSR	WERTV8	CURR	15	2	In Flight Sales
28	KWFRGR001	☐	RKESKWFRGR	WERTV8	CURR	15	2	Freight
29	KWFUEL001	☐	RKESKWFUEL	MENGV15_3	QUAN	15	3	Fuel Consumption
30	KWFULK001	☐	RKESKWFULK	WERTV8	CURR	15	2	Fuel Costs
31	KWINSR001	☐	RKESKWINSR	WERTV8	CURR	15	2	Insurance
32	KWIREG001	☐	RKESKWIREG	WERTV8	CURR	15	2	Flight Irregularities
33	KWLFEE001	☐	RKESKWLFEE	WERTV8	CURR	15	2	Landing Fees
34	KWPAXR001	☐	RKESKWPAXR	WERTV8	CURR	15	2	Passenger Revenue
35	KWPAXS001	☐	RKESKWPAXS	MENGV15_3	QUAN	15	3	Number of Passengers
36	KWPXHD001	☐	RKESKWPXHD	WERTV8	CURR	15	2	Passenger Handling
37	KWRESV001	☐	RKESKWRESV	WERTV8	CURR	15	2	Reservation Costs
38	KWSEAT001	☐	RKESKWSEAT	MENGV15_3	QUAN	15	3	Number of Available Seats
39	KWVERW001	☐	RKESKWVERW	WERTV8	CURR	15	2	Administration Costs
40	KWAGTK001	☐	RKESKWAGTK	WERTV8	CURR	15	2	Sales Agent Commission
41	KWWTFX001	☐	RKESKWWTFX	WERTV8	CURR	15	2	Fixed Maintenance Costs
42	KWWTVA001	☐	RKESKWWTVA	WERTV8	CURR	15	2	Variable Maintenance Costs
43	KWCRGK001	☐	RKESKWCRGK	WERTV8	CURR	15	2	Crew Salaries
44	KWSMKT001	☐	RKESKWSMKT	WERTV8	CURR	15	2	Sales & Marketing
45	KWGRHD001	☐	RKESKWGRHD	WERTV8	CURR	15	2	Ground Handling
46	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	CE3S_AL	MANDT	T000	MANDT	KEY	1	CN
2	CE3S_AL	PALEDGER	TKEL	PALEDGER	KEY	1	CN
3	CE3S_AL	VERSI	TKVS	VERSI	KEY	1	CN
4	CE3S_AL	VRGAR	TVGA	VRGAR	KEY	1	CN

History

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