FTPT_FLIGHT_TSTK SAP table for – Ticket Information

Here we would like to draw your attention to FTPT_FLIGHT_TSTK 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_TSTK is a SAP standard transp table used for storing Ticket Information related data in SAP. It comes under the package PTRP.

SAP FTPT_FLIGHT_TSTK table

Table FTPT_FLIGHT_TSTK technical data

TableFTPT_FLIGHT_TSTK
Data storingTicket Information
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_FLIGHT_TSTK 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_TSTK 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
  • VARIANTE : 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
  • TICKET : Ticket
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • PLATING_CARRIER : Plating Carrier
    Its data type is CHAR (Character String) with field length 3
  • LOCAL_TST : Ticket element is local (not in booking system)
    Its data type is CHAR (Character String) with field length 1
  • LAST_DATE : Last Ticketing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TICKET_MODE : Ticketing Mode of Airline Ticket
    Its data type is CHAR (Character String) with field length 1
  • SALES_IND : Sales Type of Airline Ticket Rate
    Its data type is CHAR (Character String) with field length 4
  • FARE : Basic rate for flight ticket without tax
    Its data type is CURR (Currency Field) with field length 10
  • FARE_CURR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ISSUE_TYPE : Airline Ticket Issue
    Its data type is CHAR (Character String) with field length 1
  • TOTAL_FARE_PAID : Total price of flight ticket
    Its data type is CURR (Currency Field) with field length 10
  • TOTAL_FARE_CURR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REBATE_FARE : Discount price of flight ticket
    Its data type is CURR (Currency Field) with field length 10
  • REBATE_FARE_CURR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TICKETNUMBER : Ticket Number
    Its data type is NUMC (Character String with Digits Only) with field length 15
  • TICKETTYPE : Ticket Type
    Its data type is CHAR (Character String) with field length 1
  • INFO : Ticket Information
    Its data type is CHAR (Character String) with field length 77
  • TST_FARE_TYPE : Fare Type (Normal, Negotiated, Etc.)
    Its data type is CHAR (Character String) with field length 2
  • FULL_FARE : Unrestricted Rate in the same Cabin Class
    Its data type is CURR (Currency Field) with field length 10
  • FULL_FARE_CURR : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU–AP : Append Structure for FTPT_FLIGHT_TSTK
  • .INCLUDE : Lowest-Cost Alternative Airfare Rate
  • CHEAPEST_FARE : Lowest-Cost Alternative Airfare Rate
    Its data type is CURR (Currency Field) with field length 10
  • CHEAPEST_FARE_C : Currency of Lowest-Cost Alternative Airfare Rate
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Booking Data for Low-Cost Carrier
  • LCC : Low-Cost Carrier
    Its data type is CHAR (Character String) with field length 1
  • URL_LCC : Low-Cost Carrier: URL for Web Page
    Its data type is CHAR (Character String) with field length 255