FTPT_IMR_FSP SAP table for – IMR: Assignment Table Passengers-Segments-TST

Here we would like to draw your attention to FTPT_IMR_FSP 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_FSP is a SAP standard transp table used for storing IMR: Assignment Table Passengers-Segments-TST related data in SAP. It comes under the package PTRI.

SAP FTPT_IMR_FSP table

Table FTPT_IMR_FSP technical data

TableFTPT_IMR_FSP
Data storingIMR: Assignment Table Passengers-Segments-TST
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRI
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_IMR_FSP 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_FSP 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_NB_PSGR : Index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • RUNNING_NB_FARE : Index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • RUNNING_NB_FL : Index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PRIMARY_CODE
    Its data type is CHAR (Character String) with field length 3
  • FARE_BASIS : Fare Basis Code – Identification for tariff rules
    Its data type is CHAR (Character String) with field length 8
  • TKTDES : Fare Basis Code – Identification for tariff rules
    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
  • BASE_FARE
    Its data type is CHAR (Character String) with field length 9
  • NVB : Validity beginning of flight segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NVA : Validity end of flight segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BAG_ALLOW
    Its data type is CHAR (Character String) with field length 3