SAP ABAP Table CE4S_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	CE4S_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	AKTBO	☑	AKTBO	CHAR1	CHAR	1	0	Current profitability segment (CO-PA)
3	PAOBJNR	☑	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
4	PASUBNR	☑	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
5	BISDAT	☐	AUFDATBI	DATUM	DATS	8	0	Valid to
6	KNT_FRM_KZ	☐	RKE_KNTFRM	RKE_KNTFRM	NUMC	1	0	Indicator for use in account-based Profitability Analysis
7	UNUSED_CE3	☐	COPA_UNUSED_CE3	COPA_UNUSED_CE3	CHAR	1	0	Flag: NOT Posted to Costing-Based Profitability Analysis
8	KNDNR	☐	KUNDE_PA	KUNNR	CHAR	10	0	Customer	KNA1
9	ARTNR	☐	ARTNR	MATNR	CHAR	18	0	Product number	MARA
10	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
11	KAUFN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
12	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
13	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
17	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
18	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
19	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
20	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
21	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
22	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
23	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
24	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
25	MEINH	☐	CO_MEINH	MEINS	UNIT	3	0	Unit of Measure	T006
26	KMATYP	☐	RKESKMATYP	RKESKMATYP	NUMC	2	0	Aircraft Type	T2209
27	KMDEST	☐	RKESKMDEST	RKESKMDEST	CHAR	5	0	Destination	T2211
28	KMFLTN	☐	RKESKMFLTN	RKESKMFLTN	CHAR	6	0	Flight Number	T2215
29	KMFLTY	☐	RKESKMFLTY	RKESKMFLTY	CHAR	4	0	Flight Type	T2216
30	KMIATA	☐	RKESKMIATA	RKESKMIATA	CHAR	5	0	IATA Season	T2207
31	KMLEGS	☐	RKESKMLEGS	RKESKMLEGS	CHAR	7	0	Route Segment	T2213
32	KMOPDY	☐	RKESKMOPDY	RKESKMOPDY	CHAR	2	0	Day of Operation	T2208
33	KMORIG	☐	RKESKMORIG	RKESKMORIG	CHAR	5	0	Departure Location	T2212
34	KMROUT	☐	RKESKMROUT	RKESKMROUT	CHAR	5	0	Rotation	T2210
35	KMZONE	☐	RKESKMZONE	RKESKMZONE	CHAR	5	0	Zone	T2214
36	KWBLOK_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
37	KWFLHR_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
38	KWFLKM_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
39	KWFUEL_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
40	KWPAXS_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
41	KWSEAT_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
42	KWBKPZ_ME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CE4S_AL	ARTNR	MARA	MATNR	REF	C	CN
2	CE4S_AL	AUFNR	AUFK	AUFNR	REF	C	CN
3	CE4S_AL	BUKRS	T001	BUKRS	REF	C	CN
4	CE4S_AL	FKART	TVFK	FKART	REF	C	CN
5	CE4S_AL	GSBER	TGSB	GSBER	REF	C	CN
6	CE4S_AL	KAUFN	VBUK	VBELN	REF	C	CN
7	CE4S_AL	KMATYP	T2209	KMATYP	REF	C	CN
8	CE4S_AL	KMDEST	T2211	KMDEST	REF	C	CN
9	CE4S_AL	KMFLTN	T2215	KMFLTN	REF	C	CN
10	CE4S_AL	KMFLTY	T2216	KMFLTY	REF	C	CN
11	CE4S_AL	KMIATA	T2207	KMIATA	REF	C	CN
12	CE4S_AL	KMLEGS	T2213	KMLEGS	REF	C	CN
13	CE4S_AL	KMOPDY	T2208	KMOPDY	REF	C	CN
14	CE4S_AL	KMORIG	T2212	KMORIG	REF	C	CN
15	CE4S_AL	KMROUT	T2210	KMROUT	REF	C	CN
16	CE4S_AL	KMZONE	T2214	KMZONE	REF	C	CN
17	CE4S_AL	KNDNR	KNA1	KUNNR	REF	C	CN
18	CE4S_AL	KOKRS	TKA01	KOKRS	REF	C	CN
19	CE4S_AL	KSTRG	CKPH	KSTRG	REF	C	CN
20	CE4S_AL	KWBKPZ_ME	T006	MSEHI	REF	C	CN
21	CE4S_AL	KWBLOK_ME	T006	MSEHI	REF	C	CN
22	CE4S_AL	KWFLHR_ME	T006	MSEHI	REF	C	CN
23	CE4S_AL	KWFLKM_ME	T006	MSEHI	REF	C	CN
24	CE4S_AL	KWFUEL_ME	T006	MSEHI	REF	C	CN
25	CE4S_AL	KWPAXS_ME	T006	MSEHI	REF	C	CN
26	CE4S_AL	KWSEAT_ME	T006	MSEHI	REF	C	CN
27	CE4S_AL	MANDT	T000	MANDT	KEY	1	CN
28	CE4S_AL	MEINH	T006	MSEHI	REF	C	CN
29	CE4S_AL	PPRCTR	CEPC	PRCTR	REF	C	CN
30	CE4S_AL	PRCTR	CEPC	PRCTR	REF	C	CN
31	CE4S_AL	PSPNR	PRPS	PSPNR	REF	C	CN
32	CE4S_AL	SPART	TSPA	SPART	REF	C	CN
33	CE4S_AL	VKORG	TVKO	VKORG	REF	C	CN
34	CE4S_AL	VTWEG	TVTW	VTWEG	REF	C	CN
35	CE4S_AL	WERKS	T001W	WERKS	REF	C	CN

History

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