FTPT_IMR_FLIGHT SAP table for – IMR – Flight

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

SAP FTPT_IMR_FLIGHT table

Table FTPT_IMR_FLIGHT technical data

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

SAP FTPT_IMR_FLIGHT 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_FLIGHT 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 : Flight Information
  • TKT_SEG_IND
    Its data type is CHAR (Character String) with field length 1
  • FLIGHT_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_NB : Amadeus unique identifier for each element stored in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISPLAY_NB : Amadeus unique identifier for each element displayed in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPEN_SEG_IND
    Its data type is CHAR (Character String) with field length 1
  • STOPOVER_IND
    Its data type is CHAR (Character String) with field length 1
  • DEPARTURE_ARPT : Airport code definition
    Its data type is CHAR (Character String) with field length 5
  • ARRIVAL_ARPT : Airport code definition
    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
  • FLIGHT_NB : Flight number definition
    Its data type is CHAR (Character String) with field length 5
  • CLASS_OF_SERVICE : Class type definition
    Its data type is CHAR (Character String) with field length 2
  • CLASS_OF_BOOKING : Class type definition
    Its data type is CHAR (Character String) with field length 2
  • DEPARTURE_DATE
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DEPARTURE_TIME
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ARRIVAL_DATE : Arrival Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ARRIVAL_TIME : Time of Receipt
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RAW_STATUS_CODE : Raw descrition of amadeus Status Code with Number in Party
    Its data type is CHAR (Character String) with field length 5
  • MEAL_CODE : Amadeus Meal Code
    Its data type is CHAR (Character String) with field length 3
  • NB_OF_STOPS
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • EQUIPMENT_TYPE : Amadeus equipment type code
    Its data type is CHAR (Character String) with field length 3
  • ENTERTAIN_CODE
    Its data type is CHAR (Character String) with field length 1
  • BAG_ALLOWANCE : Baggage allowance description
    Its data type is CHAR (Character String) with field length 3
  • CHECK_IN_TERM : Terminal Code
    Its data type is CHAR (Character String) with field length 2
  • CHECK_IN_TIME
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • E_TKT_IND
    Its data type is CHAR (Character String) with field length 1
  • FLIGHT_DURATION : Flight duration in Format : HH:MM
    Its data type is CHAR (Character String) with field length 5
  • NON_SMOKING_IND
    Its data type is CHAR (Character String) with field length 1
  • SHARED_COMM_CXR
    Its data type is CHAR (Character String) with field length 50
  • TOUR_SEGMENT_TAG
    Its data type is CHAR (Character String) with field length 6
  • FLOWN_IND
    Its data type is CHAR (Character String) with field length 1