The CE9S_AL_P_H table in SAP ERP or S/4HANA stores Airline Route Profitability data. There are total 67 fields in CE9S_AL_P_H table. The Airline Route Profitability table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CE9S_AL_P_H table. It is in Profitability Analysis: Generated Objects (Transportable) (KEG2) ABAP package and is part of the Profitability Analysis (CO-PA) module.
SAP CE9S_AL_P_H Table Fields
Following is the list of fields that are available in SAP CE9S_AL_P_H table. The primary key fields of Airline Route Profitability table in SAP are MANDT (Client), BELNR (Line Item Document Number), POSNR (Item number line item), SUBNR (Item subnumber of line item).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BELNR | Line Item Document Number | KEPSL_DOCNO | CHAR (10) | |
| POSNR | Item number line item | KEPSL_POSNR | CHAR (6) | |
| SUBNR | Item subnumber of line item | KEPSL_SUBNR | CHAR (6) | |
| VRGAR | Record Type | RKE_VRGAR | TVGA | CHAR (1) |
| VERSI | Plan version (CO-PA) | RKEVERSI | TKVS | CHAR (3) |
| PERIO | Period/Year | JAHRPER | NUMC (7) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| PERDE | Period | PERIODE | NUMC (3) | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC (10) | |
| USNAM | Created by | ERFASSER | CHAR (12) | |
| CPUDT | Date Document Was Created | CO_CPUDT | DATS (8) | |
| CPUTM | Created at | KEPSL_CPUTM | TIMS (6) | |
| TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| BUDAT | Posting Date | DAERF | DATS (8) | |
| WADAT | Goods Issue Date | WADAT | DATS (8) | |
| FADAT | Invoice date (date created) | FADAT | DATS (8) | |
| BWZPT | CO-PA Point of valuation | BWZPT | CHAR (1) | |
| BILLED | Indicator: billed | KEPSL_DELIV_BILLED | CHAR (1) | |
| PERIO_BILLED | Billing Period | KEPSL_PERIO_BILLED | NUMC (7) | |
| AWTYP | Reference procedure | AWTYP | CHAR (5) | |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) | |
| AWSYS | Logical system of source document | AWSYS | CHAR (10) | |
| RBELN | Reference document number for CO-PA line item | RKERFBELNR | CHAR (10) | |
| RPOSN | Item number from reference document (CO-PA) | RKERFPOSNR | CHAR (6) | |
| RSUBN | Reference Subitem number | KEPSL_REFSUBNR | CHAR (6) | |
| STO_BELNR | Canceled document | RKE_STO_BELNR | CHAR (10) | |
| STO_POSNR | Canceled document item | RKE_STO_POSNR | CHAR (6) | |
| STO_SUBNR | Canceled subnumber of line item | RKE_STO_SUBNR | CHAR (6) | |
| STO_RBELNR_I | Deleted by document | KEPSL_REV_DOCNO_INT | CHAR (10) | |
| STO_RPOSNR_I | Deleted by item | KEPSL_REV_DOCPOS_INT | CHAR (6) | |
| STO_RBELNR_E | Canceled by document | KEPSL_REV_DOCNO_EXT | CHAR (10) | |
| STO_RPOSNR_E | Canceled document item | KEPSL_REV_DOCPOS_EXT | CHAR (6) | |
| KAUFN | Sales Order Number | KDAUF | VBUK | CHAR (10) |
| KDPOS | Item number in Sales Order | KDPOS | NUMC (6) | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR (12) |
| LIEFNR | Delivery | VBELN_VL | VBUK | CHAR (10) |
| LIEFPOS | Delivery Item | POSNR_VL | NUMC (6) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR (4) |
| WERKS | Plant | WERKS_D | T001W | CHAR (4) |
| GSBER | Business Area | GSBER | TGSB | CHAR (4) |
| FKBER | Functional Area | FKBER | CHAR (16) | |
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR (10) | |
| VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR (2) |
| SPART | Division | SPART | TSPA | CHAR (2) |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR (10) |
| PPRCTR | Partner Profit Center | PPRCTR | CEPC | CHAR (10) |
| SKOST | Sender cost center | SKOST | CSKS | CHAR (10) |
| PRZNR | Sender Business Process | SEPRZ | CBPR | CHAR (12) |
| COPA_KOSTL | Cost center | COPA_KOSTL | CHAR (10) | |
| KNDNR | Customer | KUNDE_PA | KNA1 | CHAR (10) |
| ARTNR | Product number | ARTNR | MARA | CHAR (40) |
| KSTRG | Cost Object | KSTRG | CKPH | CHAR (12) |
| PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC (8) |
| FKART | Billing Type | FKART | TVFK | CHAR (4) |
| KMATYP | Aircraft Type | RKESKMATYP | T2209 | NUMC (2) |
| KMDEST | Destination | RKESKMDEST | T2211 | CHAR (5) |
| KMFLTN | Flight Number | RKESKMFLTN | T2215 | CHAR (6) |
| KMFLTY | Flight Type | RKESKMFLTY | T2216 | CHAR (4) |
| KMIATA | IATA Season | RKESKMIATA | T2207 | CHAR (5) |
| KMLEGS | Route Segment | RKESKMLEGS | T2213 | CHAR (7) |
| KMOPDY | Day of Operation | RKESKMOPDY | T2208 | CHAR (2) |
| KMORIG | Departure Location | RKESKMORIG | T2212 | CHAR (5) |
| KMROUT | Rotation | RKESKMROUT | T2210 | CHAR (5) |
| KMZONE | Zone | RKESKMZONE | T2214 | CHAR (5) |
