CE9S_AL_KENC

Airline Route Profit | #transactional | Component: Profitability Analysis
Column Name Description
MANDT Client
CHGRUN Realignment run
BELNR Line Item Document Number
POSNR Item number line item
SUBNR Item subnumber of line item
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
FKBER Functional Area FKBER
SEGMENT Segment for Segmental Reporting FB_SEGMENT
COPA_KOSTL Cost center KOSTL
KDPOS Item number in Sales Order NUM06
LIEFPOS Delivery Item POSNR
Master Data Relations Join Conditions
Product
  • Product number
  • Client
  • CE9S_AL_KENC.ARTNR == MARA.MATNR
  • CE9S_AL_KENC.MANDT == MARA.MANDT
Order
  • Order Number
  • Client
  • CE9S_AL_KENC.AUFNR == AUFK.AUFNR
  • CE9S_AL_KENC.MANDT == AUFK.MANDT
Company code
  • CE9S_AL_KENC.MANDT == T001.MANDT
  • CE9S_AL_KENC.BUKRS == T001.BUKRS
Billing Type
  • CE9S_AL_KENC.MANDT == TVFK.MANDT
  • CE9S_AL_KENC.FKART == TVFK.FKART
Business Area
  • CE9S_AL_KENC.MANDT == TGSB.MANDT
  • CE9S_AL_KENC.GSBER == TGSB.GSBER
Aircraft Type
  • CE9S_AL_KENC.MANDT == T2209.MANDT
  • CE9S_AL_KENC.KMATYP == T2209.KMATYP
Destination
  • Destination
  • Client
  • CE9S_AL_KENC.KMDEST == T2211.KMDEST
  • CE9S_AL_KENC.MANDT == T2211.MANDT
Flight Number
  • CE9S_AL_KENC.MANDT == T2215.MANDT
  • CE9S_AL_KENC.KMFLTN == T2215.KMFLTN
Flight Type
  • CE9S_AL_KENC.MANDT == T2216.MANDT
  • CE9S_AL_KENC.KMFLTY == T2216.KMFLTY
IATA Season
  • CE9S_AL_KENC.MANDT == T2207.MANDT
  • CE9S_AL_KENC.KMIATA == T2207.KMIATA
Route Segment
  • CE9S_AL_KENC.MANDT == T2213.MANDT
  • CE9S_AL_KENC.KMLEGS == T2213.KMLEGS
Day of Operation
  • CE9S_AL_KENC.MANDT == T2208.MANDT
  • CE9S_AL_KENC.KMOPDY == T2208.KMOPDY
Departure Location
  • CE9S_AL_KENC.MANDT == T2212.MANDT
  • CE9S_AL_KENC.KMORIG == T2212.KMORIG
Rotation
  • Rotation
  • Client
  • CE9S_AL_KENC.KMROUT == T2210.KMROUT
  • CE9S_AL_KENC.MANDT == T2210.MANDT
Zone
  • CE9S_AL_KENC.MANDT == T2214.MANDT
  • CE9S_AL_KENC.KMZONE == T2214.KMZONE
Customer
  • CE9S_AL_KENC.MANDT == KNA1.MANDT
  • CE9S_AL_KENC.KNDNR == KNA1.KUNNR
Controlling Area
  • CE9S_AL_KENC.MANDT == TKA01.MANDT
  • CE9S_AL_KENC.KOKRS == TKA01.KOKRS
Cost Object
  • Cost Object
  • ?
  • Client
  • CE9S_AL_KENC.KSTRG == CKPH.KSTRG
  • CE9S_AL_KENC.[column in domain "DATBI"] == CKPH.DATBI
  • CE9S_AL_KENC.MANDT == CKPH.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • CE9S_AL_KENC.MANDT == CEPC.MANDT
  • CE9S_AL_KENC.[column in domain "DATBI"] == CEPC.DATBI
  • CE9S_AL_KENC.KOKRS == CEPC.KOKRS
  • CE9S_AL_KENC.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • CE9S_AL_KENC.MANDT == CEPC.MANDT
  • CE9S_AL_KENC.[column in domain "DATBI"] == CEPC.DATBI
  • CE9S_AL_KENC.KOKRS == CEPC.KOKRS
  • CE9S_AL_KENC.PRCTR == CEPC.PRCTR
Sender Business Process
  • Controlling Area
  • Sender Business Process
  • Client
  • ?
  • CE9S_AL_KENC.KOKRS == CBPR.KOKRS
  • CE9S_AL_KENC.PRZNR == CBPR.PRZNR
  • CE9S_AL_KENC.MANDT == CBPR.MANDT
  • CE9S_AL_KENC.[column in domain "DATBI"] == CBPR.DATBI
Sender Cost Center
  • ?
  • Sender cost center
  • Controlling Area
  • CE9S_AL_KENC.MANDT == CSKS.MANDT
  • CE9S_AL_KENC.[column in domain "DATBI"] == CSKS.DATBI
  • CE9S_AL_KENC.SKOST == CSKS.KOSTL
  • CE9S_AL_KENC.KOKRS == CSKS.KOKRS
Division
  • CE9S_AL_KENC.MANDT == TSPA.MANDT
  • CE9S_AL_KENC.SPART == TSPA.SPART
Sales Organization
  • CE9S_AL_KENC.MANDT == TVKO.MANDT
  • CE9S_AL_KENC.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • CE9S_AL_KENC.VTWEG == TVTW.VTWEG
  • CE9S_AL_KENC.MANDT == TVTW.MANDT
Plant
  • CE9S_AL_KENC.MANDT == T001W.MANDT
  • CE9S_AL_KENC.WERKS == T001W.WERKS