FTPT_PNR_ADDRESS SAP table for – PNR delivery / billing addresses

Here we would like to draw your attention to FTPT_PNR_ADDRESS 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_PNR_ADDRESS is a SAP standard transp table used for storing PNR delivery / billing addresses related data in SAP. It comes under the package PTRP.

SAP FTPT_PNR_ADDRESS table

Table FTPT_PNR_ADDRESS technical data

TableFTPT_PNR_ADDRESS
Data storingPNR delivery / billing addresses
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_PNR_ADDRESS 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_PNR_ADDRESS 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
  • VARIANT : 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
  • PNR_NR : Line number in PNR
    Its a key field.
  • FIRSTNAME : First Name
    Its data type is CHAR (Character String) with field length 40
  • SURNAME : Name
    Its data type is CHAR (Character String) with field length 40
  • ADDRESS : Street and number
    Its data type is CHAR (Character String) with field length 60
  • ZIPCODE : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • CITY_CODE : City
    Its data type is CHAR (Character String) with field length 40
  • COUNTRY : Country
    Its data type is CHAR (Character String) with field length 3
  • .INCLU–AP : Append Structure for Structure FTPT_PNR_ADDRESS
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3