CE4S_AL_ACCT

Airline Route Profit | #transactional | Component: Profitability Analysis
Column Name Description
MANDT FK Client
AKTBO Current profitability segment (CO-PA)
PAOBJNR Profitability Segment Number (CO-PA)
PASUBNR Profitability Segment Changes (CO-PA)
Column Name Description
Column Name Description
Column Name Description
BISDAT Valid To
ACCT_BUDAT Posting Date
Column Name Description
Column Name Description Domain name
KAUFN Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
PRCTR Profit Center PRCTR
PPRCTR Partner Profit Center PRCTR
CE4KEY Assignment Object Key for CO-PA Data Basis (CE4xxxx) RKEOBJNR
ACCT_VRGNG Business Transaction J_VORGANG
Master Data Relations Join Conditions
Product
  • Product number
  • Client
  • CE4S_AL_ACCT.ARTNR == MARA.MATNR
  • CE4S_AL_ACCT.MANDT == MARA.MANDT
Order
  • Order Number
  • Client
  • CE4S_AL_ACCT.AUFNR == AUFK.AUFNR
  • CE4S_AL_ACCT.MANDT == AUFK.MANDT
Company Code
  • CE4S_AL_ACCT.MANDT == T001.MANDT
  • CE4S_AL_ACCT.BUKRS == T001.BUKRS
Billing Type
  • CE4S_AL_ACCT.MANDT == TVFK.MANDT
  • CE4S_AL_ACCT.FKART == TVFK.FKART
Business Area
  • CE4S_AL_ACCT.MANDT == TGSB.MANDT
  • CE4S_AL_ACCT.GSBER == TGSB.GSBER
Aircraft Type
  • CE4S_AL_ACCT.MANDT == T2209.MANDT
  • CE4S_AL_ACCT.KMATYP == T2209.KMATYP
Destination
  • Destination
  • Client
  • CE4S_AL_ACCT.KMDEST == T2211.KMDEST
  • CE4S_AL_ACCT.MANDT == T2211.MANDT
Flight Number
  • CE4S_AL_ACCT.MANDT == T2215.MANDT
  • CE4S_AL_ACCT.KMFLTN == T2215.KMFLTN
Flight Type
  • CE4S_AL_ACCT.MANDT == T2216.MANDT
  • CE4S_AL_ACCT.KMFLTY == T2216.KMFLTY
IATA Season
  • CE4S_AL_ACCT.MANDT == T2207.MANDT
  • CE4S_AL_ACCT.KMIATA == T2207.KMIATA
Route Segment
  • CE4S_AL_ACCT.MANDT == T2213.MANDT
  • CE4S_AL_ACCT.KMLEGS == T2213.KMLEGS
Day of Operation
  • CE4S_AL_ACCT.MANDT == T2208.MANDT
  • CE4S_AL_ACCT.KMOPDY == T2208.KMOPDY
Departure Location
  • CE4S_AL_ACCT.MANDT == T2212.MANDT
  • CE4S_AL_ACCT.KMORIG == T2212.KMORIG
Rotation
  • Rotation
  • Client
  • CE4S_AL_ACCT.KMROUT == T2210.KMROUT
  • CE4S_AL_ACCT.MANDT == T2210.MANDT
Zone
  • CE4S_AL_ACCT.MANDT == T2214.MANDT
  • CE4S_AL_ACCT.KMZONE == T2214.KMZONE
Customer
  • CE4S_AL_ACCT.MANDT == KNA1.MANDT
  • CE4S_AL_ACCT.KNDNR == KNA1.KUNNR
Controlling Area
  • CE4S_AL_ACCT.MANDT == TKA01.MANDT
  • CE4S_AL_ACCT.KOKRS == TKA01.KOKRS
Cost Object
  • Cost Object
  • Valid To
  • Client
  • CE4S_AL_ACCT.KSTRG == CKPH.KSTRG
  • CE4S_AL_ACCT.BISDAT == CKPH.DATBI
  • CE4S_AL_ACCT.MANDT == CKPH.MANDT
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWBKPZ_ME == T006.MSEHI
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWBLOK_ME == T006.MSEHI
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWFLHR_ME == T006.MSEHI
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWFLKM_ME == T006.MSEHI
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWFUEL_ME == T006.MSEHI
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWPAXS_ME == T006.MSEHI
Base Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.KWSEAT_ME == T006.MSEHI
Client CE4S_AL_ACCT.MANDT == T000.MANDT
Unit of Measure
  • CE4S_AL_ACCT.MANDT == T006.MANDT
  • CE4S_AL_ACCT.MEINH == T006.MSEHI
Division
  • CE4S_AL_ACCT.MANDT == TSPA.MANDT
  • CE4S_AL_ACCT.SPART == TSPA.SPART
Sales Organization
  • CE4S_AL_ACCT.MANDT == TVKO.MANDT
  • CE4S_AL_ACCT.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • CE4S_AL_ACCT.VTWEG == TVTW.VTWEG
  • CE4S_AL_ACCT.MANDT == TVTW.MANDT
Plant
  • CE4S_AL_ACCT.MANDT == T001W.MANDT
  • CE4S_AL_ACCT.WERKS == T001W.WERKS