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

Here we would like to draw your attention to FTPT_IMR_HTL_DIR 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_DIR is a SAP standard transp table used for storing IMR – Hotel (Direct Access) related data in SAP. It comes under the package PTRI.

SAP FTPT_IMR_HTL_DIR table

Table FTPT_IMR_HTL_DIR technical data

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

SAP FTPT_IMR_HTL_DIR 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_DIR 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 Flight 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 11
  • RATE_INFO
    Its data type is CHAR (Character String) with field length 1
  • 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
  • LIST_OF_OPTIONS
    Its data type is CHAR (Character String) with field length 200
  • PAST_DATE_IND
    Its data type is CHAR (Character String) with field length 1