Car Rental Bookings by Geographical Hierarchy

Technical name: 0FITV_C02_Q0011

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

Use

This query shows you all the car rental bookings, made with the R/3 component Travel Planning via the connected reservation system, listed according to a geographical hierarchy of IATA locations. The hierarchy groupings are based on the regions that you have defined in Customizing for R/3 Travel Management.

The number of car rental bookings, duration of the bookings and the total price are displayed per departure/ pick-up location (for example worldwide, continent, country, region, town or IATA location). You can evaluate the results in further detail by using additional drilldowns, for example provider, vehicle class or rate category.

The number of booked vehicles, duration of rental and the price are displayed for each rental car provider. You can also include the vehicle class and type, and the provider in your evaluation.

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:

  • For which regions/ locations were the most car rental bookings made?
  • Which regions/ locations have the highest hotel prices? (You can support this analysis by defining an average value for Price per rental day).
  • By using the additional drilldown for the car rental providers: What kind of major customer rates can we negotiate based on this information?

Filters

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_P_ETYPE

Type of Travel Data (=Rental Car)

User-Defined Characteristics

InfoObject

Description

0TV_C_CLASS

Vehicle Class

0TV_CARPROV

Car Rental Provider

0TV_C_TYPES

Vehicle Type

0TV_CRCODE

Car Rental Rate Code

0TV_CTOTRAT

Car Rate Indicator

0TV_CRATEPL

Rate Rule

0TV_CPICKUP

Car Rental Office

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_CBEGLOC

Starting location car rental

The presentation hierarchy IATAL (geographical hierarchy of IATA locations) is linked to the car rental pick up location. When you drilldown according to departure/pick-up location, a hierarchical listing of the hotel locations, based upon the regions defined in Customizing for Travel Management, is displayed.

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_COUNT_C

Car Rental Bookings

0TV_CARDAYS

Number of Car Rental Days

0TV_C_AMNT

Car Rental Price