Menu

SAP Table FTPT_IMR_HTL

IMR - Hotel

The table FTPT_IMR_HTL (IMR - Hotel) is a standard table in SAP ERP. It belongs to the package PTRI.

Technical Information

Table FTPT_IMR_HTL
Short Text IMR - Hotel
Package PTRI
Table Type Transparent Table

Fields for Table FTPT_IMR_HTL

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 *
RECORD_LOCATOR Passenger Name Record Locator PNR_RECORD_LOCATOR CHAR 20
AIR_NUMBER Air record unique identifier AIR_RECORD_NUMBER NUMC 12 FTPT_IMR
RUNNING_NUMBER Index RUNNING_NUMBER NUMC 4
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