SAP ABAP Table CE0S_AL (Airline Route Profit)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ CO-PA (Application Component) Profitability Analysis
⤷ KEG2 (Package) Profitability Analysis: Generated Objects (Transportable)
⤷ CO-PA (Application Component) Profitability Analysis
⤷ KEG2 (Package) Profitability Analysis: Generated Objects (Transportable)
Basic Data
Table Category | INTTAB | Structure |
Structure | CE0S_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 | VRGAR | RKE_VRGAR | VRGAR | CHAR | 1 | 0 | Record Type | TVGA | |
4 | VERSI | RKEVERSI | COVERSI | CHAR | 3 | 0 | Plan version (CO-PA) | TKVS | |
5 | PERIO | JAHRPER | JAHRPER | NUMC | 7 | 0 | Period/year | ||
6 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
7 | PASUBNR | RKESUBNR | RKESUBNR | NUMC | 4 | 0 | Profitability Segment Changes (CO-PA) | ||
8 | BELNR | RKE_BELNR | BELNR | CHAR | 10 | 0 | Document number of line item in Profitability Analysis | ||
9 | POSNR | RKE_POSNR | RKE_POSNR | CHAR | 6 | 0 | Item no. of CO-PA line item | ||
10 | HZDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
11 | USNAM | ERFASSER | USNAM | CHAR | 12 | 0 | Created by | ||
12 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
13 | PERDE | PERIODE | NUM3 | NUMC | 3 | 0 | Period | ||
14 | WADAT | WADAT | DATUM | DATS | 8 | 0 | Goods Issue Date | ||
15 | FADAT | FADAT | DATUM | DATS | 8 | 0 | Invoice date (date created) | ||
16 | BUDAT | DAERF | DATUM | DATS | 8 | 0 | Posting Date | ||
17 | ALTPERIO | JAHRPERALT | JAHRPER | NUMC | 7 | 0 | Period/year in alternative period type | ||
18 | PAPAOBJNR | RKEPOBJ | RKEOBJNR | NUMC | 10 | 0 | Partner profitability segment number (CO-PA) | ||
19 | PAPASUBNR | RKEPSUBNR | RKESUBNR | NUMC | 4 | 0 | Changes to partner profitability segments (CO-PA) | ||
20 | KNDNR | KUNDE_PA | KUNNR | CHAR | 10 | 0 | Customer | KNA1 | |
21 | ARTNR | ARTNR | MATNR | CHAR | 18 | 0 | Product number | MARA | |
22 | FKART | FKART | FKART | CHAR | 4 | 0 | Billing Type | TVFK | |
23 | FRWAE | FRWAE | WAERS | CUKY | 5 | 0 | Foreign currency key | TCURC | |
24 | KURSF | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
25 | KURSBK | KURSBK | KURSF | DEC | 9 | 5 | Exchange rate for op.concern currency -> Co.code currency | ||
26 | KURSKZ | KURSKZ | KURSF | DEC | 9 | 5 | Exchange rate op.concern currency -> group currency | ||
27 | REC_WAERS | RKE_REC_WAERS | WAERS | CUKY | 5 | 0 | Currency of the data record | TCURC | |
28 | KAUFN | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
29 | KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
30 | RKAUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
31 | SKOST | SKOST | KOSTL | CHAR | 10 | 0 | Sender cost center | CSKS | |
32 | PRZNR | SEPRZ | CO_PRZNR | CHAR | 12 | 0 | Sender Business Process | CBPR | |
33 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
34 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
35 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
36 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
37 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
38 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
39 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
40 | HRKFT | RKEHERK | RKEHERK | CHAR | 4 | 0 | Origins (CO-PA) | ||
41 | PLIKZ | PLIKZ | PLIKZ | CHAR | 1 | 0 | Plan/Actual Indicator | ||
42 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | CSKA | |
43 | PSPNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
44 | KSTRG | KSTRG | KSTRG | CHAR | 12 | 0 | Cost Object | CKPH | |
45 | RBELN | RKERFBELNR | BELNR | CHAR | 10 | 0 | Reference document number for CO-PA line item | ||
46 | RPOSN | RKERFPOSNR | RKE_POSNR | CHAR | 6 | 0 | Item number from reference document (CO-PA) | ||
47 | STO_BELNR | RKE_STO_BELNR | BELNR | CHAR | 10 | 0 | Canceled document | ||
48 | STO_POSNR | RKE_STO_POSNR | RKE_POSNR | CHAR | 6 | 0 | Canceled document item | ||
49 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
50 | PPRCTR | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | CEPC | |
51 | RKESTATU | RKESTATU | RKESTATU | CHAR | 10 | 0 | Update status for CO-PA line items | ||
52 | TIMESTMP | RKE_HZSTMP | RKE_TSTMP | DEC | 16 | 0 | Time created (Greenwich Meantime) | ||
53 | COPA_AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
54 | COPA_AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
55 | COPA_BWZPT | BWZPT | BWZPT | CHAR | 1 | 0 | CO-PA Point of valuation | ||
56 | COPA_AWSYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | TBDLS | |
57 | WTGBTR | WTGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Transaction Currency | ||
58 | WOGBTR | WOGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Object Currency | ||
59 | WKGBTR | WKGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Controlling Area Currency | ||
60 | WKFBTR | WKFXXX | WERTV8 | CURR | 15 | 2 | Fixed Value in Controlling Area Currency | ||
61 | MEGBTR | MEGXXX | MENGV8 | QUAN | 15 | 3 | Total Quantity | ||
62 | MEINH | CO_MEINH | MEINS | UNIT | 3 | 0 | Unit of Measure | T006 | |
63 | KNT_FRM_KZ | RKE_KNTFRM | RKE_KNTFRM | NUMC | 1 | 0 | Indicator for use in account-based Profitability Analysis | ||
64 | VALUTYP | VALUTYP_ACT | VALUTYP | NUMC | 1 | 0 | Valuation | ||
65 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | CSLA | |
66 | KMATYP | RKESKMATYP | RKESKMATYP | NUMC | 2 | 0 | Aircraft Type | T2209 | |
67 | KMDEST | RKESKMDEST | RKESKMDEST | CHAR | 5 | 0 | Destination | T2211 | |
68 | KMFLTN | RKESKMFLTN | RKESKMFLTN | CHAR | 6 | 0 | Flight Number | T2215 | |
69 | KMFLTY | RKESKMFLTY | RKESKMFLTY | CHAR | 4 | 0 | Flight Type | T2216 | |
70 | KMIATA | RKESKMIATA | RKESKMIATA | CHAR | 5 | 0 | IATA Season | T2207 | |
71 | KMLEGS | RKESKMLEGS | RKESKMLEGS | CHAR | 7 | 0 | Route Segment | T2213 | |
72 | KMOPDY | RKESKMOPDY | RKESKMOPDY | CHAR | 2 | 0 | Day of Operation | T2208 | |
73 | KMORIG | RKESKMORIG | RKESKMORIG | CHAR | 5 | 0 | Departure Location | T2212 | |
74 | KMROUT | RKESKMROUT | RKESKMROUT | CHAR | 5 | 0 | Rotation | T2210 | |
75 | KMZONE | RKESKMZONE | RKESKMZONE | CHAR | 5 | 0 | Zone | T2214 | |
76 | KWBLOK_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
77 | KWFLHR_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
78 | KWFLKM_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
79 | KWFUEL_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
80 | KWPAXS_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
81 | KWSEAT_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
82 | KWBKPZ_ME | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
83 | KWBLKS | RKESKWBLKS | WERTV8 | CURR | 15 | 2 | Revenue: Block Seats | ||
84 | KWBLOK | RKESKWBLOK | MENGV15_3 | QUAN | 15 | 3 | Block Hours | ||
85 | KWCATR | RKESKWCATR | WERTV8 | CURR | 15 | 2 | Catering | ||
86 | KWCRWK | RKESKWCRWK | WERTV8 | CURR | 15 | 2 | Crew Expenses | ||
87 | KWDEPR | RKESKWDEPR | WERTV8 | CURR | 15 | 2 | Depreciation | ||
88 | KWEURO | RKESKWEURO | WERTV8 | CURR | 15 | 2 | Overflight Fees | ||
89 | KWEXLR | RKESKWEXLR | WERTV8 | CURR | 15 | 2 | Excess Luggage | ||
90 | KWFLHR | RKESKWFLHR | MENGV15_3 | QUAN | 15 | 3 | Flight Hours | ||
91 | KWFLKM | RKESKWFLKM | MENGV15_3 | QUAN | 15 | 3 | Number of Kilometers Flown | ||
92 | KWFLSC | RKESKWFLSC | WERTV8 | CURR | 15 | 2 | Flight Cost of Sales | ||
93 | KWFLSR | RKESKWFLSR | WERTV8 | CURR | 15 | 2 | In Flight Sales | ||
94 | KWFRGR | RKESKWFRGR | WERTV8 | CURR | 15 | 2 | Freight | ||
95 | KWFUEL | RKESKWFUEL | MENGV15_3 | QUAN | 15 | 3 | Fuel Consumption | ||
96 | KWFULK | RKESKWFULK | WERTV8 | CURR | 15 | 2 | Fuel Costs | ||
97 | KWINSR | RKESKWINSR | WERTV8 | CURR | 15 | 2 | Insurance | ||
98 | KWIREG | RKESKWIREG | WERTV8 | CURR | 15 | 2 | Flight Irregularities | ||
99 | KWLFEE | RKESKWLFEE | WERTV8 | CURR | 15 | 2 | Landing Fees | ||
100 | KWPAXR | RKESKWPAXR | WERTV8 | CURR | 15 | 2 | Passenger Revenue | ||
101 | KWPAXS | RKESKWPAXS | MENGV15_3 | QUAN | 15 | 3 | Number of Passengers | ||
102 | KWPXHD | RKESKWPXHD | WERTV8 | CURR | 15 | 2 | Passenger Handling | ||
103 | KWRESV | RKESKWRESV | WERTV8 | CURR | 15 | 2 | Reservation Costs | ||
104 | KWSEAT | RKESKWSEAT | MENGV15_3 | QUAN | 15 | 3 | Number of Available Seats | ||
105 | KWVERW | RKESKWVERW | WERTV8 | CURR | 15 | 2 | Administration Costs | ||
106 | KWAGTK | RKESKWAGTK | WERTV8 | CURR | 15 | 2 | Sales Agent Commission | ||
107 | KWWTFX | RKESKWWTFX | WERTV8 | CURR | 15 | 2 | Fixed Maintenance Costs | ||
108 | KWWTVA | RKESKWWTVA | WERTV8 | CURR | 15 | 2 | Variable Maintenance Costs | ||
109 | KWCRGK | RKESKWCRGK | WERTV8 | CURR | 15 | 2 | Crew Salaries | ||
110 | KWSMKT | RKESKWSMKT | WERTV8 | CURR | 15 | 2 | Sales & Marketing | ||
111 | KWGRHD | RKESKWGRHD | WERTV8 | CURR | 15 | 2 | Ground Handling | ||
112 | KWBKPZ | RKESKWBKPZ | MENGV15_3 | QUAN | 15 | 3 | Number of Block Seats |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |