PTRV_SHDR SAP table for – Trip Statistics – Trip Amounts

Here we would like to draw your attention to PTRV_SHDR 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). PTRV_SHDR is a SAP standard transp table used for storing Trip Statistics – Trip Amounts related data in SAP. It comes under the package PTRA.

SAP PTRV_SHDR table

Table PTRV_SHDR technical data

TablePTRV_SHDR
Data storingTrip Statistics – Trip Amounts
ModuleFI
Sub ModuleFI-TV-COS
SAP PackagePTRA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP PTRV_SHDR 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 PTRV_SHDR table.

  • .INCLUDE : Trip Statistics – Key Fields
    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
  • PERIO : Trip Period Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SEQNO : Sequential number for trip totals
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Statistic Data of a Trip
  • ADDIT_AMNT : Additional Amount of a Trip (Taxable for Employee)
    Its data type is CURR (Currency Field) with field length 13
  • SUM_REIMBU : Reimbursement Amount for a Trip
    Its data type is CURR (Currency Field) with field length 13
  • SUM_ADVANC : Total Advances for a Trip
    Its data type is CURR (Currency Field) with field length 13
  • SUM_PAYOUT : Payment Amount
    Its data type is CURR (Currency Field) with field length 13
  • SUM_PAIDCO : Travel Expenses Paid by Company
    Its data type is CURR (Currency Field) with field length 13
  • TRIP_TOTAL : Total Cost of Trip
    Its data type is CURR (Currency Field) with field length 13
  • PD_FOOD : Reimbursement Amount (Total) for Meals per Diems
    Its data type is CURR (Currency Field) with field length 13
  • PD_HOUSING : Reimbursement Amount (Total) for Accommodations per Diems
    Its data type is CURR (Currency Field) with field length 13
  • PD_MILEAGE : Reimbursement Amount (Total) for Travel Flat Rates
    Its data type is CURR (Currency Field) with field length 13
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • M_TOTAL : Total Miles/Kilometers
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • TRIPDUR : Trip Duration in Days
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • CHNGDATE : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHNGTIME : Time of Last Change
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • .INCLU–AP : Additional Fields for Public Sector
  • TXF_FOOD : Total of Tax-Exempt Paid Meals per Diems
    Its data type is CURR (Currency Field) with field length 13