Travel Planning: Booking Data

Technical name: 0FITV_C02

Use

The InfoCube Travel Planning: Booking Data contains all the transaction data transferred from the source system (OLAP system) to the BW system for travel plans created using the R/3 component Travel Planning.

You can use the Calendar Day, Calendar Year/Month, Calendar Year/Quarter, and Calendar Year as time dimensions in your evaluations. You can evaluate these key figures according to various attributes:

  • Personal data of the traveler (such as nationality, gender, and language)
  • Organizational data (such as personnel area, employee group, and organizational unit)
  • General trip data (such as trip country, trip type, trip provision variant)
  • Travel service provider (such as hotel code, car rental company, flight cabin class)

The update rules specify how the time characteristics are to be determined for the key figures. All indicators with the trip end date are to be updated.

InfoSources

Data is transferred to this InfoCube from the following InfoSources:

0FI_TV_02: Travel Planning: Booking Data

Characteristics

InfoObject

Description

0TV_FDEPLOC

Departure location

0TV_CENDLOC

Dropoff location for car rental

0TV_HDEPDAT

Departure date hotel

0TV_CBEGDAT

Beginning date for car rental

0TV_FREQDEP

Starting location of flight request

0TV_CBEGLOC

Starting location for car rental

0TV_FARRLOC

Flight arrival location

0TV_HARRDAT

Arrival date hotel

0TV_RECEIPT

Receipt number

0TV_P_USERG

User grouping for Travel Planning

0TV_F_RBD

Flight booking class (RBD)

0TV_PNR

Booking record (Passenger Name Record Locator)

0TV_FDEPDAT

Flight departure date

0TV_CENDDAT

End date for car rental

0TV_FREQARR

End location of flight request

0TV_C_CLASS

Rental car class

0TV_C_TYPES

Rental car type

0TV_FAIRLIN

Airline

0TV_FLIGHT

Flight number

0TV_FRESFAR

Airfare (restricted)

0TV_HMEALS

Hotel meals

0TV_HROOMTP

Hotel room type

0TV_H_STAT

Hotel status

0TV_HOTCODE

Hotel code (key for a provider)

0TV_HOTPROV

Hotel chain

0TV_HOTLLOC

Hotel location

0TV_F_CABIN

Flight cabin class

0COUNTRY_ID

Country grouping

0TV_CTOTRAT

Car rental rate indicator (total amount)

0TV_CRATEPL

Car rental rate rule (by day/week/month/etc.)

0TV_CARPROV

Car rental provider

0TV_HOTNAME

Hotel name

0TV_P_ITREF

Reference to another request (return flight)

0TV_REGION

Main destination region

0TV_DEPDATE

Trip segment: Beginning date

0TV_ARRDATE

Trip segment: End date

0TV_P_ITEM

Travel request item number (sequential number)

0TV_TT_STAT

Trip type - statutory

0TV_TT_COMP

Trip type - company-specific

0TV_P_CATEG

Travel service category

0TV_COUNTRY

Trip country/trip country group

0TV_TRIP

Trip number

0TV_VARIANT

Trip provision variant

0TV_SCHEMA

Trip schema

0TV_ACTYPE

Trip activity type

0TV_PACTYPE

Trip activity type - Travel Planning

0TV_P_ETYPE

Record type trip data

0TV_CRCODE

Car rental rule key (provider-dependent)

0TV_C_STAT

Car rental status

0TV_PL_STAT

Travel plan status

0TV_F_STAT

Flight status

0TV_TST_LOC

Ticket element is local (not in booking system)

0TV_TSTMODE

Ticketing mode of flight ticket

0TV_FDEPTIM

Flight departure time

0TV_P_UCAT

Enterprise-specific travel service category

0TV_TSALESI

Sales type of flight ticket rate

0TV_T_DATE

Flight ticket last changed

Time Characteristics

InfoObject

Description

0CALDAY

Calendar day

0CALMONTH

Calendar year/month

0CALQUARTER

Calendar Year/Quarter

0CALYEAR

Calendar year

Key Figures

InfoObject

Description

0TV_COUNT

Number of bookings

0TV_T_FARE

Basic rate for flight ticket without tax

0TV_TOTFARE

Total price of flight ticket

0TV_C_AMNT

Total price for car rental

0TV_H_PRICE

Total price of hotel

0TV_C_PRICE

Car rental price by day/week/etc.

0TV_H_RATE

Rate/price per night

Units

InfoObject

Description

0CURRENCY

Currency Key

All amounts are translated into the trip currency on the respective end date of the trips in the relevant source system(s) (OLTP system). The trip currency depends on the trip provision variant in which the trip was created.

For queries in which trips from different trip provision variants are evaluated, the amounts are translated to one currency in the query in the BW system (OLAP system). This currency is taken from the settings made in BW Customizing.