FTPT_VARIANT SAP table for – Table of Travel Plan Variants

Here we would like to draw your attention to FTPT_VARIANT 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_VARIANT is a SAP standard transp table used for storing Table of Travel Plan Variants related data in SAP. It comes under the package PTRP.

SAP FTPT_VARIANT table

Table FTPT_VARIANT technical data

TableFTPT_VARIANT
Data storingTable of Travel Plan Variants
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_VARIANT 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_VARIANT 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
  • NAME : Variant description
    Its data type is CHAR (Character String) with field length 30
  • PRICE : Variant price
    Its data type is CURR (Currency Field) with field length 10
  • CURRENCY : Currency of variant price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • STATUS : Variant status
    Its data type is CHAR (Character String) with field length 1
  • PRICING_STATUS : Status of variant price request
    Its data type is CHAR (Character String) with field length 1
  • INFO_TXT : Information text for variant status
    Its data type is CHAR (Character String) with field length 132
  • TEMPLATE : Template indicator
    Its data type is CHAR (Character String) with field length 1
  • BOOK_REQUEST : Booking flag was started
    Its data type is CHAR (Character String) with field length 1
  • REC_LOCATOR : Passenger Name Record Locator
    Its data type is CHAR (Character String) with field length 20
  • DB_ORDER_NR : Passenger Name Record Locator
    Its data type is CHAR (Character String) with field length 20
  • FLIGHT_CANCELED : Indicator: Flight Cancelation Exists
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Travel Agency Status
  • AGENCYSTATUS : Travel Agency Status
    Its data type is CHAR (Character String) with field length 1