FTPT_REQ_ADVANCE SAP table for – Travel Request Advance

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

SAP FTPT_REQ_ADVANCE table

Table FTPT_REQ_ADVANCE technical data

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

SAP FTPT_REQ_ADVANCE 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_REQ_ADVANCE table.

  • 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
  • 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
  • ADVANCE : Sequential number of advance in travel request
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Trip Advance
  • VORSC : Amount of Advance
    Its data type is CURR (Currency Field) with field length 10
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KURSV : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • FFACT : Ratio for the “from” currency units
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TFACT : Ratio for the “to” currency units
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • VORHW : Advance Amount in Settlement Currency
    Its data type is CURR (Currency Field) with field length 10
  • KASSA : Cash Payment Indicator
    Its data type is CHAR (Character String) with field length 1
  • DATVS : Date of Advance Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYCURR : Accounting Currency of Expense Receipt or Advance
    Its data type is CUKY (Currency key for a currency field) with field length 5