FTPT_IMR SAP table for – IMR – General Information

Here we would like to draw your attention to FTPT_IMR 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 is a SAP standard transp table used for storing IMR – General Information related data in SAP. It comes under the package PTRI.

SAP FTPT_IMR table

Table FTPT_IMR technical data

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

SAP FTPT_IMR 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 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
  • AIR_VERSION
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • AIR_OPTION
    Its data type is CHAR (Character String) with field length 2
  • RECORD_TYPE : Type of IUID Message Transfer
    Its data type is CHAR (Character String) with field length 1
  • TRAINING_IND
    Its data type is CHAR (Character String) with field length 1
  • AIR_NETWORK_ID : 2 Digit code identifying the Amadeus Network Id
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • AIR_LNIATA : 8 Digit code identifying a terminal address in Amadeus
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • RETRANSM_IND
    Its data type is CHAR (Character String) with field length 1
  • ACTION_TYPE : Action Type
    Its data type is CHAR (Character String) with field length 4
  • VOID_DATE
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VOID_AGENT_SINE : Travel Agency sine in code in Amadeus
    Its data type is CHAR (Character String) with field length 4
  • TKT_NETWORK_ID : 2 Digit code identifying the Amadeus Network Id
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TKT_LNIATA : 8 Digit code identifying a terminal address in Amadeus
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • BO_NETWORK_ID : 2 Digit code identifying the Amadeus Network Id
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • BO_LNIATA : 8 Digit code identifying a terminal address in Amadeus
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • CITY_IDENTIFIER : 5 character code identifying a City Code
    Its data type is CHAR (Character String) with field length 5
  • AIRLINE_CODE : Airline Code definition
    Its data type is CHAR (Character String) with field length 5
  • NUM_PSGR_PNR
  • NUM_PSGR_IMR
  • NON_HOMOGEN_IND
    Its data type is CHAR (Character String) with field length 1
  • BOOKING_OFFICE : Code identifying an office id in Amadeus
    Its data type is CHAR (Character String) with field length 12
  • BOOKING_IATA_NUM : IATA Number of office id.
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • TICKETING_OFFICE : Code identifying an office id in Amadeus
    Its data type is CHAR (Character String) with field length 12
  • TICKETING_IATA : IATA Number of office id.
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • TKT_OFFICE_SUBD
    Its data type is CHAR (Character String) with field length 2
  • TKT_COUPON_IDENT
    Its data type is CHAR (Character String) with field length 15
  • PNR_CREATION_DAT
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PNR_CREATION_TIM
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PNR_CHANGE_DATE
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PNR_CHANGE_TIME
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AIR_CREATION_DAT
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AIR_CREATION_TIM
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AGENCY_ACCOUNT
    Its data type is CHAR (Character String) with field length 10
  • ORDER_NUMBER : Dummy for B20 int1 (Local Everywhere)
    Its data type is CHAR (Character String) with field length 10
  • AMADEUS_ENTRY
    Its data type is CHAR (Character String) with field length 20