1. SAP Tutorial
  2. FI Module

FTPT_IMR_HTL SAP table for – IMR – Hotel

Here we would like to draw your attention to FTPT_IMR_HTL table in SAP. As we know it is being mainly used with the SAP FI-TV (Travel Management in FI) component which is coming under FI module (Financial Accounting). FTPT_IMR_HTL is a SAP standard transp table used for storing IMR – Hotel related data in SAP. It comes under the package PTRI.

SAP FTPT_IMR_HTL table

Table FTPT_IMR_HTL technical data

TableFTPT_IMR_HTL
Data storingIMR – Hotel
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRI
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_IMR_HTL Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FTPT_IMR_HTL table.

  • .INCLUDE : Key for Information Management record
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECORD_LOCATOR : Passenger Name Record Locator
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • AIR_NUMBER : Air record unique identifier
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • RUNNING_NUMBER : Index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : AIR : Structure to describe Hotel information for Automated
  • HOTEL_SEG_TYPE : AIR : Description of segment type for itinerary portion
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TATTOO_NUMBER : Amadeus unique identifier for each element stored in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISPLAY_NUMBER : Amadeus unique identifier for each element displayed in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PROVIDER_CODE : Airline Code definition
    Its data type is CHAR (Character String) with field length 4
  • STATUS_CODE : Real status code from Amadeus
    Its data type is CHAR (Character String) with field length 2
  • NUMBER_OF_ROOMS
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • IN_DATE : Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OUT_DATE : Date of Last Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ARPT_CITY_CODE : 5 character code identifying a City Code
    Its data type is CHAR (Character String) with field length 5
  • ARPT_CITY_NAME
    Its data type is CHAR (Character String) with field length 20
  • ROOM_TYPE_CODE : Room type code for Hotels
    Its data type is CHAR (Character String) with field length 8
  • CURRENCY_CODE : Currency code
    Its data type is CHAR (Character String) with field length 5
  • RATE_PER_NIGHT
    Its data type is CHAR (Character String) with field length 10
  • RATE_TYPE : Room type code for Hotels
    Its data type is CHAR (Character String) with field length 4
  • RATE_INFO
    Its data type is CHAR (Character String) with field length 50
  • PROPERTY_ID : Property
    Its data type is CHAR (Character String) with field length 3
  • RATE_BOOK_CODE
    Its data type is CHAR (Character String) with field length 10
  • BS_TYPE
    Its data type is CHAR (Character String) with field length 1
  • BS : Booking source for reservation identification
    Its data type is CHAR (Character String) with field length 10
  • CONF_NUMBER : Confirmation Code returned after Hotel reservation
    Its data type is CHAR (Character String) with field length 20
  • AP_MEALPLAN_RATE
    Its data type is CHAR (Character String) with field length 20
  • CORP_ID_NUMBER : Confirmation Code returned after Hotel reservation
    Its data type is CHAR (Character String) with field length 25
  • CRIB_RATE
    Its data type is CHAR (Character String) with field length 20
  • DEPOSIT_FOP
    Its data type is CHAR (Character String) with field length 35
  • EXTRA_PERS_RATE
    Its data type is CHAR (Character String) with field length 20
  • FA_MEALPLAN_RATE
    Its data type is CHAR (Character String) with field length 20
  • FM_MEALPLAN_RATE
    Its data type is CHAR (Character String) with field length 20
  • GUARANTEE_METHOD
    Its data type is CHAR (Character String) with field length 35
  • MA_MEALPLAN_RATE
    Its data type is CHAR (Character String) with field length 20
  • ADULT_ROLLAWAY
    Its data type is CHAR (Character String) with field length 20
  • CHILD_ROLLAWAY
    Its data type is CHAR (Character String) with field length 20
  • ROOM_OVERRIDE
    Its data type is CHAR (Character String) with field length 8
  • SUPP_INFO
    Its data type is CHAR (Character String) with field length 50
  • HFS_IND
    Its data type is CHAR (Character String) with field length 1
  • ACCOUNT_INFO
    Its data type is CHAR (Character String) with field length 30
  • HOTEL_NAME
    Its data type is CHAR (Character String) with field length 50
  • HOTEL_INFO1
    Its data type is CHAR (Character String) with field length 60
  • HOTEL_INFO2
    Its data type is CHAR (Character String) with field length 60
  • HOTEL_INFO3
    Its data type is CHAR (Character String) with field length 60
  • HOTEL_ADD1
    Its data type is CHAR (Character String) with field length 60
  • HOTEL_ADD2
    Its data type is CHAR (Character String) with field length 60
  • HOTEL_CITY
    Its data type is CHAR (Character String) with field length 30
  • HOTEL_STATECODE
    Its data type is CHAR (Character String) with field length 3
  • HOTEL_COUNTRY
    Its data type is CHAR (Character String) with field length 30
  • HOTEL_ZIP_CODE
    Its data type is CHAR (Character String) with field length 20
  • HOTEL_PHONE
    Its data type is CHAR (Character String) with field length 30
  • HOTEL_FAX
    Its data type is CHAR (Character String) with field length 30
  • HOTEL_TELEX
    Its data type is CHAR (Character String) with field length 30
  • PAST_DATE_IND
    Its data type is CHAR (Character String) with field length 1
  • EXTRA_INFO1
    Its data type is CHAR (Character String) with field length 30
  • EXTRA_INFO2
    Its data type is CHAR (Character String) with field length 30
  • EXTRA_INFO3
    Its data type is CHAR (Character String) with field length 30
  • EXTRA_INFO4
    Its data type is CHAR (Character String) with field length 30

    • FTPT_IMR_HTL related tables

    • FTPT_IMR_SSRSEG : IMR: Assignment Table Special Serv.Request to Flight Segment
    • FTPT_IMR_FQTV : IMR: Customer Programs
    • FTPT_IMR_HTL : IMR – Hotel
    • FTPT_IMR_SURFACE : IMR – Other Segments of Trip as Flights
    • FTPT_IMR_FOP : IMR : Information on Payment Method
    • FTPT_IMR_SEATSEG : IMR: Table for Assignment of Seats to Flight Segments
    • FTPT_IMR_SEATS : IMR: Seating Information
    • FTPT_IMR_SSRS : IMR: Information on Special Service Requirements
    • FTPT_IMR_FQTVSEG : IMR: Assignment Table Customer Programs to Flight Segments
    • FTPT_IMR_TRAIN : IMR – Train
    • FTPT_IMR_TKT : IMR : Ticket Information
    • FTPT_IMR_FELMSEG : IMR: Table for Assignment of Ticket to Flight Segment
    • FTPT_IMR_NAMES : IMR : Name
    • FTPT_IMR_CAR : IMR – Car Rental
    • FTPT_IMR_FAREDAT : IMR – Price Data Description
    • FTPT_IMR_FAREELM : IMR: Passenger Information for Price Determination
    • FTPT_IMR_HTL_DIR : IMR – Hotel (Direct Access)
    • FTPT_IMR_MANUAL : IMR – Manually Created Segments
    • FTPT_IMR_FLIGHT : IMR – Flight
    • FTPT_IMR : IMR – General Information

    Related References

    Related Tutorials

    FTPT_IMR_HTL_DIR SAP table for – IMR – Hotel (Direct Access)

    FTPT_IMR_HTL_DIR table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    FTPT_IMR_DETAIL SAP table for – IMR – Detail Information

    FTPT_IMR_DETAIL table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    FTPT_IMR_MANUAL SAP table for – IMR – Manually Created Segments

    FTPT_IMR_MANUAL table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR -...

    FTPT_IMR_NAMES SAP table for – IMR : Name

    FTPT_IMR_NAMES table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR :...

    FTPT_IMR_FSP SAP table for – IMR: Assignment Table Passengers-Segments-TST

    FTPT_IMR_FSP table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR: Assignment...

    FTPT_IMR_SEATS SAP table for – IMR: Seating Information

    FTPT_IMR_SEATS table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR: Seating...

    FTPT_IMR_SSRS SAP table for – IMR: Information on Special Service Requirements

    FTPT_IMR_SSRS table in SAP FI (Travel Management in FI) module. This table is used for storing data of IMR: Information...

    «
    »