FTPT_ITEM SAP table for – Travel Service Request Item

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

SAP FTPT_ITEM table

Table FTPT_ITEM technical data

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

SAP FTPT_ITEM 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_ITEM 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
  • USERG : User Grouping for Travel Planning
    Its data type is CHAR (Character String) with field length 2
  • CATEGORY : Enterprise-Specific Travel Service Category
    Its data type is CHAR (Character String) with field length 1
  • REAL_CAT : Travel service category
    Its data type is CHAR (Character String) with field length 1
  • DATE_BEG : Start Date of Request Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_BEG : Start Time for Request Item
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_BEG : Starting Location of Request Item
    Its data type is CHAR (Character String) with field length 3
  • DATE_END : End date of request item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_END : End time for request item
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LOC_END : End Location of Request Item
    Its data type is CHAR (Character String) with field length 3
  • CLASS : Request item class
    Its data type is CHAR (Character String) with field length 2
  • PRICE_AVAI : Price at availability query of request item
    Its data type is CURR (Currency Field) with field length 10
  • PRICE_APPR : Price at approval of request item
    Its data type is CURR (Currency Field) with field length 10
  • PRICE : Price of request item
    Its data type is CURR (Currency Field) with field length 10
  • CURRENCY : Currency of request item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REF_ITEM : Reference to another request (return flight)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • STATUS : Status of Request Item
    Its data type is CHAR (Character String) with field length 1
  • TEMPLATE : Template indicator
    Its data type is CHAR (Character String) with field length 1
  • BELNR : Document Number
    Its data type is CHAR (Character String) with field length 3
  • FIRMA : Paid by Company
    Its data type is CHAR (Character String) with field length 1
  • DEP_ARR : Arrival/Departure time
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Append for FTPT_ITEM
  • RES_SYSTEM : Reservation System
    Its data type is CHAR (Character String) with field length 3