Hotel Bookings by Geographical Hierarchy

Technical name: 0FITV_C02_Q0021

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

Use

This query display all hotel bookings, listed according to a geographical hierarchy of IATA locations. The hierarchy groupings are based on the regions that you have defined in Customizing for the R/3 component Travel Management.

The data is based on the hotel bookings made with the R/3 component Travel Planning via the connected reservation system. The number of booked hotel rooms, nights and the total price are displayed per hotel location (for example worldwide, continent, country, town or IATA location). You can evaluate the results in further detail by using additional drilldowns, for example hotel chain, room type or rate category.

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 hotel bookings made?
  • Which regions/ locations have the highest hotel prices? (You can support this analysis by defining an average value for Price per hotel night).
  • By using the additional drilldown for hotel chains: 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 (=Hotel Booking)

User-Defined Characteristics

InfoObject

Description

0TV_HOTPROV

Hotel Chain

0TV_HOTNAME

Hotel Name

0TV_HROOMTP

Room Type

0TV_HRATECD

Hotel Rate Category

0TV_HROOMTP

Hotel Rate Code

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_HOTLLOC

Hotel location

The presentation hierarchy IATAL (geographical hierarchy of IATA locations) is linked to the hotel location When you drilldown according to hotel location, a hierarchical listing of 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_H

Number of Hotel Bookings

0TV_ROOMNGT

Number of Hotel Nights

0TV_H_PRICE

Total price of hotel