FTPT_HOTEL - Travel Request Item - Hotel Service

Travel Request Item - Hotel Service information is stored in SAP table FTPT_HOTEL.
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_HOTEL

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	Hotel number	X	HOTEL_SERVICE_NR	NUMC	6
HOTEL	Hotel Chain		HOTEL_PROVIDER	CHAR	6	TA21P
PROPERTY	Hotel Code (Key for an Individual Hotel)		HOTEL_PROPERTY	CHAR	12
DATE_ARR	Arrival Date Hotel		HOTEL_DATE_ARR	DATS	16
DATE_DEP	Departure Date Hotel		HOTEL_DATE_DEP	DATS	16
LOC	Hotel Location		HOTEL_SLOCATION	CHAR	6	TA21L
NAME	Name of Hotel		HOTEL_NAME	CHAR	80
ADDRESS	Hotel Address (address string separated by #)		HOTEL_ADDRESS	CHAR	264
CLASS	Hotel category		HOTEL_CLASS	CHAR	2
ROOMTYPE	Hotel Room Type		HOTEL_ROOMTYPE	CHAR	2
MEALS	Hotel Meals		HOTEL_MEALS	CHAR	2
OCCUPANCY	Number of hotel occupants		HOTEL_OCCUPANCY	INT1	1
ROOMS	Number of Hotel Rooms		HOTEL_NUMBER_OF_ROOMS	INT1	1
BEDS	Number of Beds		HOTEL_NUMBER_OF_BEDS	CHAR	2
BED_TYPE	Bed Type		HOTEL_BEDDING_TYPE	CHAR	2
ROOM_RATE_CODE	Rate Code (Hotel-Specific)		HOTEL_ROOM_RATE_CODE	CHAR	6
RATE_CODE	Hotel Rate Category		HOTEL_RATE_PLAN_CODE	CHAR	6
RATE_CHANGE_IND	Price Change Due To Requested Period of Stay		HOTEL_RATE_CHANGE	CHAR	2
GUARANTEE_NEEDED	Reservation Guarantee Required		HOTEL_GUARANTEE_NEEDED	CHAR	2
GUARANTEE	Guarantee for room reservation at booking		HOTEL_GUARANTEE	CHAR	80
DEPOSIT_NEEDED	Deposit Required for Reservation		HOTEL_DEPOSIT_NEEDED	CHAR	2
DEPOSIT	Deposit payment method for room reservation		HOTEL_DEPOSIT	CHAR	80
HOLD_IND	Guarantee for Room Availability		HOTEL_HOLD_IND	CHAR	2
HOLD_TIME	Time limit for guarantee of room availability		HOTEL_HOLD_TIME	TIMS	12
SELL_RULE_IND	Reservation Rules Exist		HOTEL_SELL_RULE_IND	CHAR	2
CORPORATE_ID_IND	Company Identification Required		HOTEL_CORPORATE_ID_IND	CHAR	2
CORPORATE_ID	Company identification for room reservation		HOTEL_CORPORATE_ID	CHAR	60
QUALIFIED_IND	Rate Category Indicator: Authorization Required		HOTEL_QUALIFIED_IND	CHAR	2
MIN_STAY_IND	Minimum Stay Required		HOTEL_MIN_STAY_IND	CHAR	2
TOTAL_RATE_IND	Total price		HOTEL_TOTAL_RATE_IND	CHAR	2
RATE	Rate/Price Per Night		HOTEL_RATE	CURR	6
PRICE	Total Price for Hotel Stay		HOTEL_PRICE	CURR	6
CURRENCY	Currency		HOTEL_CURRENCY	CUKY	10	TCURC
ADD_INFO	Additional hotel information		HOTEL_ADD_INFO	CHAR	264
STATUS	Hotel Status		HOTEL_STATUS	CHAR	4
TEMPLATE	Template indicator		VARIANT_TEMPLATE	CHAR	2
AREA_LOC	Hotel Area		HOTEL_AREA_LOC	CHAR	2
TRANS_LOC	Transportation Option to Hotel		HOTEL_TRANS_LOC	CHAR	2
CONF_NUM	Hotel Reservation Number		HOTEL_CONFIRMATION_NUMBER	CHAR	34
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	Line Number of Hotel in PNR (if PNR available)		HOTEL_LINENUMBER	INT2	2	FTPT_PNR
PROFILE	Travel Profile		PROF_ID	CHAR	16
PROFITEM	Trip rule		PROF_ITEM	CHAR	16
KZTKT	Trip Activity Type		PLAN_ACTIVITY	CHAR	2
SPECHID	Class rule		SSPECID	CHAR	16
PRIORITY	Priority of trip rule		PROFIL_PRIROITY	CHAR	2
HIGHEST_PRIORITY	Priority of trip rule		PROFIL_PRIROITY	CHAR	2
COMPLETE_ACCESS	Direct Access to Reservation System of Hotel		COMPLETE_ACCESS_IND	CHAR	2
BOOKING_CODE	Reservation Code for a Hotel Room		HOTEL_BOOKING_CODE	CHAR	20
CATALOGUE_ID	Hotel Catalog Item (enterprise-specific)		HOTEL_ID	CHAR	16	TA21PH
CANCEL_TIME	Hotel Reservation: Cancelation Deadline		HOTEL_CANCEL_TIME	CHAR	10
CANCEL_TYPE	Hotel Reservation: Time Unit for Cancelation Deadline		HOTEL_CANCEL_TYPE	CHAR	2
.INCLUDE				PS0472	0
SMOKE	Nonsmoking Room Requested		HOTEL_PREF_SMOKE	CHAR	2
HCATG	Preferred Hotel Category		HOTEL_PREF_CLASS	CHAR	2
BEDTP	Preferred Bed Type		HOTEL_PREF_BEDTYPE	CHAR	2
RCATG	Preferred Room Category		HOTEL_PREF_ROOMTYPE	CHAR	2
PREF1	Hotel Chain - First Preference		HOTEL_PREF_PROVIDER	CHAR	6	TA21P
PREF2	Hotel Chain - Second Preference		HOTEL_PREF_PROVIDER2	CHAR	6	TA21P
PREF3	Hotel Chain - Third Preference		HOTEL_PREF_PROVIDER3	CHAR	6	TA21P
.INCLUDE				CI_P0472	0
.INCLUDE				FTPS_REASON_CODE	0
REASON_CODE	Reason Code		REASON_CODE	CHAR	4	*
REASON_TEXT	Reason Text		REASON_TEXT	CHAR	264
.INCLUDE				FTPS_HOTEL_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_HOTEL_APPEND	0
.INCLUDE				FTPS_HOTEL_APPEND_HRS	0
LOC_TEXT	Location for Hotel Search		HRS_HOTEL_LOCATION	CHAR	128
COUNTRY	HRS Country Code		HRS_HOTEL_COUNTRY	CHAR	6
SINGLE_DOUBLE	Room Occupancy		HRS_HOTEL_OCCUPANCY	CHAR	24
SEARCH_RADIUS	Radius for Hotel Search		HRS_HOTEL_SEARCH_RADIUS	NUMC	8
HOTEL_NUMBER	HRS Hotel Number		HRS_HOTEL_NUMBER	CHAR	20
BOOKING_NR	HRS Booking Number		HRS_HOTEL_BOOKING_NR	CHAR	64
BOOKING_PW	HRS Booking Password		HRS_HOTEL_BOOKING_PW	CHAR	64
RATE_NUMBER	HRS Rate		HRS_HOTEL_RATE_NUMBER	CHAR	20
.INCLU--AP				FTPS_DIRECT_HOTEL_APPEND	0
.INCLUDE				FTPS_DIRECT_HOTEL	0
LOC_CODE	Hotel location code - Provider Specific		HOTEL_LOCATION_CODE	CHAR	40
CORPORATE_RATE	Hotel Rate Type		HOTEL_RATE_TYPE	CHAR	2
RATE_NAME	Direct Hotel/Room Rate Name		FTPD_HOTEL_RATE_NAME	CHAR	80
.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	*