FTPT_TRAIN SAP table for – Travel Request Item – Train Service

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

SAP FTPT_TRAIN table

Table FTPT_TRAIN technical data

TableFTPT_TRAIN
Data storingTravel Request Item – Train Service
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_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_TRAIN table.

  • .INCLUDE : Key to travel plan table
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERNR : Personnel Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • REINR : Trip Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • PLANNR : Travel Plan Number (Sequential Number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • VARIANT : Plan variant number (sequential number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • VARIANTVRS : Version of travel plan
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • ITEM : Travel Request Item Number (Sequential Number)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SERVICE : Train number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • PROVIDER : Train provider
    Its data type is CHAR (Character String) with field length 3
  • TRAIN_NR : Train number
    Its data type is CHAR (Character String) with field length 6
  • COMPARTMENT_NR : Compartment no.
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • DATE_DEP : Start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_DEP : Start time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_DEP : Departure loc.
    Its data type is CHAR (Character String) with field length 3
  • GATE_DEP : Departure platform
    Its data type is CHAR (Character String) with field length 6
  • DATE_ARR : Arrival date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_ARR : Arrival time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_ARR : Arrival Location
    Its data type is CHAR (Character String) with field length 3
  • GATE_ARR : Arrival platform
    Its data type is CHAR (Character String) with field length 6
  • CLASS : Train class
    Its data type is CHAR (Character String) with field length 2
  • COMPART_CLASS : Compart. class
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Status
    Its data type is CHAR (Character String) with field length 2
  • TEMPLATE : Template indicator
    Its data type is CHAR (Character String) with field length 1
  • COACH_NR : Coach number
    Its data type is CHAR (Character String) with field length 4
  • SEAT_NR : Seat Number
    Its data type is CHAR (Character String) with field length 4
  • SEAT_PRICE : Price of Seat Reservation
    Its data type is CURR (Currency Field) with field length 10
  • SEAT_PRICE_CURR : Currency for Seat Reservation Price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RES_INFO : Reservation Information
    Its data type is CHAR (Character String) with field length 50
  • SUPPLEMENT : Supplement for Train Connection
    Its data type is CURR (Currency Field) with field length 10
  • SUPPLEMENT_CURR : Currency for Supplement (Train)
    Its data type is CUKY (Currency key for a currency field) with field length 5