FTPT_PLANHISTORY SAP table for – General Plan Data

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

SAP FTPT_PLANHISTORY table

Table FTPT_PLANHISTORY technical data

TableFTPT_PLANHISTORY
Data storingGeneral Plan Data
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP_ADDON
Delivery ClassA – Application table (master and transaction data)
ComponentEA-HRGXX
Table CategoryTRANSP

SAP FTPT_PLANHISTORY 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_PLANHISTORY 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
  • PLAN_VERSION : Travel Plan Version 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