1. SAP Tutorial
  2. FI Module

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

    • FTPT_IMR_FLIGHT related tables

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

    Related References

    Related Tutorials

    FTPT_IMR_FELMSEG SAP table for – IMR: Table for Assignment of Ticket to Flight Segment

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

    FTPT_IMR_TKTSEG SAP table for – IMR: Table for Assignment of Ticket to Flight Segment

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

    FTPT_IMR_SEATSEG SAP table for – IMR: Table for Assignment of Seats to Flight Segments

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

    FTPT_IMR_FOPSEG SAP table for – IMR: Assignment Table Payment Method to Flight Segments

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

    FTPT_IMR_FQTVSEG SAP table for – IMR: Assignment Table Customer Programs to Flight Segments

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

    FTPT_IMR_SSRSEG SAP table for – IMR: Assignment Table Special Serv.Request to Flight Segment

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

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

    «
    »