FTPT_IMR_TRAIN SAP table for – IMR – Train

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

SAP FTPT_IMR_TRAIN table

Table FTPT_IMR_TRAIN technical data

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

SAP FTPT_IMR_TRAIN 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_TRAIN 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 : Structure to describe Flight information
  • TKT_SEG_IND
    Its data type is CHAR (Character String) with field length 1
  • TRAIN_SEG_TYPE
    Its data type is CHAR (Character String) with field length 3
  • TATTOO_NUMBER : Amadeus unique identifier for each element stored in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISPLAY_NUMBER : Amadeus unique identifier for each element displayed in PNR
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • STOPOVER_IND
    Its data type is CHAR (Character String) with field length 1
  • DEP_CITY : 5 character code identifying a City Code
    Its data type is CHAR (Character String) with field length 5
  • DEP_CITY_TEXT
    Its data type is CHAR (Character String) with field length 20
  • ARR_CITY : 5 character code identifying a City Code
    Its data type is CHAR (Character String) with field length 5
  • ARR_CITY_TEXT
    Its data type is CHAR (Character String) with field length 20
  • PROD_CODE : SAP internal product code (external interface)
    Its data type is CHAR (Character String) with field length 2
  • PROD_CODE_TEXT
    Its data type is CHAR (Character String) with field length 30
  • PROD_NUMBER
    Its data type is CHAR (Character String) with field length 10
  • CLASS_OF_SERVICE : Class type definition
    Its data type is CHAR (Character String) with field length 2
  • SPACE_HELD_TEXT
    Its data type is CHAR (Character String) with field length 30
  • EQP_TYPE_TEXT
    Its data type is CHAR (Character String) with field length 30
  • ACCOMODATION
    Its data type is CHAR (Character String) with field length 30
  • DEP_DATE
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DEP_TIME
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ARR_DATE
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ARR_TIME
    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
  • TARIFF : Tarif
    Its data type is CHAR (Character String) with field length 4
  • PAST_DATE_IND
    Its data type is CHAR (Character String) with field length 1