SAP Table FTPT_HOTEL

Travel Request Item - Hotel Service

The table FTPT_HOTEL (Travel Request Item - Hotel Service) is a standard table in SAP ERP. It belongs to the package PTRP.

Technical Information

Table	FTPT_HOTEL
Short Text	Travel Request Item - Hotel Service
Package	PTRP
Table Type	Transparent Table

Fields for Table FTPT_HOTEL

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	*
PERNR	✔	Personnel Number	PERNR_D	NUMC	8
REINR	✔	Trip Number	REINR	NUMC	10
PLANNR	✔	Travel Plan Number (Sequential Number)	PLAN_NR	NUMC	2	*
VARIANT	✔	Plan variant number (sequential number)	VARIANT_NR	NUMC	2
VARIANTVRS	✔	Version of travel plan	VARIANT_VERSION	NUMC	2	*
ITEM	✔	Travel Request Item Number (Sequential Number)	ITEMPOS_NR	NUMC	3	FTPT_ITEM
SERVICE	✔	Hotel number	HOTEL_SERVICE_NR	NUMC	3
HOTEL		Hotel Chain	HOTEL_PROVIDER	CHAR	3	TA21P
PROPERTY		Hotel Code (Key for an Individual Hotel)	HOTEL_PROPERTY	CHAR	6
DATE_ARR		Arrival Date Hotel	HOTEL_DATE_ARR	DATS	8
DATE_DEP		Departure Date Hotel	HOTEL_DATE_DEP	DATS	8
LOC		Hotel Location	HOTEL_SLOCATION	CHAR	3	TA21L
NAME		Name of Hotel	HOTEL_NAME	CHAR	40
ADDRESS		Hotel Address (address string separated by #)	HOTEL_ADDRESS	CHAR	132
CLASS		Hotel category	HOTEL_CLASS	CHAR	1
ROOMTYPE		Hotel Room Type	HOTEL_ROOMTYPE	CHAR	1
MEALS		Hotel Meals	HOTEL_MEALS	CHAR	1
OCCUPANCY		Number of hotel occupants	HOTEL_OCCUPANCY	INT1	3
ROOMS		Number of Hotel Rooms	HOTEL_NUMBER_OF_ROOMS	INT1	3
BEDS		Number of Beds	HOTEL_NUMBER_OF_BEDS	CHAR	1
BED_TYPE		Bed Type	HOTEL_BEDDING_TYPE	CHAR	1
ROOM_RATE_CODE		Rate Code (Hotel-Specific)	HOTEL_ROOM_RATE_CODE	CHAR	3
RATE_CODE		Hotel Rate Category	HOTEL_RATE_PLAN_CODE	CHAR	3	*
RATE_CHANGE_IND		Price Change Due To Requested Period of Stay	HOTEL_RATE_CHANGE	CHAR	1
GUARANTEE_NEEDED		Reservation Guarantee Required	HOTEL_GUARANTEE_NEEDED	CHAR	1
GUARANTEE		Guarantee for room reservation at booking	HOTEL_GUARANTEE	CHAR	40
DEPOSIT_NEEDED		Deposit Required for Reservation	HOTEL_DEPOSIT_NEEDED	CHAR	1
DEPOSIT		Deposit payment method for room reservation	HOTEL_DEPOSIT	CHAR	40
HOLD_IND		Guarantee for Room Availability	HOTEL_HOLD_IND	CHAR	1
HOLD_TIME		Time limit for guarantee of room availability	HOTEL_HOLD_TIME	TIMS	6
SELL_RULE_IND		Reservation Rules Exist	HOTEL_SELL_RULE_IND	CHAR	1
CORPORATE_ID_IND		Company Identification Required	HOTEL_CORPORATE_ID_IND	CHAR	1
CORPORATE_ID		Company identification for room reservation	HOTEL_CORPORATE_ID	CHAR	30
QUALIFIED_IND		Rate Category Indicator: Authorization Required	HOTEL_QUALIFIED_IND	CHAR	1
MIN_STAY_IND		Minimum Stay Required	HOTEL_MIN_STAY_IND	CHAR	1
TOTAL_RATE_IND		Total price	HOTEL_TOTAL_RATE_IND	CHAR	1
RATE		Rate/Price Per Night	HOTEL_RATE	CURR	10
PRICE		Total Price for Hotel Stay	HOTEL_PRICE	CURR	10
CURRENCY		Currency	HOTEL_CURRENCY	CUKY	5	TCURC
ADD_INFO		Additional hotel information	HOTEL_ADD_INFO	CHAR	132
STATUS		Hotel Status	HOTEL_STATUS	CHAR	2
TEMPLATE		Template indicator	VARIANT_TEMPLATE	CHAR	1
AREA_LOC		Hotel Area	HOTEL_AREA_LOC	CHAR	1
TRANS_LOC		Transportation Option to Hotel	HOTEL_TRANS_LOC	CHAR	1
CONF_NUM		Hotel Reservation Number	HOTEL_CONFIRMATION_NUMBER	CHAR	17
MEMBSHIP_PROVCAT		Customer Program: Provider Category	MEMBSHIP_PROVIDER_CATEGORY	CHAR	1
MEMBSHIP_PROV		Customer Program: Provider Code	MEMBSHIP_PROVIDER_CODE	CHAR	3	*
MEMBSHIP_KRZL		Customer Program Code	PROV_PROGRAM_SHORTHAND	CHAR	3	TA21PF
MEMBSHIP_ID		Customer number	PROV_PROGRAM_NR	CHAR	20
FLIGHT_MEM_PROV		Frequent flyer program: Provider code	FLIGHT_PROGRAM_PROVIDER_CODE	CHAR	3	*
FLIGHT_MEM_KRZL		Frequent Flyer Program ID	FLIGHT_PROGRAM_SHORTHAND	CHAR	3	TA21PF
FLIGHT_MEM_ID		Frequent flyer number	FLIGHT_PROGRAM_NR	CHAR	20
PNR_NR		Line Number of Hotel in PNR (if PNR available)	HOTEL_LINENUMBER	INT2	5	FTPT_PNR
PROFILE		Travel Profile	PROF_ID	CHAR	8	*
PROFITEM		Trip rule	PROF_ITEM	CHAR	8	*
KZTKT		Trip Activity Type	PLAN_ACTIVITY	CHAR	1	*
SPECHID		Class rule	SSPECID	CHAR	8	*
PRIORITY		Priority of trip rule	PROFIL_PRIROITY	CHAR	1
HIGHEST_PRIORITY		Priority of trip rule	PROFIL_PRIROITY	CHAR	1
COMPLETE_ACCESS		Direct Access to Reservation System of Hotel	COMPLETE_ACCESS_IND	CHAR	1
BOOKING_CODE		Reservation Code for a Hotel Room	HOTEL_BOOKING_CODE	CHAR	10
CATALOGUE_ID		Hotel Catalog Item (enterprise-specific)	HOTEL_ID	CHAR	8	TA21PH
CANCEL_TIME		Hotel Reservation: Cancelation Deadline	HOTEL_CANCEL_TIME	CHAR	5
CANCEL_TYPE		Hotel Reservation: Time Unit for Cancelation Deadline	HOTEL_CANCEL_TYPE	CHAR	1
SMOKE		Nonsmoking Room Requested	HOTEL_PREF_SMOKE	CHAR	1
HCATG		Preferred Hotel Category	HOTEL_PREF_CLASS	CHAR	1
BEDTP		Preferred Bed Type	HOTEL_PREF_BEDTYPE	CHAR	1
RCATG		Preferred Room Category	HOTEL_PREF_ROOMTYPE	CHAR	1
PREF1		Hotel Chain - First Preference	HOTEL_PREF_PROVIDER	CHAR	3	TA21P
PREF2		Hotel Chain - Second Preference	HOTEL_PREF_PROVIDER2	CHAR	3	TA21P
PREF3		Hotel Chain - Third Preference	HOTEL_PREF_PROVIDER3	CHAR	3	TA21P
REASON_CODE		Reason Code	REASON_CODE	CHAR	2	*
REASON_TEXT		Reason Text	REASON_TEXT	CHAR	132
GUARANTEE_GUID		GUID of a Payment Card	CARD_GUID	RAW	16
DEPOSIT_GUID		GUID of a Payment Card	CARD_GUID	RAW	16
LOC_TEXT		Location for Hotel Search	HRS_HOTEL_LOCATION	CHAR	64
COUNTRY		HRS Country Code	HRS_HOTEL_COUNTRY	CHAR	3
SINGLE_DOUBLE		Room Occupancy	HRS_HOTEL_OCCUPANCY	CHAR	12
SEARCH_RADIUS		Radius for Hotel Search	HRS_HOTEL_SEARCH_RADIUS	NUMC	4
HOTEL_NUMBER		HRS Hotel Number	HRS_HOTEL_NUMBER	CHAR	10
BOOKING_NR		HRS Booking Number	HRS_HOTEL_BOOKING_NR	CHAR	32
BOOKING_PW		HRS Booking Password	HRS_HOTEL_BOOKING_PW	CHAR	32
RATE_NUMBER		HRS Rate	HRS_HOTEL_RATE_NUMBER	CHAR	10
LOC_CODE		Hotel location code - Provider Specific	HOTEL_LOCATION_CODE	CHAR	20
CORPORATE_RATE		Hotel Rate Type	HOTEL_RATE_TYPE	CHAR	1
RATE_NAME		Direct Hotel/Room Rate Name	FTPD_HOTEL_RATE_NAME	CHAR	40
EXCEEDING_FARE		Excess Amount over Lowest Offer	EXCEEDING_FARE	CURR	10
EXCEEDING_FARE_C		Currency of Excess Amount over Lowest Offer	EXCEEDING_FARE_CURR	CUKY	5	*