1. Home
  2. Resources
  3. SAP Tables
  4. CE5S_AL - Airline Route Profit

SAP Table CE5S_AL

Airline Route Profit

CE5S_AL (Airline Route Profit) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CE5S_AL to other SAP tables.

CE5S_AL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PALEDGER Currency type for an operating concern LEDBO TKEL CHAR 2 0
VRGAR Record Type RKE_VRGAR TVGA CHAR 1 0
PLIKZ Plan/Actual Indicator PLIKZ CHAR 1 0
0 Actual data
1 Planning data
VERSI Plan version (CO-PA) RKEVERSI TKVS CHAR 3 0
HRKFT Origins (CO-PA) RKEHERK CHAR 4 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PASUBNR Profitability segment changes (CO-PA) RKESUBNR NUMC 4 0
PERIO Period/year JAHRPER NUMC 7 0
ALTPERIO Period/year in alternative period type JAHRPERALT NUMC 7 0
WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
WKFBTR Fixed Value in Controlling Area Currency WKFXXX CURR 15 2
MEGBTR Total Quantity MEGXXX QUAN 15 3
KWBLKS Revenue: Block seats RKESKWBLKS CURR 15 2
KWBLOK Block Hours RKESKWBLOK QUAN 15 3
KWCATR Catering RKESKWCATR CURR 15 2
KWCRWK Crew Expenses RKESKWCRWK CURR 15 2
KWDEPR Depreciation RKESKWDEPR CURR 15 2
KWEURO Overflight Fees RKESKWEURO CURR 15 2
KWEXLR Excess Luggage RKESKWEXLR CURR 15 2
KWFLHR Flight Hours RKESKWFLHR QUAN 15 3
KWFLKM Number of Kilometers Flown RKESKWFLKM QUAN 15 3
KWFLSC Flight cost of sales RKESKWFLSC CURR 15 2
KWFLSR In Flight Sales RKESKWFLSR CURR 15 2
KWFRGR Freight RKESKWFRGR CURR 15 2
KWFUEL Fuel Consumption RKESKWFUEL QUAN 15 3
KWFULK Fuel Costs RKESKWFULK CURR 15 2
KWINSR Insurance RKESKWINSR CURR 15 2
KWIREG FlightIrregularities RKESKWIREG CURR 15 2
KWLFEE Landing Fees RKESKWLFEE CURR 15 2
KWPAXR Passenger Revenue RKESKWPAXR CURR 15 2
KWPAXS Number of Passengers RKESKWPAXS QUAN 15 3
KWPXHD Passenger Handling RKESKWPXHD CURR 15 2
KWRESV Reservation Costs RKESKWRESV CURR 15 2
KWSEAT Number of Available Seats RKESKWSEAT QUAN 15 3
KWVERW Administration Costs RKESKWVERW CURR 15 2
KWAGTK Sales agent commissn RKESKWAGTK CURR 15 2
KWWTFX Fixed Maintenance Costs RKESKWWTFX CURR 15 2
KWWTVA Variable Maintenance Costs RKESKWWTVA CURR 15 2
KWCRGK Crew Salaries RKESKWCRGK CURR 15 2
KWSMKT Sales & Marketing RKESKWSMKT CURR 15 2
KWGRHD Ground Handling RKESKWGRHD CURR 15 2
KWBKPZ No. of block seats RKESKWBKPZ QUAN 15 3

CE5S_AL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CE5S_AL MANDT CE5S_AL MANDT T000 Clients MANDT
CE5S_AL PALEDGER CE5S_AL PALEDGER TKEL CO-PA ledger PALEDGER
CE5S_AL PALEDGER CE5S_AL MANDT TKEL CO-PA ledger MANDT
CE5S_AL VERSI CE5S_AL MANDT TKVS CO Versions MANDT
CE5S_AL VERSI CE5S_AL VERSI TKVS CO Versions VERSI
CE5S_AL VRGAR CE5S_AL MANDT TVGA Record types for CO-PA MANDT
CE5S_AL VRGAR CE5S_AL VRGAR TVGA Record types for CO-PA VRGAR