Flight Bookings by Provider

Technical name: 0FITV_C02_Q0031

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

Use

This query enables you to display the departure and return flights for each airline. The data is based on the flight bookings made with the R/3 component Travel Planning via the connected reservation system. Evaluating flights by provider allows you to answer the following questions:

  • What volume of business did an enterprise generate on which routes with which airlines?
  • Can special enterprise-specific rates be negotiated based on this information?

The query displays the number of booked departure and return flights per airline, as well as the base price per ticket, the base price for all tickets booked for this route and the total price of all tickets. An additional drilldown according to the basis code rate allows you, for example, to exclude information according to the booked prices per departure and/ or return flight.

If the departure and return flight were not booked with the same (unique) airline, then these flights are displayed under the provider Not assigned or '#'. If a large number of flights are listed under this provider, this 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_LOCVIA1

Connection Airport 1

0TV_LOCVIA1

Connection Airport 2

0TV_F_CABIN

Unique Cabin Class

0TV_F_RBDU

Unique Booking Class

0TV_FAREBAS

Basis Rate Code

0TV_FARRLOC_0COUNTRY

Country of flight arrival location

0TV_FARRLOC

Arrival Location Flight

0TV_FDEPLOC_0COUNTRY

Country of departure location

0TV_FDEPLOC

Departure location

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_FAIRLIU

Unique Airline

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

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

You can also calculate the Total price per ticket by dividing the Total price of tickets by the Number of return.