Individual Flights

Technical name: 0FITV_C02_Q003

Based on InfoCube 0FITV_C02 (Travel Planning: Booking Data)

Use

This query displays the flights booked for each airline according to cabin class. This query is for individual flights and not for City Pairs (see Query: Flight Bookings by City Pairs) The data is based on the flight bookings made with the R/3 component Travel Planning via the connected reservation system.

You can also restrict reporting to a specific time frame:

  • Display by quarter
  • Display by calendar year

If you select a filter value, only the data for the quarter or calendar year entered is displayed. To view the values of several quarters or years next to one another for comparison, use the appropriate time characteristic to expand the evaluation.

You can use this query, for example, to answer the following questions:

  • Which airlines do our travelers prefer to use?
  • Which cabin classes are booked most often?
  • Our travelers fly which flight legs the most frequently?
  • Can special major customer rates be negotiated based on this information?

Filters

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_P_ETYPE

Type of Travel Data (=Individual Flight)

User-Defined Characteristics

InfoObject

Description

0TV_FDEPLOC

Departure location

0COUNTRY as navigation attribute for 0TV_FDEPLOC

Country of departure location

0TV_FARRLOC

Flight arrival location

0COUNTRY as navigation attribute for 0TV_FARRLOC

Country of flight arrival location

0TV_F_RBD

Flight Booking Class

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_FAIRLIN

Airline (code)

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_COUNT

Number of bookings

0TV_F_CABIN

Flight cabin class