FTPT_REQ_ACCOUNT SAP table for – Travel Request Cost Assignment

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

SAP FTPT_REQ_ACCOUNT table

Table FTPT_REQ_ACCOUNT technical data

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

SAP FTPT_REQ_ACCOUNT 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_ACCOUNT 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
  • ACCOUNT : Sequential number of cost distribution in travel request
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERCENT : Percentage of Cost Distribution
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • .INCLUDE : Assignment Values for Travel/HR Objects
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • KSTRG : Cost Object
    Its data type is CHAR (Character String) with field length 12
  • POSNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • VORNR : Operation/Activity Number
    Its data type is CHAR (Character String) with field length 4
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PRZNR : Business Process
    Its data type is CHAR (Character String) with field length 12
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FIPOS : Commitment Item
    Its data type is CHAR (Character String) with field length 14
  • GEBER : Fund
    Its data type is CHAR (Character String) with field length 10
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • LSTNR : Activity Number
    Its data type is CHAR (Character String) with field length 18
  • LTLST : Activity Type
    Its data type is CHAR (Character String) with field length 6
  • SBUKR : Company Code
    Its data type is CHAR (Character String) with field length 4
  • SGSBR : Business Area
    Its data type is CHAR (Character String) with field length 4
  • SKOST : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • LSTAR : Activity Type
    Its data type is CHAR (Character String) with field length 6
  • EXBEL : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • OTYPE : Object Type
    Its data type is CHAR (Character String) with field length 2
  • STELL : Job
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • POHRS : Number of Hours for Activity Allocation/External Services
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • DART : Service Type (Public Service Germany)
    Its data type is CHAR (Character String) with field length 2
  • UDART : Service Category (Public Service Germany)
    Its data type is CHAR (Character String) with field length 2
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • SGEBER : Sender fund
    Its data type is CHAR (Character String) with field length 10
  • SFKBER : Sending Functional Area
    Its data type is CHAR (Character String) with field length 16
  • SGRANT_NBR : Sender Grant
    Its data type is CHAR (Character String) with field length 20
  • PROJECT_GUID : Project GUID (cProjects)
    Its data type is RAW (Byte string) with field length 16
  • PROJECT_EXT_ID : Project Number (cProjects)
    Its data type is CHAR (Character String) with field length 24
  • TASK_ROLE_GUID : Task GUID (cProjects)
    Its data type is RAW (Byte string) with field length 16
  • TASK_ROLE_EXT_ID : TaskRole Number (cProjects)
    Its data type is CHAR (Character String) with field length 24
  • OBJECT_TYPE : Object Type (cProjects)
    Its data type is CHAR (Character String) with field length 3
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10