SAP Table FTPT_IMR_HTL
IMR - Hotel
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
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 |