Travel Planning: Booking Data

Technical name: 0FI_TV_02

Technical Data

Type of DataSource	Transaction data (movement data)
Application Component	FI-TV
Available from OLTP Release	4.5B
Available from Plug-In Release	SAP R/3 Plug-In 99
RemoteCube-Compatible	No

Prerequisites

You must have generated the statistics data for Travel Management Customizing: Financials ® Financial Accounting ® Travel Management ® Define Structure of Trip Statistics.

Use

The DataSource provides all transaction data for travel plans created using SAP Travel Planning. This is the data that is transferred to the BW Business Content based on the settings in the extractor (if no filter was used in the extractor, this will include all available data).

Delta Update

None

Origin Fields in the Extract Structure

Field in Extract Structure	Description of Field in Extract Structure	Table of Origin	Field in Table of Origin
PERNR	Personnel number	PTRV_HEAD	PERNR
REINR	Trip number	PTRV_HEAD	REINR
ENTRY_TYPE	Type of trip data	*)	*)
WAERS	Currency key	PTRV_HEAD	WAERS
MOLGA	Country grouping	PTRV_HEAD	MOLGA
MOREI	Trip provision variant	PTRV_HEAD	MOREI
SCHEM	Trip schema	PTRV_HEAD	SCHEM
KZREA	Trip type - statutory	PTRV_HEAD	KZREA
BEREI	Trip type - company-specific	PTRV_HEAD	BEREI
KZTKT	Trip activity type	PTRV_HEAD	KZTKT
ZLAND	Trip country/trip country group	PTRV_HEAD	ZLAND
HRGIO	Main destination region	PTRV_HEAD	HRGIO
DATV1	Trip segment: Beginning date	PTRV_HEAD	DATV1
UHRV1	Trip segment: beginning time	PTRV_HEAD	UHRV1
DATB1	Trip segment: End date	PTRV_HEAD	DATB1
UHRB1	Trip segment: end time	PTRV_HEAD	UHRB1
PLAN_STATUS	Travel plan status	FTPT_PLAN	PLAN_STATUS
ACTIVITY_TYPE	Trip activity type	FTPT_PLAN	ACTIVITY_TYPE
REC_LOCATOR	Booking record (Passenger Name Record Locator)	FTPT_PLAN	REC_LOCATOR
USERG	User grouping for Travel Planning	FTPT_ITEM	USERG
CATEGORY	Enterprise-specific travel service category	FTPT_ITEM	CATEGORY
BELNR	Document number	FTPT_ITEM	BELNR
REAL_CAT	Travel service category	FTPT_ITEM	REAL_CAT
HOTEL_CHAIN	Hotel chain	FTPT_HOTEL	HOTEL_CHAIN
HOTEL_PROPERTY	Hotel code (key for a provider)	FTPT_HOTEL	HOTEL_PROPERTY
HOTEL_DATE_ARR	Arrival date hotel	FTPT_HOTEL	HOTEL_DATE_ARR
HOTEL_DATE_DEP	Departure date hotel	FTPT_HOTEL	HOTEL_DATE_DEP
HOTEL_LOC	Hotel location	FTPT_HOTEL	HOTEL_LOC
HOTEL_NAME	Hotel name	FTPT_HOTEL	HOTEL_NAME
HOTEL_ROOMTYPE	Hotel room type	FTPT_HOTEL	HOTEL_ROOMTYPE
HOTEL_MEALS	Hotel meals	FTPT_HOTEL	HOTEL_MEALS
HOTEL_RATE	Rate/price per night	FTPT_HOTEL	HOTEL_RATE
HOTEL_PRICE	Total price of hotel stay	FTPT_HOTEL	HOTEL_PRICE
HOTEL_STATUS	Hotel status	FTPT_HOTEL	HOTEL_STATUS
HOTEL_RATE_CODE	Hotel rate category	FTPT_HOTEL	HOTEL_RATE_CODE
ROOM_RATE_CODE	Room rate code (hotel-specific)	FTPT_HOTEL	ROOM_RATE_CODE
HOTEL_AREA	Hotel location area	FTPT_HOTEL	HOTEL_AREA
HOTEL_NIGHTS	Number of hotel nights	*)	*)
HOTEL_BOOKINGS	Number of hotel bookings	*)	*)
HOTEL_CORP_ID	Company ID for room reservation	FTPT_HOTEL	HOTEL_CORP_ID
CAR_PROVIDER	Rental car provider	FTPT_CAR	CAR_PROVIDER
CAR_DATE_BEG	Beginning date for car rental	FTPT_CAR	CAR_DATE_BEG
CAR_LOC_BEG	Starting location for car rental	FTPT_CAR	CAR_LOC_BEG
CAR_DATE_END	End date for car rental	FTPT_CAR	CAR_DATE_END
CAR_LOC_END	Dropoff location for car rental	FTPT_CAR	CAR_LOC_END
CAR_CLASS	Rental car class	FTPT_CAR	CAR_CLASS
CAR_TYPE	Rental car type	FTPT_CAR	CAR_TYPE
CAR_PRICE	Car rental price by day, by week, etc.	FTPT_CAR	CAR_PRICE
CAR_RATE_CODE	Car rental rule key (provider-dependent)	FTPT_CAR	CAR_RATE_CODE
CAR_TOT_RATETYPE	Car rental rate indicator (total amount)	FTPT_CAR	CAR_TOT_RATETYPE
CAR_TOTAL_RATE	Total price for car rental	FTPT_CAR	CAR_TOTAL_RATE
CAR_STATUS	Car rental status	FTPT_CAR	CAR_STATUS
CAR_AREA	City of car rental office (location)	FTPT_CAR	CAR_AREA
CAR_DAYS	Number of car rental days	*)	*)
CAR_BOOKINGS	Number of car rental bookings	*)	*)
CAR_PICKUP_LOC	Car rental branch office for pickup	FTPT_CAR	CAR_PICKUP_LOC
CAR_CORPORATE_ID	Company ID for negotiated rates	FTPT_CAR	CAR_CORPORATE_ID
AIRLINE	Airline	FTPT_FLIGHT	AIRLINE
FLIGHT_NR	Flight number	FTPT_FLIGHT	FLIGHT_NR
FLIGHT_DATE_DEP	Flight departure date	FTPT_FLIGHT	FLIGHT_DATE_DEP
FLIGHT_TIME_DEP	Flight departure time	FTPT_FLIGHT	FLIGHT_TIME_DEP
FLIGHT_LOC_DEP	Departure location	FTPT_FLIGHT	FLIGHT_LOC_DEP
FLIGHT_LOC_ARR	Flight arrival location	FTPT_FLIGHT	FLIGHT_LOC_ARR
RESTRICT_FARE	Lowest fare search	FTPT_FLIGHT	RESTRICT_FARE
FLIGHT_CABIN	Flight cabin class	FTPT_FLIGHT	FLIGHT_CABIN
FLIGHT_RBD	Flight booking class (RBD)	FTPT_FLIGHT	FLIGHT_RBD
FLIGHT_STATUS	Flight status	FTPT_FLIGHT	FLIGHT_STATUS
FLIGHT_NUMBER	Number of flights	FTPT_FLIGHT	FLIGHT_NUMBER
FARE_BASIS_CODE	Basis code of rate component	FTPT_FLIGHT	FARE_BASIS_CODE
OP_AIRLINE	Airline	FTPT_FLIGHT	OP_AIRLINE
LOCAL_TST	Ticket element is local (not in booking system)	FTPT_FLIGHT_TSTK	LOCAL_TST
LAST_DATE	Flight ticket last changed	FTPT_FLIGHT_TSTK	LAST_DATE
TICKET_MODE	Ticketing mode of flight ticket	FTPT_FLIGHT_TSTK	TICKET_MODE
SALES_IND	Sales type of flight ticket rate	FTPT_FLIGHT_TSTK	SALES_IND
FARE	Basic rate for flight ticket without tax	FTPT_FLIGHT_TSTK	FARE
TOTAL_FARE	Total price of flight ticket	FTPT_FLIGHT_TSTK	TOTAL_FARE
PLATING_CARRIER	Plating carrier	FTPT_FLIGHT_TSTK	PLATING_CARRIER
TST_ISSUE_TYPE	Airline ticket issue	FTPT_FLIGHT_TSTK	TST_ISSUE_TYPE
REBATE_FARE	Rebated price of flight ticket	FTPT_FLIGHT_TSTK	REBATE_FARE
TICKETNUMBER	Ticket number	FTPT_FLIGHT_TSTK	TICKETNUMBER
TICKETTYPE	Ticket type	FTPT_FLIGHT_TSTK	TICKETTYPE
TST_FARE_TYPE	Type of fare (normal, negotiated, etc.)	FTPT_FLIGHT_TSTK	TST_FARE_TYPE
AIRLINE1	Airline	*)	*)
AIRLINE2	Airline	*)	*)
AIRLINE3	Airline	*)	*)
AIRLINE4	Airline	*)	*)
AIRLINE_UNIQUE	Airline	*)	*)
FLIGHT_CABIN1	Flight cabin class	*)	*)
FLIGHT_CABIN2	Flight cabin class	*)	*)
FLIGHT_CABIN3	Flight cabin class	*)	*)
FLIGHT_CABIN4	Flight cabin class	*)	*)
FLIGHT_CABIN_UNI	Flight cabin class	*)	*)
FLIGHT_RBD1	Flight booking class (RBD)	*)	*)
FLIGHT_RBD2	Flight booking class (RBD)	*)	*)
FLIGHT_RBD3	Flight booking class (RBD)	*)	*)
FLIGHT_RBD4	Flight booking class (RBD)	*)	*)
FLIGHT_RBD_UNI	Flight booking class (RBD)	*)	*)
FLIGHT_LOC_VIA1	Airport of connecting flight in round trip	*)	*)
FLIGHT_LOC_VIA2	Airport of connecting flight in round trip	*)	*)
FLIGHT_RETURNS	Number of returns	*)	*)

*) If the fields table and field name in table are not filled, the field does not come directly from a database table but is determined in the extractor.

HR Reporting in BW