Travel Planning: Booking Data
Travel Planning: Booking Data
Technical name: 0FI_TV_02
Use
The InfoSource delivers all the travel plan transaction data created using the R/3 component Travel Planning. This is the data that has been transferred to the BW Business Content according to the settings in the extractor (this means, if no filter was used in the extractor this will be all the available data).
Characteristics
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
0TV_FDEPLOC |
Departure location |
FLIGHT_SLOC_DEP |
FLIGHT_LOC_DEP |
0TV_CENDLOC |
Dropoff location for car rental |
CAR_LOC_END |
CAR_LOC_END |
0TV_FPL_AIR |
Ticketing airline |
PLATING_CARRIER |
PLATING_CARRIER |
0TV_HDEPDAT |
Departure date hotel |
HOTEL_DATE_DEP |
HOTEL_DATE_DEP |
0TV_CBEGDAT |
Beginning date for car rental |
CAR_DATE_BEG |
CAR_DATE_BEG |
0TV_CBEGLOC |
Starting location for car rental |
CAR_LOC_BEG |
CAR_LOC_BEG |
0TV_FARRLOC |
Flight arrival location |
FLIGHT_SLOC_ARR |
FLIGHT_LOC_ARR |
0TV_HARRDAT |
Arrival date hotel |
HOTEL_DATE_ARR |
HOTEL_DATE_ARR |
0TV_FOP_AIR |
Operating airline |
FLIGHT_AIRLINE |
OP_AIRLINE |
0TV_FAREBAS |
Basis code of rate component |
FARE_BASIS_CODE |
FARE_BASIS_CODE |
0TV_RECEIPT |
Receipt number |
NRBEL |
BELNR |
0TV_P_USERG |
User grouping for Travel Planning |
EMPLOYEE_GROUP_TP |
USERG |
0TV_F_RBD1 |
Booking class of 1st flight (RBD) |
FLIGHT_RBD |
FLIGHT_RBD1 |
0TV_F_RBD2 |
Booking class of 2nd flight (RBD) |
FLIGHT_RBD |
FLIGHT_RBD2 |
0TV_F_RBD3 |
Booking class of 3rd flight (RBD) |
FLIGHT_RBD |
FLIGHT_RBD3 |
0TV_F_RBD4 |
Booking class of 4th flight (RBD) |
FLIGHT_RBD |
FLIGHT_RBD4 |
0TV_F_RBD |
Booking class of a flight (RBD) |
FLIGHT_RBD |
FLIGHT_RBD |
0TV_PNR |
Booking record (Passenger Name Record Locator) |
PNR_RECORD_LOCATOR |
REC_LOCATOR |
0TV_FDEPDAT |
Flight departure date |
FLIGHT_DATE_DEP |
FLIGHT_DATE_DEP |
0TV_F_RBDU |
Unique booking class round trip (RBD) |
FLIGHT_RBD |
FLIGHT_RBD_UNIQUE |
0TV_FAIRLIU |
Unique airline round trip |
FLIGHT_AIRLINE |
AIRLINE_UNIQUE |
0TV_F_CABIU |
Unique flight cabin class round trip |
FLIGHT_CABIN |
FLIGHT_CABIN_UNIQUE |
0TV_CENDDAT |
End date for car rental |
CAR_DATE_END |
CAR_DATE_END |
0TV_C_CLASS |
Rental car class |
CAR_CLASS |
CAR_CLASS |
0TV_C_TYPES |
Rental car type |
CAR_TYPE |
CAR_TYPE |
0TV_HCORPID |
Company identification for hotel booking |
HOTEL_CORPORATE_ID |
HOTEL_CORPORATE_ID |
0TV_CCORPID |
Company identification for car rental booking |
CAR_CORPORATE_ID |
CAR_CORPORATE_ID |
0TV_FAIRLIN |
Airline |
FLIGHT_AIRLINE |
AIRLINE |
0TV_FAIRLI1 |
Airline 1st flight |
FLIGHT_AIRLINE |
AIRLINE1 |
0TV_FAIRLI2 |
Airline 2nd flight |
FLIGHT_AIRLINE |
AIRLINE2 |
0TV_FAIRLI3 |
Airline 3rd flight |
FLIGHT_AIRLINE |
AIRLINE3 |
0TV_FAIRLI4 |
Airline 4th flight |
FLIGHT_AIRLINE |
AIRLINE4 |
0TV_FLIGHT |
Flight number |
FLIGHT_NR |
FLIGHT_NR |
0TV_FRESFAR |
Airfare (restricted) |
FFARE_TYPES |
RESTRICT_FARE |
0TV_HMEALS |
Hotel meals |
HOTEL_MEALS |
HOTEL_MEALS |
0TV_HROOMTP |
Hotel room type |
HOTEL_ROOMTYPE |
HOTEL_ROOMTYPE |
0TV_H_STAT |
Hotel status |
HOTEL_STATUS |
HOTEL_STATUS |
0TV_HRATECD |
Hotel rate category |
HOTEL_RATE_PLAN_CODE |
HOTEL_RATE_CODE |
0TV_HOTCODE |
Hotel code (key for a provider) |
HOTEL_PROPERTY |
HOTEL_PROPERTY |
0TV_HOTPROV |
Hotel chain |
HOTEL_PROVIDER |
HOTEL_CHAIN |
0TV_HOTAREA |
Hotel location area |
HOTEL_AREA_LOC |
HOTEL_AREA |
0TV_HOTLLOC |
Hotel location |
HOTEL_SLOCATION |
HOTEL_LOC |
0TV_HROOMRC |
Hotel-specific rate code |
HOTEL_ROOM_RATE_CODE |
ROOM_RATE_CODE |
0TV_F_CABI1 |
Cabin class of 1st flight |
FLIGHT_CABIN |
FLIGHT_CABIN1 |
0TV_F_CABI2 |
Cabin class of 2nd flight |
FLIGHT_CABIN |
FLIGHT_CABIN2 |
0TV_F_CABI3 |
Cabin class of 3rd flight |
FLIGHT_CABIN |
FLIGHT_CABIN3 |
0TV_F_CABI4 |
Cabin class of 4th flight |
FLIGHT_CABIN |
FLIGHT_CABIN4 |
0TV_F_CABIN |
Cabin class of a flight |
FLIGHT_CABIN |
FLIGHT_CABIN |
0TV_CARAREA |
Car rental branch office area |
CAR_AREA |
CAR_AREA |
0COUNTRY_ID |
Country grouping |
MOLGA |
MOLGA |
0TV_CTOTRAT |
Car rental rate indicator (total amount) |
CAR_TOTAL_RATE_TYPE |
CAR_TOT_RATETYPE |
0TV_CARPROV |
Car rental provider |
CAR_PROVIDER |
CAR_PROVIDER |
0TV_CPICKUP |
Car rental branch office for pickup |
CAR_PICKUP_LOC |
CAR_PICKUP_LOC |
0EMPLOYEE |
Employees |
PERNR_D |
PERNR |
0TV_HOTNAME |
Name of hotel |
HOTEL_NAME |
HOTEL_NAME |
0TV_REGION |
Main destination region |
HRGIO |
HRGIO |
0TV_DEPDATE |
Trip segment: beginning date |
REBED |
DATV1 |
0TV_DEPTIME |
Trip segment: beginning time |
REBEU |
UHRV1 |
0TV_ARRDATE |
Trip segment: end date |
REEND |
DATB1 |
0TV_ARRTIME |
Trip segment: end time |
REENU |
UHRB1 |
0TV_TT_STAT |
Trip type - statutory |
KZREA |
KZREA |
0TV_TT_COMP |
Trip type - enterprise-specific |
BEREI |
BEREI |
0TV_P_CATEG |
Travel service category |
CATEGORY |
REAL_CAT |
0TV_COUNTRY |
Trip country/trip country group |
LNDGR |
ZLAND |
0TV_TRIP |
Trip number |
REINR |
REINR |
0TV_VARIANT |
Trip provision variant |
MOREI |
MOREI |
0TV_SCHEMA |
Trip schema |
RSCHE |
SCHEM |
0TV_ACTYPE |
Trip activity type |
KZTKT |
KZTKT |
0TV_PACTYPE |
Trip activity type - Travel Planning |
PLAN_ACTIVITY |
ACTIVITY_TYPE |
0TV_P_ETYPE |
Record type trip data |
PTRV_BW_ENTRY_TYPE |
ENTRY_TYPE |
0TV_CRCODE |
Key for car rental rate (provider-dependent) |
CAR_RATECODE |
CAR_RATE_CODE |
0TV_C_STAT |
Car rental status |
CAR_STATUS |
CAR_STATUS |
0TV_PL_STAT |
Travel pan status |
PLAN_STATUS |
PLAN_STATUS |
0TV_F_STAT |
Flight status |
FLIGHT_STATUS |
FLIGHT_STATUS |
0TV_FARETYP |
Rate type flight ticket |
TST_FARE_TYPE |
TST_FARE_TYPE |
0TV_TST_LOC |
Ticket element is local (not in booking system) |
LOCAL_TST |
LOCAL_TST |
0TV_TSTMODE |
Ticketing mode of flight ticket |
TST_TICKET_MODE |
TICKET_MODE |
0TV_TICKET |
Ticket number |
TICKET_NUMBER |
TICKETNUMBER |
0TV_FDEPTIM |
Flight departure time |
FLIGHT_TIME_DEP |
FLIGHT_TIME_DEP |
0TV_LOCVIA1 |
Connecting airport for flight to destination |
PTRV_BW_SLOC_VIA |
FLIGHT_LOC_VIA1 |
0TV_LOCVIA2 |
Connecting airport for return flight |
PTRV_BW_SLOC_VIA |
FLIGHT_LOC_VIA2 |
0TV_P_UCAT |
Enterprise-specific travel service category |
ITEMPOS_USER_CAT |
CATEGORY |
0TV_TSALESI |
Sales type of flight ticket rate |
TST_SALES_IND |
SALES_IND |
0TV_T_DATE |
Flight ticket last changed |
TST_LAST_DATE |
LAST_DATE |
Units
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
0CURRENCY |
Currency |
WAERS |
WAERS |
In the appropriate source system (OLTP system) all amounts are translated into the trip currency on the respective end date of the trips. The trip currency depends on the trip provision variant for which the trip has been 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.
Key Figures
InfoObject |
Description |
Data Element |
Field in Transfer Structure |
0TV_COUNT_F |
Number of flights |
PTRV_BW_FLIGHT_NUMBER |
FLIGHT_NUMBER |
0TV_COUNT_R |
Number of returns |
PTRV_BW_FLIGHT_RETURNS |
FLIGHT_RETURNS |
0TV_COUNT_H |
Number of hotel bookings |
PTRV_BW_HOTEL_BOOKINGS |
HOTEL_BOOKINGS |
0TV_ROOMNGT |
Number of room nights |
PTRV_BW_HOTEL_NIGHTS |
HOTEL_NIGHTS |
0TV_COUNT_C |
Number of car rental bookings |
PTRV_BW_CAR_BOOKINGS |
CAR_BOOKINGS |
0TV_CARDAYS |
Number of car rental days |
PTRV_BW_CAR_DAYS |
CAR_DAYS |
0TV_T_FARE |
Basic rate for flight ticket without tax |
TST_FARE |
FARE |
0TV_TOTFARE |
Total price of flight ticket |
TST_TOTAL_FARE |
TOTAL_FARE |
0TV_C_AMNT |
Total price of car rental |
CAR_TOTAL_RATE_AMOUNT |
CAR_TOTAL_RATE |
0TV_H_PRICE |
Total hotel price |
HOTEL_PRICE |
HOTEL_PRICE |
0TV_C_PRICE |
Rental car price by day, week, etc. |
CAR_PRICE |
CAR_PRICE |
0TV_TREBFAR |
Rebated price of flight ticket |
TST_REBATED_FARE |
REBATE_FARE |
0TV_H_RATE |
Rate / Price per night |
HOTEL_RATE |
HOTEL_RATE |
In addition, the fields TST_ISSUE_TYPE and TICKETTYPE are available in the R/3 DataSource as Other Fields, to which, however, no InfoObjects have been assigned in the BW system.