CE9S_AL_H - Airline Route Profit

Airline Route Profit information is stored in SAP table CE9S_AL_H.
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 CE9S_AL_H

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BELNR	Line Item Document Number	X	KEPSL_DOCNO	CHAR	20
POSNR	Item number line item	X	KEPSL_POSNR	CHAR	12
SUBNR	Item subnumber of line item	X	KEPSL_SUBNR	CHAR	12
VRGAR	Record Type		RKE_VRGAR	CHAR	2	TVGA
VERSI	Plan version (CO-PA)		RKEVERSI	CHAR	6	TKVS
PERIO	Period/Year		JAHRPER	NUMC	14
GJAHR	Fiscal Year		GJAHR	NUMC	8
PERDE	Period		PERIODE	NUMC	6
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
USNAM	Created by		ERFASSER	CHAR	24
CPUDT	Date Document Was Created		CO_CPUDT	DATS	16
CPUTM	Created at		KEPSL_CPUTM	TIMS	12
TIMESTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
BUDAT	Posting Date		DAERF	DATS	16
WADAT	Goods Issue Date		WADAT	DATS	16
FADAT	Invoice date (date created)		FADAT	DATS	16
BWZPT	CO-PA Point of valuation		BWZPT	CHAR	2
BILLED	Indicator: billed		KEPSL_DELIV_BILLED	CHAR	2
PERIO_BILLED	Billing Period		KEPSL_PERIO_BILLED	NUMC	14
AWTYP	Reference procedure		AWTYP	CHAR	10
AWORG	Reference Organizational Units		AWORG	CHAR	20
AWSYS	Logical system of source document		AWSYS	CHAR	20
RBELN	Reference document number for CO-PA line item		RKERFBELNR	CHAR	20
RPOSN	Item number from reference document (CO-PA)		RKERFPOSNR	CHAR	12
RSUBN	Reference Subitem number		KEPSL_REFSUBNR	CHAR	12
STO_BELNR	Canceled document		RKE_STO_BELNR	CHAR	20
STO_POSNR	Canceled document item		RKE_STO_POSNR	CHAR	12
STO_SUBNR	Canceled subnumber of line item		RKE_STO_SUBNR	CHAR	12
STO_RBELNR_I	Deleted by document		KEPSL_REV_DOCNO_INT	CHAR	20
STO_RPOSNR_I	Deleted by item		KEPSL_REV_DOCPOS_INT	CHAR	12
STO_RBELNR_E	Canceled by document		KEPSL_REV_DOCNO_EXT	CHAR	20
STO_RPOSNR_E	Canceled document item		KEPSL_REV_DOCPOS_EXT	CHAR	12
KAUFN	Sales Order Number		KDAUF	CHAR	20	VBUK
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
AUFNR	Order Number		AUFNR	CHAR	24	AUFK
LIEFNR	Delivery		VBELN_VL	CHAR	20	VBUK
LIEFPOS	Delivery Item		POSNR_VL	NUMC	12
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
FKBER	Functional Area		FKBER	CHAR	32
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVTW
SPART	Division		SPART	CHAR	4	TSPA
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
PPRCTR	Partner Profit Center		PPRCTR	CHAR	20	CEPC
SKOST	Sender cost center		SKOST	CHAR	20	CSKS
PRZNR	Sender Business Process		SEPRZ	CHAR	24	CBPR
COPA_KOSTL	Cost center		COPA_KOSTL	CHAR	20
KNDNR	Customer		KUNDE_PA	CHAR	20	KNA1
ARTNR	Product number		ARTNR	CHAR	80	MARA
KSTRG	Cost Object		KSTRG	CHAR	24	CKPH
PSPNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
FKART	Billing Type		FKART	CHAR	8	TVFK
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