FTPT_FLIGHT_PREF SAP table for – Flight service preferences of a travel plan

Here we would like to draw your attention to FTPT_FLIGHT_PREF 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_PREF is a SAP standard transp table used for storing Flight service preferences of a travel plan related data in SAP. It comes under the package PTRP.

SAP FTPT_FLIGHT_PREF table

Table FTPT_FLIGHT_PREF technical data

TableFTPT_FLIGHT_PREF
Data storingFlight service preferences of a travel plan
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_FLIGHT_PREF 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_PREF 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
  • MEAL_CODE : Preferred Meal on Flight
    Its data type is CHAR (Character String) with field length 4
  • FREQ_CODE : Provider to which the SSR refers
    Its data type is CHAR (Character String) with field length 3
  • HDCAP_CODE : Seating Request: Suitable for Challenged Person
    Its data type is CHAR (Character String) with field length 1
  • MEDIC_CODE : Seating Request: Medical Care
    Its data type is CHAR (Character String) with field length 1
  • MINOR_CODE : Seating requisition: unaccompanied minor
    Its data type is CHAR (Character String) with field length 1
  • INFANT_CODE : Seating requisition: child’s seat
    Its data type is CHAR (Character String) with field length 1
  • AIRLINE_CODE : Airline
    Its data type is CHAR (Character String) with field length 3
  • STATUS_CODE : SSR status
    Its data type is CHAR (Character String) with field length 2
  • TEXT_INFO : Text description for an SSR element
    Its data type is CHAR (Character String) with field length 132
  • LINENUMBER : Line number of SSR in the itinerary
  • FREQ_CARD_CODE : SSR Frequent Flyer Affiliated Airline Code
    Its data type is CHAR (Character String) with field length 3
  • FREQ_CARD_USAGE : Type of Usage for Frequent Flyer Card
    Its data type is CHAR (Character String) with field length 1
  • FREQ_CARD_NUMBER : Frequent Flyer Card Number
    Its data type is CHAR (Character String) with field length 21
  • HDCAP_DESCR : Description of challenge
    Its data type is CHAR (Character String) with field length 120
  • MEDIC_DESCR : Description of medical care
    Its data type is CHAR (Character String) with field length 120
  • BLIND : Challenge: Blindness (for OSI information)
    Its data type is CHAR (Character String) with field length 1
  • DEAF : Challenge: Deafness (for OSI information)
    Its data type is CHAR (Character String) with field length 1