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.