SAP ABAP Table CE5S_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	INTTAB	Structure
Structure	CE5S_AL	Table Relationship Diagram
Short Description	Airline Route Profit

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	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	PLIKZ	☐	PLIKZ	PLIKZ	CHAR	1	0	Plan/Actual Indicator
5	VERSI	☐	RKEVERSI	COVERSI	CHAR	3	0	Plan version (CO-PA)	TKVS
6	HRKFT	☐	RKEHERK	RKEHERK	CHAR	4	0	Origins (CO-PA)
7	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
8	PASUBNR	☐	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
9	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
10	ALTPERIO	☐	JAHRPERALT	JAHRPER	NUMC	7	0	Period/year in alternative period type
11	WTGBTR	☐	WTGXXX	WERTV8	CURR	15	2	Total Value in Transaction Currency
12	WOGBTR	☐	WOGXXX	WERTV8	CURR	15	2	Total Value in Object Currency
13	WKGBTR	☐	WKGXXX	WERTV8	CURR	15	2	Total Value in Controlling Area Currency
14	WKFBTR	☐	WKFXXX	WERTV8	CURR	15	2	Fixed Value in Controlling Area Currency
15	MEGBTR	☐	MEGXXX	MENGV8	QUAN	15	3	Total Quantity
16	KWBLKS	☐	RKESKWBLKS	WERTV8	CURR	15	2	Revenue: Block Seats
17	KWBLOK	☐	RKESKWBLOK	MENGV15_3	QUAN	15	3	Block Hours
18	KWCATR	☐	RKESKWCATR	WERTV8	CURR	15	2	Catering
19	KWCRWK	☐	RKESKWCRWK	WERTV8	CURR	15	2	Crew Expenses
20	KWDEPR	☐	RKESKWDEPR	WERTV8	CURR	15	2	Depreciation
21	KWEURO	☐	RKESKWEURO	WERTV8	CURR	15	2	Overflight Fees
22	KWEXLR	☐	RKESKWEXLR	WERTV8	CURR	15	2	Excess Luggage
23	KWFLHR	☐	RKESKWFLHR	MENGV15_3	QUAN	15	3	Flight Hours
24	KWFLKM	☐	RKESKWFLKM	MENGV15_3	QUAN	15	3	Number of Kilometers Flown
25	KWFLSC	☐	RKESKWFLSC	WERTV8	CURR	15	2	Flight Cost of Sales
26	KWFLSR	☐	RKESKWFLSR	WERTV8	CURR	15	2	In Flight Sales
27	KWFRGR	☐	RKESKWFRGR	WERTV8	CURR	15	2	Freight
28	KWFUEL	☐	RKESKWFUEL	MENGV15_3	QUAN	15	3	Fuel Consumption
29	KWFULK	☐	RKESKWFULK	WERTV8	CURR	15	2	Fuel Costs
30	KWINSR	☐	RKESKWINSR	WERTV8	CURR	15	2	Insurance
31	KWIREG	☐	RKESKWIREG	WERTV8	CURR	15	2	Flight Irregularities
32	KWLFEE	☐	RKESKWLFEE	WERTV8	CURR	15	2	Landing Fees
33	KWPAXR	☐	RKESKWPAXR	WERTV8	CURR	15	2	Passenger Revenue
34	KWPAXS	☐	RKESKWPAXS	MENGV15_3	QUAN	15	3	Number of Passengers
35	KWPXHD	☐	RKESKWPXHD	WERTV8	CURR	15	2	Passenger Handling
36	KWRESV	☐	RKESKWRESV	WERTV8	CURR	15	2	Reservation Costs
37	KWSEAT	☐	RKESKWSEAT	MENGV15_3	QUAN	15	3	Number of Available Seats
38	KWVERW	☐	RKESKWVERW	WERTV8	CURR	15	2	Administration Costs
39	KWAGTK	☐	RKESKWAGTK	WERTV8	CURR	15	2	Sales Agent Commission
40	KWWTFX	☐	RKESKWWTFX	WERTV8	CURR	15	2	Fixed Maintenance Costs
41	KWWTVA	☐	RKESKWWTVA	WERTV8	CURR	15	2	Variable Maintenance Costs
42	KWCRGK	☐	RKESKWCRGK	WERTV8	CURR	15	2	Crew Salaries
43	KWSMKT	☐	RKESKWSMKT	WERTV8	CURR	15	2	Sales & Marketing
44	KWGRHD	☐	RKESKWGRHD	WERTV8	CURR	15	2	Ground Handling
45	KWBKPZ	☐	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	CE5S_AL	MANDT	T000	MANDT	REF	C	CN
2	CE5S_AL	PALEDGER	TKEL	PALEDGER	REF	C	CN
3	CE5S_AL	VERSI	TKVS	VERSI	REF	C	CN
4	CE5S_AL	VRGAR	TVGA	VRGAR	REF	C	CN

History

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