FTPT_CAR - Travel Request Item - Car Rental Service

Travel Request Item - Car Rental Service information is stored in SAP table FTPT_CAR.
It is part of development package PTRP in software component FI-TV-PL. This development package consists of objects that can be grouped under "Travel Planning".

Fields for table FTPT_CAR

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		FTPS_PLAN	0
MANDT	Client	X	MANDT	CLNT	6	*
PERNR	Personnel Number	X	PERNR_D	NUMC	16
REINR	Trip Number	X	REINR	NUMC	20
PLANNR	Travel Plan Number (Sequential Number)	X	PLAN_NR	NUMC	4	*
VARIANT	Plan variant number (sequential number)	X	VARIANT_NR	NUMC	4
VARIANTVRS	Version of travel plan	X	VARIANT_VERSION	NUMC	4
ITEM	Travel Request Item Number (Sequential Number)	X	ITEMPOS_NR	NUMC	6	FTPT_ITEM
SERVICE	Rental car number	X	CAR_SERVICE_NR	NUMC	6
PROVIDER	Car Rental Provider		CAR_PROVIDER	CHAR	6	TA21P
DATE_BEG	Start Date for Rental Car		CAR_DATE_BEG	DATS	16
TIME_BEG	Rental Car Starting Time		CAR_TIME_BEG	TIMS	12
LOC_BEG	Rental Car Starting Location		CAR_LOC_BEG	CHAR	6	TA21L
DATE_END	End date for car rental		CAR_DATE_END	DATS	16
TIME_END	End time for car rental		CAR_TIME_END	TIMS	12
LOC_END	Dropoff Location		CAR_LOC_END	CHAR	6	TA21L
PICKUP_LOC	Car rental branch office for vehicle pickup		CAR_PICKUP_LOC	CHAR	12
ADDRESS	Address of car rental branch office for pickup		CAR_ADDRESS	CHAR	80
DROPOFF_LOC	Car rental office for dropoff		CAR_DROPOFF_LOC	CHAR	12
ADDRESS_DROPOFF	Address of car rental office for dropoff		CAR_ADDRESS_DROPOFF	CHAR	80
CLASS	Rental Car Vehicle Class		CAR_CLASS	CHAR	2
TYPE	Rental Car Vehicle Type		CAR_TYPE	CHAR	2
TRANSMISSION	Car Transmission		CAR_TRANSMISSION	CHAR	2
AIR_CONDITION	Vehicle Air-Conditioning		CAR_AIR_CONDITION	CHAR	2
QUANTITY	Number of cars		CAR_QUANTITY	INT1	1
SEGMENT_INDEX	Current line number of PNR		CAR_SEGMENT_INDEX	INT1	1
CONF_NUM	Car Rental Reservation Number		CAR_CONFIRMATION_NUMBER	CHAR	34
PRICE	Car Rental Price Per Day/Week/Etc.		CAR_PRICE	CURR	6
RATE_PLAN	Rental Car Rate Rule (by day/weekend/week/month)		CAR_RATE_PLAN	CHAR	16
RATE_CODE	Rental Car Rate Key (Provider-Dependent)		CAR_RATECODE	CHAR	24
CORPORATE_ID	Company ID for Negotiated Rates		CAR_CORPORATE_ID	CHAR	60
GUARANTEE_NEEDED	Reservation guarantee required		CAR_GUARANTEE_NEEDED	CHAR	2
GUARANTEE	Guarantee for rental care reservation at booking		CAR_GUARANTEE	CHAR	80
DEPOSIT_NEEDED	Rental car: Down payment required		CAR_DEPOSIT_NEEDED	CHAR	2
DEPOSIT	Deposit payment method for room reservation		CAR_DEPOSIT	CHAR	80
FREE_MILES	Distance Restriction (miles/kilometers)		CAR_FREE_MILES	CHAR	10
EXTRA_CHARGE	Surcharge for Car Rental Excess Usage		CAR_EXTRA_CHARGE	CURR	6
DROPOFF_CHARGE	Charges for Rental Car Dropoff		CAR_DROPOFF_CHARGE	CURR	6
EXTRA_CHARGE_TYP	Surcharge time unit for car rental usage exceeding		CAR_EXTRA_CHARGE_TYPE	CHAR	6
TOTAL_RATE_TYPE	Car rental rate indicator (total amount)		CAR_TOTAL_RATE_TYPE	CHAR	6
TOT_RATE_AMOUNT	Total Price for Car Rental		CAR_TOTAL_RATE_AMOUNT	CURR	6
TOT_CURRENCY	Currency		CAR_CURRENCY	CUKY	10	TCURC
EXTRA_MILAGE	Surcharge for Exceeding Miles/Kms Limit for Rental Car		CAR_EXTRA_MILAGE	CURR	6
CURRENCY	Currency		CAR_CURRENCY	CUKY	10	TCURC
STATUS	Car Rental Status		CAR_STATUS	CHAR	4
TEMPLATE	Template indicator		VARIANT_TEMPLATE	CHAR	2
CAR_AREA	City of car rental office (location)		CAR_AREA	CHAR	2
MEMBSHIP_PROVCAT	Customer Program: Provider Category		MEMBSHIP_PROVIDER_CATEGORY	CHAR	2
MEMBSHIP_PROV	Customer Program: Provider Code		MEMBSHIP_PROVIDER_CODE	CHAR	6
MEMBSHIP_KRZL	Customer Program Code		PROV_PROGRAM_SHORTHAND	CHAR	6	TA21PF
MEMBSHIP_ID	Customer number		PROV_PROGRAM_NR	CHAR	40
FLIGHT_MEM_PROV	Frequent flyer program: Provider code		FLIGHT_PROGRAM_PROVIDER_CODE	CHAR	6
FLIGHT_MEM_KRZL	Frequent Flyer Program ID		FLIGHT_PROGRAM_SHORTHAND	CHAR	6	TA21PF
FLIGHT_MEM_ID	Frequent flyer number		FLIGHT_PROGRAM_NR	CHAR	40
PNR_NR	Zeilennummer der CAR in der Itinerary		CAR_LINENUMBER	INT2	2
PROFILE	Travel Profile		PROF_ID	CHAR	16
PROFITEM	Trip rule		PROF_ITEM	CHAR	16
KZTKT	Trip Activity Type		PLAN_ACTIVITY	CHAR	2
SPECCID	Class rule		SSPECID	CHAR	16
PRIORITY	Priority of trip rule		PROFIL_PRIROITY	CHAR	2
HIGHEST_PRIORITY	Priority of trip rule		PROFIL_PRIROITY	CHAR	2
CANCEL_TIME	Car rental reser.: Latest possible cancellation time		CAR_CANCEL_TIME	CHAR	10
CANCEL_TYPE	Car rental res.: Time unit - latest poss. cancellation time		CAR_CANCEL_TYPE	CHAR	2
.INCLUDE				PS0473	0
SMOKE	Nonsmoking Car Requested		CAR_PREF_SMOKER	CHAR	2
KLIMA	Air Conditioning Requested		CAR_PREF_KLIMA	CHAR	2
GEAR	Manual Gear Shift Requested		CAR_PREF_GEAR	CHAR	2
AUTOM	Automatic Transmission Requested		CAR_PREF_AUTOM	CHAR	2
CBRAND	Preferred Car Make		CAR_PREF_BRAND	CHAR	24
PREF1	First Preference for Car Rental Company		CAR_PREF_PROVIDER	CHAR	6	TA21P
PREF2	Second Preference for Car Rental Company		CAR_PREF_PROVIDER2	CHAR	6	TA21P
PREF3	Third Preference for Car Rental Company		CAR_PREF_PROVIDER3	CHAR	6	TA21P
.INCLUDE				CI_P0473	0
.INCLUDE				FTPS_REASON_CODE	0
REASON_CODE	Reason Code		REASON_CODE	CHAR	4	*
REASON_TEXT	Reason Text		REASON_TEXT	CHAR	264
.INCLUDE				FTPS_CAR_CARD_GUID	0
GUARANTEE_GUID	GUID of a Payment Card		CARD_GUID	RAW	16
DEPOSIT_GUID	GUID of a Payment Card		CARD_GUID	RAW	16
.INCLU--AP				FTPS_CAR_APPEND	0
NON_GDS_PUP_LOC	Car Rental Branch Office for Pickup (Provider-Specific)		CAR_PICKUP_LOC_NONGDS	CHAR	22
NON_GDS_DO_LOC	Car Rental Branch Office for Dropoff (Provider-Specific)		CAR_DROPOFF_LOC_NONGDS	CHAR	22
ADDITIONAL_INFO	Additional Information on Vehicle from Provider		CAR_ADDITIONAL_INFO	CHAR	256
EST_PRICE	Total Price for Car Rental		CAR_TOTAL_RATE_AMOUNT	CURR	6
EST_CURRENCY	Currency		CAR_CURRENCY	CUKY	10	*
CHECK_POLICY	Indicates Whether Policy Check Necessary		CAR_CHECK_POLICY	CHAR	2
ADVANCE_PAYMENT	Payment in Advance Required		CAR_ADVANCE_PAYMENT	CHAR	2
DELIVERY_ADDR	Address to Which Car Is Delivered		CAR_DELIVERY_ADDRESS	CHAR	120
COLLECTION_ADDR	Address at Which Car Is Collected		CAR_COLLECTION_ADDRESS	CHAR	120
FARE_TYPE	Rental Car: Rate Type		CAR_FARE_TYPE	CHAR	12
.INCLUDE				FTPS_EXCEEDING_FARE	0
EXCEEDING_FARE	Excess Amount over Lowest Offer		EXCEEDING_FARE	CURR	6
EXCEEDING_FARE_C	Currency of Excess Amount over Lowest Offer		EXCEEDING_FARE_CURR	CUKY	10	*
.INCLU--AP				FTPS_CAR_APPEND_EXTENSION	0
.INCLUDE				FTPS_CAR_EXT_PLAN	0
LOC_BEG_NAME	Name of Location		STATION_LOCATION_NAME	CHAR	200
LOC_END_NAME	Name of Location		STATION_LOCATION_NAME	CHAR	200