FTPT_FLIGHT SAP table for – Travel Request Item – Flight Service

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

SAP FTPT_FLIGHT table

Table FTPT_FLIGHT technical data

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

SAP FTPT_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_FLIGHT 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 : Travel service item number of flight
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • AIRLINE : Airline
    Its data type is CHAR (Character String) with field length 3
  • FLIGHT_NR : Flight Number
    Its data type is CHAR (Character String) with field length 6
  • DATE_DEP : Flight departure date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_DEP : Flight departure time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_DEP : Departure Location
    Its data type is CHAR (Character String) with field length 3
  • TERM_DEP : Terminal Code (Departure)
    Its data type is CHAR (Character String) with field length 2
  • GATE_DEP : Flight departure terminal
    Its data type is CHAR (Character String) with field length 6
  • DATE_ARR : Flight arrival date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_ARR : Flight arrival time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_ARR : Flight Arrival Location
    Its data type is CHAR (Character String) with field length 3
  • TERM_ARR : Terminal code (arrival)
    Its data type is CHAR (Character String) with field length 2
  • GATE_ARR : Flight arrival terminal
    Its data type is CHAR (Character String) with field length 6
  • RESTRICT_FARE : Restricted airfare
    Its data type is CHAR (Character String) with field length 1
  • CABIN : Flight Cabin Class
    Its data type is CHAR (Character String) with field length 1
  • RBD : Flight Booking Code (RBD)
    Its data type is CHAR (Character String) with field length 1
  • MARRIED : Married Segments
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • STATUS : Flight 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
  • PNR_NR : Line Number of Flight in PNR (if PNR available)
  • ELEC_TKT : Electronic ticketing for flight is possible
    Its data type is CHAR (Character String) with field length 1
  • PARTICIPATION : Access type code: Airline
    Its data type is CHAR (Character String) with field length 5
  • CHECKIN_TIME : Check-in time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • OP_AIRLINE : Airline
    Its data type is CHAR (Character String) with field length 3
  • PROFILE : Travel Profile
    Its data type is CHAR (Character String) with field length 8
  • PROFITEM : Trip rule
    Its data type is CHAR (Character String) with field length 8
  • KZTKT : Trip Activity Type
    Its data type is CHAR (Character String) with field length 1
  • SPECHID : Class rule
    Its data type is CHAR (Character String) with field length 8
  • PRIORITY : Priority of trip rule
    Its data type is CHAR (Character String) with field length 1
  • HIGHEST_PRIORITY : Priority of trip rule
    Its data type is CHAR (Character String) with field length 1
  • BEST_BUY_RC : Indicator: Use ‘Best Buy’ Reason Codes
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Reason Code
  • REASON_CODE : Reason Code
    Its data type is CHAR (Character String) with field length 2
  • REASON_TEXT : Reason Text
    Its data type is CHAR (Character String) with field length 132