FTPT_PLAN SAP table for – General Plan Data

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

SAP FTPT_PLAN table

Table FTPT_PLAN technical data

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

SAP FTPT_PLAN 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_PLAN 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
  • DATE_BEG : Start Date of Travel Plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_BEG : Start Time of Travel Plan
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATE_END : End date of travel plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIME_END : End time of travel plan
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DESTINATION : Destination of travel plan
    Its data type is CHAR (Character String) with field length 59
  • REASON : Reason for Trip (for example, customer/requisitioner)
    Its data type is CHAR (Character String) with field length 59
  • ACTIVITY_TYPE : Trip Activity Type
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Travel Plan Status
    Its data type is CHAR (Character String) with field length 1
  • CHANGED_BY : User Name
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT_DATE : System Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGED_AT_TIME : System Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6