1. SAP Tutorial
  2. FI Module

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

    • FTPT_IMR related tables

    • FTPT_IMR_SSRSEG : IMR: Assignment Table Special Serv.Request to Flight Segment
    • FTPT_IMR_SEATSEG : IMR: Table for Assignment of Seats to Flight Segments
    • FTPT_IMR : IMR – General Information
    • FTPT_IMR_FAREDAT : IMR – Price Data Description
    • FTPT_IMR_MANUAL : IMR – Manually Created Segments
    • FTPT_IMR_FSP : IMR: Assignment Table Passengers-Segments-TST
    • FTPT_IMR_SEATS : IMR: Seating Information
    • FTPT_IMR_TRAIN : IMR – Train
    • FTPT_IMR_FAREELM : IMR: Passenger Information for Price Determination
    • FTPT_IMR_NAMES : IMR : Name
    • FTPT_IMR_SSRS : IMR: Information on Special Service Requirements
    • FTPT_IMR_FQTV : IMR: Customer Programs
    • FTPT_IMR_DETAIL : IMR – Detail Information
    • FTPT_IMR_RECLOC : IMR – Booking Rate
    • FTPT_IMR_FQTVSEG : IMR: Assignment Table Customer Programs to Flight Segments
    • FTPT_IMR_HTL_DIR : IMR – Hotel (Direct Access)
    • FTPT_IMR_FOPSEG : IMR: Assignment Table Payment Method to Flight Segments
    • FTPT_IMR_FELMSEG : IMR: Table for Assignment of Ticket to Flight Segment
    • FTPT_IMR_TKTSEG : IMR: Table for Assignment of Ticket to Flight Segment
    • FTPT_IMR_SURFACE : IMR – Other Segments of Trip as Flights

    Related References

    Related Tutorials

    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...

    FTPT_IMR_FOP SAP table for – IMR : Information on Payment Method

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

    FTPT_IMR_FAREELM SAP table for – IMR: Passenger Information for Price Determination

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

    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_TKT SAP table for – IMR : Ticket Information

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

    FTPT_IMR_TRAIN SAP table for – IMR – Train

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

    «
    »