CE1S_AL SAP table for – Airline Route Profit

Here we would like to draw your attention to CE1S_AL table in SAP. As we know it is being mainly used with the SAP CO-PA (Profitability Analysis in CO) component which is coming under CO module (Controlling). CE1S_AL is a SAP standard transparent table used for storing Airline Route Profit related data in SAP. It comes under the package KEG2.

SAP CE1S_AL table

Table CE1S_AL technical data

TableCE1S_AL
Data storingAirline Route Profit
ModuleCO
ComponentCO-PA
SAP PackageKEG2
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CE1S_AL Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in CE1S_AL table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • HZDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KWCRGK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWSMKT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWGRHD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWBKPZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • USNAM : User name
    Its data type is C (Character String) with field length 12
  • GJAHR : Fiscal Year
    Its data type is N (Character String with Digits Only) with field length 4
  • PERDE
    Its data type is N (Character String with Digits Only) with field length 3
  • WADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ALTPERIO
    Its data type is N (Character String with Digits Only) with field length 7
  • PAPAOBJNR
    Its data type is N (Character String with Digits Only) with field length 10
  • PAPASUBNR
    Its data type is N (Character String with Digits Only) with field length 4
  • PALEDGER
    Its a key field. Its data type is C (Character String) with field length 2
  • KNDNR
    Its data type is C (Character String) with field length 10
  • ARTNR
    Its data type is C (Character String) with field length 18
  • FKART : Billing Type
    Its data type is C (Character String) with field length 4
  • FRWAE
    Its data type is C (Character String) with field length 5
  • KURSF : Exchange rate
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • KURSBK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • KURSKZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • REC_WAERS
    Its data type is C (Character String) with field length 5
  • KAUFN
    Its data type is C (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • VRGAR
    Its a key field. Its data type is C (Character String) with field length 1
  • RKAUFNR
    Its data type is C (Character String) with field length 12
  • SKOST : Cost Center
    Its data type is C (Character String) with field length 10
  • PRZNR : Business Process
    Its data type is C (Character String) with field length 12
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • VERSI
    Its a key field. Its data type is C (Character String) with field length 3
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is C (Character String) with field length 4
  • PLIKZ
    Its data type is C (Character String) with field length 1
  • KSTAR : Cost Element
    Its data type is C (Character String) with field length 10
  • PSPNR : Standard WBS element
    Its data type is N (Character String with Digits Only) with field length 8
  • KSTRG : Cost Object
    Its data type is C (Character String) with field length 12
  • RBELN
    Its data type is C (Character String) with field length 10
  • RPOSN
    Its data type is C (Character String) with field length 6
  • STO_BELNR
    Its data type is C (Character String) with field length 10
  • STO_POSNR
    Its data type is C (Character String) with field length 6
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • PERIO
    Its a key field. Its data type is N (Character String with Digits Only) with field length 7
  • PPRCTR : Partner Profit Center
    Its data type is C (Character String) with field length 10
  • RKESTATU
    Its data type is C (Character String) with field length 10
  • TIMESTMP : Time Added (Greenwich Meantime)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 9
  • COPA_AWTYP
    Its data type is C (Character String) with field length 5
  • COPA_AWORG
    Its data type is C (Character String) with field length 10
  • COPA_BWZPT
    Its data type is C (Character String) with field length 1
  • COPA_AWSYS
    Its data type is C (Character String) with field length 10
  • KMATYP
    Its data type is N (Character String with Digits Only) with field length 2
  • KMDEST
    Its data type is C (Character String) with field length 5
  • KMFLTN
    Its data type is C (Character String) with field length 6
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • KMFLTY
    Its data type is C (Character String) with field length 4
  • KMIATA
    Its data type is C (Character String) with field length 5
  • KMLEGS
    Its data type is C (Character String) with field length 7
  • KMOPDY
    Its data type is C (Character String) with field length 2
  • KMORIG
    Its data type is C (Character String) with field length 5
  • KMROUT
    Its data type is C (Character String) with field length 5
  • KMZONE
    Its data type is C (Character String) with field length 5
  • KWBLOK_ME
    Its data type is C (Character String) with field length 3
  • KWFLHR_ME
    Its data type is C (Character String) with field length 3
  • KWFLKM_ME
    Its data type is C (Character String) with field length 3
  • PASUBNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • KWFUEL_ME
    Its data type is C (Character String) with field length 3
  • KWPAXS_ME
    Its data type is C (Character String) with field length 3
  • KWSEAT_ME
    Its data type is C (Character String) with field length 3
  • KWBKPZ_ME
    Its data type is C (Character String) with field length 3
  • KWBLKS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWBLOK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWCATR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWCRWK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWDEPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWEURO
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BELNR : Accounting Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • KWEXLR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFLHR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFLKM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFLSC
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFLSR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFRGR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFUEL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWFULK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWINSR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWIREG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • POSNR : Item number of the SD document
    Its a key field. Its data type is C (Character String) with field length 6
  • KWLFEE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWPAXR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWPAXS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWPXHD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWRESV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWSEAT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWVERW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWAGTK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWWTFX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KWWTVA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8