FTPT_REQUEST SAP table for – Travel Plan Requests

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

SAP FTPT_REQUEST table

Table FTPT_REQUEST technical data

TableFTPT_REQUEST
Data storingTravel Plan Requests
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_REQUEST 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_REQUEST 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
  • REQUESTVRS : Version of travel request
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • PLAN_REQUEST : Plan Request Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • REQUEST : Request number (sequential number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • ITINERARY_NUMBER : Number of trip segment
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DATE_BEG : Beginning Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_BEG : Start Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATE_END : End Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_END : End Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOCATION_BEG : Starting location of trip segment
    Its data type is CHAR (Character String) with field length 59
  • COUNTRY_BEG : Country Key
    Its data type is CHAR (Character String) with field length 3
  • LOCATION_END : End location of trip segment
    Its data type is CHAR (Character String) with field length 59
  • COUNTRY_END : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REQUEST_TYPE : Travel Item Type
    Its data type is CHAR (Character String) with field length 2
  • DEP_ARR : Arrival/Departure time
    Its data type is CHAR (Character String) with field length 1
  • ITEM : Travel Request Item Number (Sequential Number)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REASON : Reason for trip (e.g. customer/requisitioner)
    Its data type is CHAR (Character String) with field length 17
  • ACTIVITY : Trip Activity Type
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Enhancement for FTPT_REQUEST in Extension System
  • FIRST_TCODE : Transaction Code
    Its data type is CHAR (Character String) with field length 20
  • .INCLU–AP : Append Structure for FTPT_REQUEST in Extension System
  • .INCLUDE : Address and Geocoordinates
  • .INCLUDE : Travel Web Interface: Addresses
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • CITY : City
    Its data type is CHAR (Character String) with field length 40
  • POST_CODE : City postal code
    Its data type is CHAR (Character String) with field length 10
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM : House Number
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Travel Web Interface: Geocoding
  • LATITUDE : Geo location latitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LONGITUDE : Geo location longitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • IATA_FLIGHT : IATA Location for Airport
    Its data type is CHAR (Character String) with field length 3
  • IATA_GROUND : IATA Location for Hotel
    Its data type is CHAR (Character String) with field length 3
  • TRAIN_STATION : International Unique Train Station Number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10