CE2S_AL - Airline Route Profit

Airline Route Profit information is stored in SAP table CE2S_AL.
It is part of development package KEG2 in software component CO-PA. This development package consists of objects that can be grouped under "Profitability Analysis: Generated Objects (Transportable)".

Fields for table CE2S_AL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
PALEDGER	Currency type for an operating concern	X	LEDBO	CHAR	4	TKEL
VRGAR	Record Type	X	RKE_VRGAR	CHAR	2	TVGA
VERSI	Plan version (CO-PA)	X	RKEVERSI	CHAR	6	TKVS
PAOBJNR	Profitability Segment Number (CO-PA)	X	RKEOBJNR	NUMC	20
PASUBNR	Profitability Segment Changes (CO-PA)	X	RKESUBNR	NUMC	8
BELNR	Document number of line item in Profitability Analysis	X	RKE_BELNR	CHAR	20
PERBL	Fiscal year/period block	X	JAHRPERBL	NUMC	14
HZDAT	Date on which the record was created		ERDAT	DATS	16
USNAM	Created by		ERFASSER	CHAR	24
GJAHR	Fiscal Year		GJAHR	NUMC	8
PAPAOBJNR	Partner profitability segment number (CO-PA)		RKEPOBJ	NUMC	20
PAPASUBNR	Changes to partner profitability segments (CO-PA)		RKEPSUBNR	NUMC	8
KNDNR	Customer		KUNDE_PA	CHAR	20	KNA1
ARTNR	Product number		ARTNR	CHAR	80	MARA
FKART	Billing Type		FKART	CHAR	8	TVFK
FRWAE	Foreign currency key		FRWAE	CUKY	10	TCURC
REC_WAERS	Currency of the data record		RKE_REC_WAERS	CUKY	10	TCURC
KAUFN	Sales Order Number		KDAUF	CHAR	20
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
RKAUFNR	Order Number		AUFNR	CHAR	24	AUFK
SKOST	Sender cost center		SKOST	CHAR	20	CSKS
PRZNR	Sender Business Process		SEPRZ	CHAR	24	CBPR
BUKRS	Company Code		BUKRS	CHAR	8	T001
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
WERKS	Plant		WERKS_D	CHAR	8	T001W
GSBER	Business Area		GSBER	CHAR	8	TGSB
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVTW
SPART	Division		SPART	CHAR	4	TSPA
HRKFT	Origins (CO-PA)		RKEHERK	CHAR	8
KSTAR	Cost Element		KSTAR	CHAR	20	CSKA
PSPNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
KSTRG	Cost Object		KSTRG	CHAR	24	CKPH
RBELN	Reference document number for CO-PA line item		RKERFBELNR	CHAR	20
RPOSN	Item number from reference document (CO-PA)		RKERFPOSNR	CHAR	12
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
PPRCTR	Partner Profit Center		PPRCTR	CHAR	20	CEPC
RKESTATU	Update status for CO-PA line items		RKESTATU	CHAR	20
TIMESTMP	Time created (Greenwich Meantime)		RKE_HZSTMP	DEC	9
KMATYP	Aircraft Type		RKESKMATYP	NUMC	4	T2209
KMDEST	Destination		RKESKMDEST	CHAR	10	T2211
KMFLTN	Flight Number		RKESKMFLTN	CHAR	12	T2215
KMFLTY	Flight Type		RKESKMFLTY	CHAR	8	T2216
KMIATA	IATA Season		RKESKMIATA	CHAR	10	T2207
KMLEGS	Route Segment		RKESKMLEGS	CHAR	14	T2213
KMOPDY	Day of Operation		RKESKMOPDY	CHAR	4	T2208
KMORIG	Departure Location		RKESKMORIG	CHAR	10	T2212
KMROUT	Rotation		RKESKMROUT	CHAR	10	T2210
KMZONE	Zone		RKESKMZONE	CHAR	10	T2214
KWBLOK_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWFLHR_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWFLKM_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWFUEL_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWPAXS_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWSEAT_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWBKPZ_ME	Base Unit of Measure		MEINS	UNIT	6	T006
KWBLKS001	Revenue: Block Seats		RKESKWBLKS	CURR	12
KWBLOK001	Block Hours		RKESKWBLOK	QUAN	8
KWCATR001	Catering		RKESKWCATR	CURR	12
KWCRWK001	Crew Expenses		RKESKWCRWK	CURR	12
KWDEPR001	Depreciation		RKESKWDEPR	CURR	12
KWEURO001	Overflight Fees		RKESKWEURO	CURR	12
KWEXLR001	Excess Luggage		RKESKWEXLR	CURR	12
KWFLHR001	Flight Hours		RKESKWFLHR	QUAN	8
KWFLKM001	Number of Kilometers Flown		RKESKWFLKM	QUAN	8
KWFLSC001	Flight Cost of Sales		RKESKWFLSC	CURR	12
KWFLSR001	In Flight Sales		RKESKWFLSR	CURR	12
KWFRGR001	Freight		RKESKWFRGR	CURR	12
KWFUEL001	Fuel Consumption		RKESKWFUEL	QUAN	8
KWFULK001	Fuel Costs		RKESKWFULK	CURR	12
KWINSR001	Insurance		RKESKWINSR	CURR	12
KWIREG001	Flight Irregularities		RKESKWIREG	CURR	12
KWLFEE001	Landing Fees		RKESKWLFEE	CURR	12
KWPAXR001	Passenger Revenue		RKESKWPAXR	CURR	12
KWPAXS001	Number of Passengers		RKESKWPAXS	QUAN	8
KWPXHD001	Passenger Handling		RKESKWPXHD	CURR	12
KWRESV001	Reservation Costs		RKESKWRESV	CURR	12
KWSEAT001	Number of Available Seats		RKESKWSEAT	QUAN	8
KWVERW001	Administration Costs		RKESKWVERW	CURR	12
KWAGTK001	Sales Agent Commission		RKESKWAGTK	CURR	12
KWWTFX001	Fixed Maintenance Costs		RKESKWWTFX	CURR	12
KWWTVA001	Variable Maintenance Costs		RKESKWWTVA	CURR	12
KWCRGK001	Crew Salaries		RKESKWCRGK	CURR	12
KWSMKT001	Sales & Marketing		RKESKWSMKT	CURR	12
KWGRHD001	Ground Handling		RKESKWGRHD	CURR	12
KWBKPZ001	Number of Block Seats		RKESKWBKPZ	QUAN	8