PTRV_SREC SAP table for – Trip Statistics – Receipts

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

SAP PTRV_SREC table

Table PTRV_SREC technical data

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

SAP PTRV_SREC 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_SREC 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
  • RECEIPTNO : Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • SEQNO : Sequential number for receipts
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • DED_FLAG : Deduction Indicator
    Its data type is CHAR (Character String) with field length 1
  • PAID_COM : Paid by Company
    Its data type is CHAR (Character String) with field length 1
  • EXP_TYPE : Travel Expense Type
    Its data type is CHAR (Character String) with field length 4
  • REC_AMOUNT : Amount on Individual Receipt
    Its data type is CURR (Currency Field) with field length 13
  • REC_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REC_RATE : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • LOC_AMOUNT : Receipt amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • LOC_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TAX_CODE : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • REC_DATE : Receipt Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SHORTTXT : Short Receipt Information
    Its data type is CHAR (Character String) with field length 10
  • ABOVE_LIMIT : Customizing Limit for Travel Expense Type Exceeded
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Enhancement of Receipt Statistics
  • PAPER_RECEIPT : Paper Receipt Exists
    Its data type is CHAR (Character String) with field length 1
  • RECEIPT_OK : Expense Receipt Checked
    Its data type is CHAR (Character String) with field length 1
  • PAYOT : Service Provider
    Its data type is CHAR (Character String) with field length 2
  • PAPER_MISSING : Required Paper Receipt Is Missing
    Its data type is CHAR (Character String) with field length 1
  • RECEIPT_NO : Invoice Number of Original Receipt
    Its data type is CHAR (Character String) with field length 16
  • RECEIPT_ITEM : Number of Invoice Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REC_FWSTE : Tax amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • LOC_FWSTE : Tax amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • VAT_POSTING_TYPE : Reporting and Posting of VAT Amount
    Its data type is CHAR (Character String) with field length 1
  • VAT_SERVICE_CODE : Type of Goods and Services
    Its data type is CHAR (Character String) with field length 3
  • VAT_SERVICE_DESC : Description of Goods and Services
    Its data type is CHAR (Character String) with field length 100
  • VAT_STATUS : Status of Data for VAT Refund
    Its data type is CHAR (Character String) with field length 1
  • VAT_CHANGED_MAN : VAT Amount Changed Manually
    Its data type is CHAR (Character String) with field length 1