FTPT_SYNC_DATA SAP table for – Data Synchronization: SAP – External System

Here we would like to draw your attention to FTPT_SYNC_DATA 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_SYNC_DATA is a SAP standard transp table used for storing Data Synchronization: SAP – External System related data in SAP. It comes under the package PTRP_ADDON.

SAP FTPT_SYNC_DATA table

Table FTPT_SYNC_DATA technical data

TableFTPT_SYNC_DATA
Data storingData Synchronization: SAP – External System
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP_ADDON
Delivery ClassA – Application table (master and transaction data)
ComponentEA-HRGXX
Table CategoryTRANSP

SAP FTPT_SYNC_DATA 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_SYNC_DATA 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
  • VARIANTE : 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
  • SERVICE : Travel service number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • RUNNING_NUMBER : Index
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • REAL_CAT : Travel service category
    Its data type is CHAR (Character String) with field length 1
  • SYNC_CODE : Synchronization Data Code
    Its data type is CHAR (Character String) with field length 16
  • SYNC_DATA : Synchronization data
    Its data type is CHAR (Character String) with field length 32