FTPT_IMR_HTL SAP (IMR - Hotel) Table details

Dictionary Type: Table
Description: IMR - Hotel




ABAP Code to SELECT data from FTPT_IMR_HTL
Related tables to FTPT_IMR_HTL
Access table FTPT_IMR_HTL




Table field list including key, data, relationships and ABAP select examples

FTPT_IMR_HTL is a standard SAP Table which is used to store IMR - Hotel data and is available within R/3 SAP systems depending on the version and release level.

The FTPT_IMR_HTL table consists of various fields, each holding specific information or linking keys about IMR - Hotel data available in SAP. These include MANDT (Client), RECORD_LOCATOR (Passenger Name Record Locator), AIR_NUMBER (Air record unique identifier), RUNNING_NUMBER (Index).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP FTPT_IMR_HTL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
RECORD_LOCATORPassenger Name Record Locator PNR_RECORD_LOCATORCHAR20FTPD_PNR_RECORD_LOCATOR
AIR_NUMBERAir record unique identifier AIR_RECORD_NUMBERNUMC12FTPT_IMR
RUNNING_NUMBERIndex RUNNING_NUMBERNUMC4FTPD_RUNNING_NUMBER
HOTEL_SEG_TYPEAIR : Description of segment type for itinerary portion API_1A_AIR_SEGMENT_TYPENUMC2FTPD_AIR_SEGMENT_TYPE
TATTOO_NUMBERAmadeus unique identifier for each element stored in PNR API_1A_TATTOO_NUMBERNUMC4
DISPLAY_NUMBERAmadeus unique identifier for each element displayed in PNR API_1A_DISPLAY_NUMBERNUMC4
PROVIDER_CODE 0
STATUS_CODEReal status code from Amadeus API_1A_STATUS_CODECHAR2
NUMBER_OF_ROOMS 0
IN_DATE 0
OUT_DATE 0
ARPT_CITY_CODE5 character code identifying a City Code API_1A_CITY_CODECHAR5
ARPT_CITY_NAME 0
ROOM_TYPE_CODERoom type code for Hotels API_1A_HTL_ROOM_TYPECHAR8
CURRENCY_CODECurrency code API_1A_CURRENCY_CODECHAR5
RATE_PER_NIGHT 0
RATE_TYPERoom type code for Hotels API_1A_HTL_RATE_TYPECHAR4
RATE_INFO 0
PROPERTY_ID 0
RATE_BOOK_CODE 0
BS_TYPE 0
BSBooking source for reservation identification API_1A_BOOKING_SOURCECHAR10
CONF_NUMBERConfirmation Code returned after Hotel reservation API_1A_CONFIRMATIONCHAR20
AP_MEALPLAN_RATE 0
CORP_ID_NUMBERConfirmation Code returned after Hotel reservation API_1A_CORPORATE_IDCHAR25
CRIB_RATE 0
DEPOSIT_FOP 0
EXTRA_PERS_RATE 0
FA_MEALPLAN_RATE 0
FM_MEALPLAN_RATE 0
GUARANTEE_METHOD 0
MA_MEALPLAN_RATE 0
ADULT_ROLLAWAY 0
CHILD_ROLLAWAY 0
ROOM_OVERRIDE 0
SUPP_INFO 0
HFS_IND 0
ACCOUNT_INFO 0
HOTEL_NAME 0
HOTEL_INFO1 0
HOTEL_INFO2 0
HOTEL_INFO3 0
HOTEL_ADD1 0
HOTEL_ADD2 0
HOTEL_CITY 0
HOTEL_STATECODE 0
HOTEL_COUNTRY 0
HOTEL_ZIP_CODE 0
HOTEL_PHONE 0
HOTEL_FAX 0
HOTEL_TELEX 0
PAST_DATE_IND 0
EXTRA_INFO1 0
EXTRA_INFO2 0
EXTRA_INFO3 0
EXTRA_INFO4 0

Key field Non-key field



How do I retrieve data from SAP table FTPT_IMR_HTL using ABAP code

The following ABAP code Example will allow you to do a basic selection on FTPT_IMR_HTL to SELECT all data from the table
DATA: WA_FTPT_IMR_HTL TYPE FTPT_IMR_HTL.

SELECT SINGLE *
FROM FTPT_IMR_HTL
INTO CORRESPONDING FIELDS OF WA_FTPT_IMR_HTL
WHERE...

How to access SAP table FTPT_IMR_HTL

Within an ECC or HANA version of SAP you can also view further information about FTPT_IMR_HTL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!