CE1S_AL - Airline Route Profit

Airline Route Profit information is stored in SAP table CE1S_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 CE1S_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
PERIO	Period/Year	X	JAHRPER	NUMC	14
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
POSNR	Item no. of CO-PA line item	X	RKE_POSNR	CHAR	12
HZDAT	Date on which the record was created		ERDAT	DATS	16
USNAM	Created by		ERFASSER	CHAR	24
GJAHR	Fiscal Year		GJAHR	NUMC	8
PERDE	Period		PERIODE	NUMC	6
WADAT	Goods Issue Date		WADAT	DATS	16
FADAT	Invoice date (date created)		FADAT	DATS	16
BUDAT	Posting Date		DAERF	DATS	16
ALTPERIO	Period/year in alternative period type		JAHRPERALT	NUMC	14
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
KURSF	Exchange rate		KURSF	DEC	5
KURSBK	Exchange rate for op.concern currency -> Co.code currency		KURSBK	DEC	5
KURSKZ	Exchange rate op.concern currency -> group currency		KURSKZ	DEC	5
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
PLIKZ	Plan/Actual Indicator		PLIKZ	CHAR	2
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
STO_BELNR	Canceled document		RKE_STO_BELNR	CHAR	20
STO_POSNR	Canceled document item		RKE_STO_POSNR	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
COPA_AWTYP	Reference procedure		AWTYP	CHAR	10
COPA_AWORG	Reference Organizational Units		AWORG	CHAR	20
COPA_BWZPT	CO-PA Point of valuation		BWZPT	CHAR	2
COPA_AWSYS	Logical system of source document		AWSYS	CHAR	20	TBDLS
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
KWBLKS	Revenue: Block Seats		RKESKWBLKS	CURR	12
KWBLOK	Block Hours		RKESKWBLOK	QUAN	8
KWCATR	Catering		RKESKWCATR	CURR	12
KWCRWK	Crew Expenses		RKESKWCRWK	CURR	12
KWDEPR	Depreciation		RKESKWDEPR	CURR	12
KWEURO	Overflight Fees		RKESKWEURO	CURR	12
KWEXLR	Excess Luggage		RKESKWEXLR	CURR	12
KWFLHR	Flight Hours		RKESKWFLHR	QUAN	8
KWFLKM	Number of Kilometers Flown		RKESKWFLKM	QUAN	8
KWFLSC	Flight Cost of Sales		RKESKWFLSC	CURR	12
KWFLSR	In Flight Sales		RKESKWFLSR	CURR	12
KWFRGR	Freight		RKESKWFRGR	CURR	12
KWFUEL	Fuel Consumption		RKESKWFUEL	QUAN	8
KWFULK	Fuel Costs		RKESKWFULK	CURR	12
KWINSR	Insurance		RKESKWINSR	CURR	12
KWIREG	Flight Irregularities		RKESKWIREG	CURR	12
KWLFEE	Landing Fees		RKESKWLFEE	CURR	12
KWPAXR	Passenger Revenue		RKESKWPAXR	CURR	12
KWPAXS	Number of Passengers		RKESKWPAXS	QUAN	8
KWPXHD	Passenger Handling		RKESKWPXHD	CURR	12
KWRESV	Reservation Costs		RKESKWRESV	CURR	12
KWSEAT	Number of Available Seats		RKESKWSEAT	QUAN	8
KWVERW	Administration Costs		RKESKWVERW	CURR	12
KWAGTK	Sales Agent Commission		RKESKWAGTK	CURR	12
KWWTFX	Fixed Maintenance Costs		RKESKWWTFX	CURR	12
KWWTVA	Variable Maintenance Costs		RKESKWWTVA	CURR	12
KWCRGK	Crew Salaries		RKESKWCRGK	CURR	12
KWSMKT	Sales & Marketing		RKESKWSMKT	CURR	12
KWGRHD	Ground Handling		RKESKWGRHD	CURR	12
KWBKPZ	Number of Block Seats		RKESKWBKPZ	QUAN	8