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.