Flight Bookings by City Pairs

Technical name: 0FITV_C02_Q0032

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

Use

This query displays all departure and return flights for City Pair connections. The data is based on the flight bookings made with the R/3 component Travel Planning via the connected reservation system. Reporting according to City pairs can serve to answer the following questions:

  • Which routes are flown most often?
  • How much do these routes normal cost? Can special company-specific rates be negotiated based on this information?

The query displays the number of booked departure and return flights for each City Pair, as well as the basis price per ticket, the basis price for all tickets booked for this route, and the total price of all tickets. An additional drilldown according to the basis rate code enables you to evaluate City Pair bookings in further detail.

If no unique airline can be found for a City Pair departure and return flights, the value '#' is shown under unique airline for these items. This entry can be an indicator that more specific recommendations for using the same airline for departure and return flights should be included in the company's travel policy.

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.

Filters

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_P_ETYPE

Type of Travel Data (= departure and return flight)

User-Defined Characteristics

InfoObject

Description

0TV_FARRLOC_0COUNTRY

Country of flight arrival location

0TV_LOCVIA1

Connection airport 1

0TV_LOCVIA1

Connection airport 2

0TV_F_CABIN

Unique Cabin Class

0TV_F_RBDU

unique Booking Class

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_FDEPLOC_0COUNTRY

Country of departure location

0TV_FDEPLOC

Departure location

0TV_FARRLOC

Arrival Location Flight

0TV_FAIRLIU

Unique Airline

0TV_FAREBAS

Basis Rate Code

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_COUNT_R

Number of Returns

 

Basis Price per Ticket

0TV_T_FARE

Basis Price of Ticket

 

Total Price per Ticket

0TV_TOTFARE

Total price of ticket

The Basis price per ticket is calculated by dividing the Basis price of ticket by the Number of returns

The Total price per ticket is calculated by dividing the Total price of ticket by the Number of returns. In the standard SAP system the Total price per Ticket is deactivated, however this can be reactivated at anytime.