Travel Planning: Booking Data (SAP Library

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.