Car Rental Bookings by Provider

Technical name: 0FITV_C02_Q0001

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. The number of booked vehicles, duration of rental and the price are displayed for each car rental provider. You can also include the vehicle class and type or the pick-up location and country 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:

  • What is our business volume with certain service providers? What kind of major customer rates can we negotiate based on this?
  • Which vehicles (type, class) do our travelers prefer?

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

Rental car class

0TV_C_TYPES

Rental car type

0TV_CRCODE

Car Rental Rate Code

0TV_CTOTRAT

Car Rate Indicator

0TV_CRATEPL

Rate Rule

0TV_CBEGLOC

Starting location car rental

0TV_CPICKUP

Car Rental Office

0CALQUARTER

Calendar year/quarter

0CALYEAR

Calendar year

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_CARPROV

Car rental provider

0COUNTRY as navigation attribute for 0TV_CBEGLOC

Country of starting location car rental

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0TV_COUNT

Car Rental Bookings

0TV_CARDAYS

Number of Car Rental Days

0TV_C_AMNT

Car Rental Price