FTPT_IMR_HTL - IMR - Hotel

IMR - Hotel information is stored in SAP table FTPT_IMR_HTL.
It is part of development package PTRI in software component FI-TV-PL. This development package consists of objects that can be grouped under "Interfaces for Travel Planning".

Fields for table FTPT_IMR_HTL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		FTPS_IMR_KEY	0
MANDT	Client	X	MANDT	CLNT	3	*
RECORD_LOCATOR	Passenger Name Record Locator	X	PNR_RECORD_LOCATOR	CHAR	20
AIR_NUMBER	Air record unique identifier	X	AIR_RECORD_NUMBER	NUMC	12	FTPT_IMR
RUNNING_NUMBER	Index	X	RUNNING_NUMBER	NUMC	4
.INCLUDE				FTPS_IMR_HOTEL_SEG	0
HOTEL_SEG_TYPE	AIR : Description of segment type for itinerary portion		API_1A_AIR_SEGMENT_TYPE	NUMC	2
TATTOO_NUMBER	Amadeus unique identifier for each element stored in PNR		API_1A_TATTOO_NUMBER	NUMC	4
DISPLAY_NUMBER	Amadeus unique identifier for each element displayed in PNR		API_1A_DISPLAY_NUMBER	NUMC	4
PROVIDER_CODE				CHAR	4
STATUS_CODE	Real status code from Amadeus		API_1A_STATUS_CODE	CHAR	2
NUMBER_OF_ROOMS				NUMC	2
IN_DATE				DATS	8
OUT_DATE				DATS	8
ARPT_CITY_CODE	5 character code identifying a City Code		API_1A_CITY_CODE	CHAR	5
ARPT_CITY_NAME				CHAR	20
ROOM_TYPE_CODE	Room type code for Hotels		API_1A_HTL_ROOM_TYPE	CHAR	8
CURRENCY_CODE	Currency code		API_1A_CURRENCY_CODE	CHAR	5
RATE_PER_NIGHT				CHAR	10
RATE_TYPE	Room type code for Hotels		API_1A_HTL_RATE_TYPE	CHAR	4
RATE_INFO				CHAR	50
PROPERTY_ID				CHAR	3
RATE_BOOK_CODE				CHAR	10
BS_TYPE				CHAR	1
BS	Booking source for reservation identification		API_1A_BOOKING_SOURCE	CHAR	10
CONF_NUMBER	Confirmation Code returned after Hotel reservation		API_1A_CONFIRMATION	CHAR	20
AP_MEALPLAN_RATE				CHAR	20
CORP_ID_NUMBER	Confirmation Code returned after Hotel reservation		API_1A_CORPORATE_ID	CHAR	25
CRIB_RATE				CHAR	20
DEPOSIT_FOP				CHAR	35
EXTRA_PERS_RATE				CHAR	20
FA_MEALPLAN_RATE				CHAR	20
FM_MEALPLAN_RATE				CHAR	20
GUARANTEE_METHOD				CHAR	35
MA_MEALPLAN_RATE				CHAR	20
ADULT_ROLLAWAY				CHAR	20
CHILD_ROLLAWAY				CHAR	20
ROOM_OVERRIDE				CHAR	8
SUPP_INFO				CHAR	50
HFS_IND				CHAR	1
ACCOUNT_INFO				CHAR	30
HOTEL_NAME				CHAR	50
HOTEL_INFO1				CHAR	60
HOTEL_INFO2				CHAR	60
HOTEL_INFO3				CHAR	60
HOTEL_ADD1				CHAR	60
HOTEL_ADD2				CHAR	60
HOTEL_CITY				CHAR	30
HOTEL_STATECODE				CHAR	3
HOTEL_COUNTRY				CHAR	30
HOTEL_ZIP_CODE				CHAR	20
HOTEL_PHONE				CHAR	30
HOTEL_FAX				CHAR	30
HOTEL_TELEX				CHAR	30
PAST_DATE_IND				CHAR	1
EXTRA_INFO1				CHAR	30
EXTRA_INFO2				CHAR	30
EXTRA_INFO3				CHAR	30
EXTRA_INFO4				CHAR	30