SAP ABAP Table CE7S_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 CE7S_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 ERKRS ERKRS ERKRS CHAR 4   0   Operating concern TKEB
4 VRGAR RKE_VRGAR VRGAR CHAR 1   0   Record Type TVGA
5 PLIKZ PLIKZ PLIKZ CHAR 1   0   Plan/Actual Indicator  
6 VERSI RKEVERSI_R COVERSI CHAR 3   0   Receiver version (CO-PA) TKVS
7 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
8 FIELDNAME FIELDNAME FDNAME CHAR 30   0   Field Name *
9 KNDNR KUNDE_PA KUNNR CHAR 10   0   Customer KNA1
10 ARTNR ARTNR MATNR CHAR 18   0   Product number MARA
11 FKART FKART FKART CHAR 4   0   Billing Type TVFK
12 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
13 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
14 PERFLAG2 PERFLAG2 PERFLAG2 CHAR 1   0   Alternative period type indicator  
15 FRWAE FRWAE WAERS CUKY 5   0   Foreign currency key TCURC
16 KURSF KURSF KURSF DEC 9   5   Exchange rate  
17 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
18 ABLEDA ABLEITDAT DATUM DATS 8   0   Date for derivation of characteristics in planning  
19 KAUFN KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
20 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
21 RKAUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
22 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
23 S_BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
24 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
25 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
26 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
27 S_GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
28 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
29 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
30 SPART SPART SPART CHAR 2   0   Division TSPA
31 KSTRG KSTRG KSTRG CHAR 12   0   Cost Object CKPH
32 PSPNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
33 COPA_POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
34 COPA_CRMID RKECRMELEM_POSID PS_POSID CHAR 24   0   CRM Marketing Element  
35 PA_TYPE RKE_PATYP1 RKE_PATYP2 NUMC 1   0   Type of CO-PA as Basis for Determining Tracing Factor  
36 LEDNR LEDNR LEDNR CHAR 2   0   Ledger for Controlling objects  
37 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
38 WRTTP CO_WRTTP CO_WRTTP CHAR 2   0   Value Type  
39 VERSN VERSN_S COVERSI CHAR 3   0   Sender version TKA09
40 KSTAR KSTAR KSTAR CHAR 10   0   Cost Element *
41 VRGNG CO_VORGANG J_VORGANG CHAR 4   0   CO Business Transaction TJ01
42 PAROB PAROB J_OBJNR CHAR 22   0   Partner Object ONR00
43 USPOB USPOB J_OBJNR CHAR 22   0   Source Object (Cost Center/Activity Type) ONR00
44 BEKNZ BEKNZ BEKNZ CHAR 1   0   Debit/credit indicator  
45 TWAER TWAER WAERS CUKY 5   0   Transaction Currency TCURC
46 BUPER POPER POPER NUMC 3   0   Posting period  
47 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
48 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type CSLA
49 PRZNR CO_PRZNR CO_PRZNR CHAR 12   0   Business Process CBPR
50 OWAER OWAER WAERS CUKY 5   0   Currency Key TCURC
51 KWAER KWAER WAERS CUKY 5   0   Controlling area currency TCURC
52 MEINH CO_MEINH MEINS UNIT 3   0   Unit of Measure T006
53 KTOPL KTOPL KTOPL CHAR 4   0   Chart of Accounts T004
54 LMONA PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
55 INUMKR INUMKR CHAR2 CHAR 2   0   Internal number range  
56 SETKIND SETKIND SETKIND CHAR 1   0   Type of set  
57 BUDAT DAERF DATUM DATS 8   0   Posting Date  
58 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
59 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator T8JJ
60 ETYPE JV_ETYPE JV_ETYPE CHAR 3   0   Equity type T8JE
61 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
62 S_PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
63 PPRCTR PPRCTR PRCTR CHAR 10   0   Partner Profit Center CEPC
64 AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
65 SCOPE SCOPE_CV SCOPE_CV CHAR 2   0   Object Class  
66 LOGSYSTEM LOGSYSTEM LOGSYS CHAR 10   0   Logical System *
67 TARKZ TARKZ TARKZ CHAR 3   0   Price Indicator: Calculate Allocation Price TKA10
68 VKSTA VKSTA KSTAR CHAR 10   0   Allocation Cost Element CSKA
69 YRATE CO_YRATE XFELD CHAR 1   0   Price Calculation with Period-Based Average Prices  
70 FIXVO CO_FIXVO XFELD CHAR 1   0   Predistribution of fixed costs for acty type/bus. process  
71 TARKZ_I CO_TARKZ_I TARKZ CHAR 3   0   Indicator: Actual Allocation Price TKA10
72 MANIST CO_MANIST XFELD CHAR 1   0   Indicator: Confirm quantity manually in actual  
73 AUSFK AUSFK AUSFK DEC 5   2   Output factor  
74 AUSEH AUSEH MEINS UNIT 3   0   Output Unit *
75 LEINH LEINH MEINS UNIT 3   0   Activity Unit T006
76 ERZUO ERZUO ERZUO CHAR 3   0   PA Transfer structure assignment *
77 KMATYP RKESKMATYP RKESKMATYP NUMC 2   0   Aircraft Type T2209
78 KMDEST RKESKMDEST RKESKMDEST CHAR 5   0   Destination T2211
79 KMFLTN RKESKMFLTN RKESKMFLTN CHAR 6   0   Flight Number T2215
80 KMFLTY RKESKMFLTY RKESKMFLTY CHAR 4   0   Flight Type T2216
81 KMIATA RKESKMIATA RKESKMIATA CHAR 5   0   IATA Season T2207
82 KMLEGS RKESKMLEGS RKESKMLEGS CHAR 7   0   Route Segment T2213
83 KMOPDY RKESKMOPDY RKESKMOPDY CHAR 2   0   Day of Operation T2208
84 KMORIG RKESKMORIG RKESKMORIG CHAR 5   0   Departure Location T2212
85 KMROUT RKESKMROUT RKESKMROUT CHAR 5   0   Rotation T2210
86 KMZONE RKESKMZONE RKESKMZONE CHAR 5   0   Zone T2214
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CE7S_AL ARTNR MARA MATNR REF C CN
2 CE7S_AL BUKRS T001 BUKRS REF C CN
3 CE7S_AL ERKRS TKEB ERKRS KEY 1 CN
4 CE7S_AL ETYPE T8JE ETYPE REF C CN
5 CE7S_AL FKART TVFK FKART REF C CN
6 CE7S_AL FRWAE TCURC WAERS REF C CN
7 CE7S_AL GSBER TGSB GSBER REF C CN
8 CE7S_AL KAUFN VBUK VBELN REF C CN
9 CE7S_AL KMATYP T2209 KMATYP REF C CN
10 CE7S_AL KMDEST T2211 KMDEST REF C CN
11 CE7S_AL KMFLTN T2215 KMFLTN REF C CN
12 CE7S_AL KMFLTY T2216 KMFLTY REF C CN
13 CE7S_AL KMIATA T2207 KMIATA REF C CN
14 CE7S_AL KMLEGS T2213 KMLEGS REF C CN
15 CE7S_AL KMOPDY T2208 KMOPDY REF C CN
16 CE7S_AL KMORIG T2212 KMORIG REF C CN
17 CE7S_AL KMROUT T2210 KMROUT REF C CN
18 CE7S_AL KMZONE T2214 KMZONE REF C CN
19 CE7S_AL KNDNR KNA1 KUNNR REF C CN
20 CE7S_AL KOKRS TKA01 KOKRS REF C CN
21 CE7S_AL KOSTL CSKS KOSTL KEY 1 CN
22 CE7S_AL KSTRG CKPH KSTRG REF C CN
23 CE7S_AL KTOPL T004 KTOPL REF C CN
24 CE7S_AL KURST TCURV KURST REF C CN
25 CE7S_AL KWAER TCURC WAERS REF C CN
26 CE7S_AL LEINH T006 MSEHI REF C CN
27 CE7S_AL LMONA T009 PERIV REF C CN
28 CE7S_AL LSTAR CSLA LSTAR REF C CN
29 CE7S_AL MANDT T000 MANDT KEY 1 CN
30 CE7S_AL MEINH T006 MSEHI REF C CN
31 CE7S_AL OBJNR ONR00 OBJNR KEY 1 CN
32 CE7S_AL OWAER TCURC WAERS REF C CN
33 CE7S_AL PALEDGER TKEL PALEDGER KEY 1 CN
34 CE7S_AL PAROB ONR00 OBJNR KEY 1 CN
35 CE7S_AL PERIV T009 PERIV REF C CN
36 CE7S_AL PPRCTR CEPC PRCTR REF C CN
37 CE7S_AL PRCTR CEPC PRCTR REF C CN
38 CE7S_AL PRZNR CBPR PRZNR REF C CN
39 CE7S_AL PSPNR PRPS PSPNR REF C CN
40 CE7S_AL RECID T8JJ RECID REF C CN
41 CE7S_AL RKAUFNR AUFK AUFNR REF C CN
42 CE7S_AL SPART TSPA SPART REF C CN
43 CE7S_AL S_BUKRS T001 BUKRS REF C CN
44 CE7S_AL S_GSBER TGSB GSBER REF C CN
45 CE7S_AL TARKZ TKA10 TARKZ REF C CN
46 CE7S_AL TARKZ_I TKA10 TARKZ REF C CN
47 CE7S_AL TWAER TCURC WAERS KEY 1 CN
48 CE7S_AL USPOB ONR00 OBJNR REF C CN
49 CE7S_AL VERSI TKVS VERSI KEY 1 CN
50 CE7S_AL VERSN TKA09 VERSN KEY 1 CN
51 CE7S_AL VKORG TVKO VKORG REF C CN
52 CE7S_AL VKSTA CSKA KSTAR REF C CN
53 CE7S_AL VNAME T8JV VNAME REF C CN
54 CE7S_AL VRGAR TVGA VRGAR KEY 1 CN
55 CE7S_AL VRGNG TJ01 VRGNG KEY 1 CN
56 CE7S_AL VTWEG TVTW VTWEG REF C CN
57 CE7S_AL WAERS TCURC WAERS REF C CN
58 CE7S_AL WERKS T001W WERKS REF C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 46C