1. SAP Tutorial
  2. FI Module

PTRV_PERIO SAP table for – Period Data of a Trip

Here we would like to draw your attention to PTRV_PERIO 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_PERIO is a SAP standard transp table used for storing Period Data of a Trip related data in SAP. It comes under the package PTRA.

SAP PTRV_PERIO table

Table PTRV_PERIO technical data

TablePTRV_PERIO
Data storingPeriod Data of a Trip
ModuleFI
Sub ModuleFI-TV-COS
SAP PackagePTRA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP PTRV_PERIO 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_PERIO table.

  • .INCLUDE : Key for Travel Expenses Table PTRV_PERIO
    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
  • PDVRS : Sequential Number of Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Structure of transp. table PTRV_PERIO
  • HDVRS : Sequential Number of Travel Expenses Table THEADER
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PDATV : Beginning Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PUHRV : Beginning Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PDATB : End Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PUHRB : End Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DRUCK : Trip Print Status
    Its data type is CHAR (Character String) with field length 1
  • ANTRG : Travel Request or Trip Approved (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • ABREC : Open / To be Settled / Settled (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • UEBLG : HR Payroll Transfer (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • UEBRF : FI Transfer (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • UEBDT : Data Medium Exchange Transfer (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • TLOCK : Indicator: Trip locked
    Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ABRJ1 : Payroll Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ABRP1 : Payroll Period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERM1 : Period modifier
    Its data type is CHAR (Character String) with field length 2
  • ABKR1 : Payroll Area
    Its data type is CHAR (Character String) with field length 2
  • BEGP1 : Start of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENDP1 : End of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ABRJ2 : Payroll Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ABRP2 : Payroll Period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERM2 : Period modifier
    Its data type is CHAR (Character String) with field length 2
  • ABKR2 : Payroll Area
    Its data type is CHAR (Character String) with field length 2
  • BEGP2 : Start of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENDP2 : End of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACCDT : Trip Settlement Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACCTM : Trip Settlement Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RUNID : Sequential number of posting run
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • VERPA : Per-Diem Accounting for Meals
    Its data type is CHAR (Character String) with field length 1
  • UEBKZ : Per-Diem Accounting for Accommodations
    Its data type is CHAR (Character String) with field length 1
  • ANUEP : Number of Overnight Stays for Per-Diem Settlement
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • NO_MILES : Indicator: No repeat of travel costs accounting
    Its data type is CHAR (Character String) with field length 1
  • LSTAY : Meals per diem reduct. for longer stay at same place of work
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Enhancement of Structure of Travel Expenses Table PTRV_PERIO
  • TR_DOPP_ANZAHL : Daily Return: No. of Days with Outb. and Return Trip
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TR_EINF_ANZAHL : Daily Return: No. of Days only with Outb./ or Return Trip
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TR_ENTFERNUNG : Daily Return: Distance fr. Residence to New Place of Work
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VU_EA_DOPP_ANZ : Own Contribution: No. of Days with Outb./Return Trip b. Move
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • VU_EA_EINF_ANZ : Own Contribution: No. of Days wth Outb./Return Trip b. Move
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • VU_EA_ENTFERN : Own Contribution: Distance to Place of Work before Move
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VU_EA_KM_SATZ : Own Contribution: KM Rate to Place of Work Before Move
    Its data type is CURR (Currency Field) with field length 10
  • NU_EA_DOPP_ANZ : Own Contrib.: No. of Days wth Outb. and Ret. Trip after Move
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NU_EA_EINF_ANZ : Own Contrib.: No. of Days with Outb. or Ret. Trip after Move
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NU_EA_ENTFERN : Own Contribution: Distance to Place of Work after Move
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • NU_EA_KM_SATZ : Own Contribution: KM Rate to Place of Work after Move
    Its data type is CURR (Currency Field) with field length 10
  • V_UNENTGELTLICH : Gratuitous Meals for the Entire Month
    Its data type is CHAR (Character String) with field length 1
  • U_UNENTGELTLICH : Gratuitous Accommodations for the Entire Month
    Its data type is CHAR (Character String) with field length 1
  • REDUC_ERGRU : New Reimbursement Group for Reduction in Meals per Diem
    Its data type is CHAR (Character String) with field length 2
  • NOT_PAID : No Reimbursement of Trip
    Its data type is CHAR (Character String) with field length 1
  • WEG_ERH_MAX : Increased Maximum Trip Segment Reimbursement
    Its data type is CHAR (Character String) with field length 1
  • ERH_DIENST_INT : Significant Official Interest
    Its data type is CHAR (Character String) with field length 1
  • ENTF_WO_DO : Short Distance to Residence/Workplace
    Its data type is CHAR (Character String) with field length 1
  • DRITTMITTEL : Payments and Contributions from Third Parties
    Its data type is CHAR (Character String) with field length 1
  • ANTRAG_GWE : Request for Full Trip Segment Reimbursement
    Its data type is CHAR (Character String) with field length 1
  • POLICY_VIOLATION : Violation of Travel Policy
    Its data type is CHAR (Character String) with field length 1
  • EXCEPTION_FLAG : Exception Indicator
    Its data type is CHAR (Character String) with field length 1
  • NR_RECEIPTS : Number of Receipts
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PERM_TRIP_APPR : Standing Approval of Business Trips
    Its data type is CHAR (Character String) with field length 1
  • TR_NR_FROM_HOME : Number of Days with Round Trip from Home
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • VAT_STATUS : Status of Data for VAT Refund
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Second Enhancement to Struct.of Travel Expen. Tab PTRV_PERIO
  • TAX_TRIP : Taxation of Whole Trip
    Its data type is CHAR (Character String) with field length 1

    • PTRV_PERIO related tables

    • T706O : Names for Trip Country/Trip Country Group/Trip Region
    • T706FORM_BLK_HDL : Form block titles
    • PTRV_T706Z_DNPR : Field Control Screens
    • T706B1 : Travel Expense Types
    • PTRV_SREC : Trip Statistics – Receipts
    • T706Z1_TXT : Text table: Individual Field Control for Dialog
    • PTRV_SBACKLOG : Trip Statistics – Batch/Backlog Processing
    • T706FORM_FIXTXTS : Fixed texts (language-dependent)
    • T702Y : Employee Groupings for Travel Management
    • T706M : Input Tax for International Per Diems
    • T706_DEFAULTTEXT : Names of Reference Texts for Entering Trips
    • T706FORM_BCKGRND : Form background
    • T706_CONSTTEXT : Names of Accounting Constants for Travel Expenses
    • PTRV_ARCH_HEAD : Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary)
    • T702O : Trip country/Trip region/Trip country group
    • T706WWW_TXT : Text Table HTML Links and File Paths
    • T706FORM_CLMATTR : Suppressable columns per block
    • T706B3 : Travel Expense Type Grouping
    • T706FORM_VAR : Form variant
    • PTRV_WAFGUID : Logging for Synchronization GUID (DUPRECS)

    Related References

    Related Tutorials

    PTRV_ARCH_PERIO SAP table for – Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary)

    PTRV_ARCH_PERIO table in SAP FI (Travel Management in FI) module. This table is used for storing data of Prearchiving FI-TV:...

    PTRV_SADD SAP table for – Trip Statistics – Add. Receipt Data

    PTRV_SADD table in SAP FI (Travel Management in FI) module. This table is used for storing data of Trip Statistics...

    PTRV_REASGN_FM SAP table for – Conversion of FM Data in Trip (e.g. Fiscal Year Change)

    PTRV_REASGN_FM table in SAP FI (Travel Management in FI) module. This table is used for storing data of Conversion of...

    PTRV_COMM_ITM SAP table for – Header Data: Transfer to FM When Trip Saved

    PTRV_COMM_ITM table in SAP FI (Travel Management in FI) module. This table is used for storing data of Header Data:...

    T702O SAP table for – Trip country/Trip region/Trip country group

    T702O table in SAP FI (Travel Management in FI) module. This table is used for storing data of Trip country/Trip...

    PTRV_COMM_AMT SAP table for – Detail Data: Transfer to FM When Trip Saved

    PTRV_COMM_AMT table in SAP FI (Travel Management in FI) module. This table is used for storing data of Detail Data:...

    PTRV_ARCHIVE SAP table for – Administrative Table for Archived Trip Data

    PTRV_ARCHIVE table in SAP FI (Travel Management in FI) module. This table is used for storing data of Administrative Table...

    «
    »