PTRV_ARCH_HEAD SAP table for – Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary)

Here we would like to draw your attention to PTRV_ARCH_HEAD 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_ARCH_HEAD is a SAP standard transp table used for storing Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) related data in SAP. It comes under the package PTRA.

SAP PTRV_ARCH_HEAD table

Table PTRV_ARCH_HEAD technical data

TablePTRV_ARCH_HEAD
Data storingPrearchiving FI-TV: Entries from PTRV_HEAD (Temporary)
ModuleFI
Sub ModuleFI-TV-COS
SAP PackagePTRA
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP PTRV_ARCH_HEAD 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_ARCH_HEAD table.

  • .INCLUDE : Key for Travel Expenses Table PTRV_HEAD
    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
  • HDVRS : Sequential Number of Travel Expenses Table THEADER
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Structure of Travel Expenses Table PTRV_HEAD
  • MOLGA : Country Grouping
    Its data type is CHAR (Character String) with field length 2
  • MOREI : Trip Provision Variant
    Its data type is CHAR (Character String) with field length 2
  • SCHEM : Trip schema
    Its data type is CHAR (Character String) with field length 2
  • KZREA : Trip Type: Statutory
    Its data type is CHAR (Character String) with field length 1
  • BEREI : Trip Type: Enterprise-Specific
    Its data type is CHAR (Character String) with field length 1
  • KZTKT : Trip Activity Type
    Its data type is CHAR (Character String) with field length 1
  • ZORT1 : Location
    Its data type is CHAR (Character String) with field length 59
  • ZLAND : Trip Country / Trip Country Group
    Its data type is CHAR (Character String) with field length 3
  • HRGIO : Region of Main Destination
    Its data type is CHAR (Character String) with field length 5
  • NDNST : Name of new administrative office (P.S.)
    Its data type is CHAR (Character String) with field length 25
  • KUNDE : Reason for Trip (for example, customer/requisitioner)
    Its data type is CHAR (Character String) with field length 59
  • DATV1 : Beginning Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRV1 : Beginning Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATB1 : End Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRB1 : End Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATH1 : Border Crossing (Trip Out): Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRH1 : Time: Border crossing(trip out)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATR1 : Border Crossing (Return Trip): Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRR1 : Time: Border crossing(return trip)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AGRZ1 : Trip Country / Trip Country Group
    Its data type is CHAR (Character String) with field length 3
  • GRGIO : Region of Border Crossing: Return Trip
    Its data type is CHAR (Character String) with field length 5
  • GRBER : Border crossing: Trip type enterprise-specific
    Its data type is CHAR (Character String) with field length 1
  • UZKVG : Confirmation of Moving Costs Refund
    Its data type is CHAR (Character String) with field length 1
  • ZUSAG : Admin. Office That Confirmed Moving Costs Compensation (PS)
    Its data type is CHAR (Character String) with field length 25
  • ENDRG : Different End of Travel Allowance (in Separation Allowance)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DEPAR : Departure from Residence or Place of Work
    Its data type is CHAR (Character String) with field length 1
  • ARRVL : Arrival Accommodations/New Place of Work
    Its data type is CHAR (Character String) with field length 1
  • RETRN : Return to residence/admin. office
    Its data type is CHAR (Character String) with field length 1
  • DATES : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIMES : Time of Last Change
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UNAME : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • REPID : Change Report
    Its data type is CHAR (Character String) with field length 40
  • DANTN : Trip Number of Corresponding Trip to Start Work
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • FINTN : Trip Number of Associated Business Trip Return
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • REQUEST : Indicator for objects request, plan and expense report
    Its data type is CHAR (Character String) with field length 1
  • TRAVEL_PLAN : Indicator for objects request, plan and expense report
    Its data type is CHAR (Character String) with field length 1
  • EXPENSES : Indicator for objects request, plan and expense report
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Enhancement of Structure for Travel Expenses Table PTRV_HEAD
  • ST_TRGTG : Start of Taxation for Per Diem Separation Allowance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ST_TRGALL : Start of Taxation for Complete Separation Allowance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PERIODENART : Associated Trip Period Types
    Its data type is CHAR (Character String) with field length 1
  • DAT_REDUC1 : Reduction of Entire Separation or Travel Allowance Level 1
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DAT_REDUC2 : Reduction of Separation or Travel Allowance Level 2
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATV1_DIENST : Date of Commencement of Work
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRV1_DIENST : Time at Which Work Commences
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATB1_DIENST : Date on Which Work Ends
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRB1_DIENST : Time at Which Work Ends
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ABORDNUNG : Associated Superior Separation Allowance
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ST_TRG_TYP : Temporary Assignment (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • ST_WOHN_TYP : Home for Separation Allowance Taxation
    Its data type is CHAR (Character String) with field length 1
  • KEIN_REISEGELD : No Separation Allowance for Travel Is Paid (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • TAX_PER_DIEM : Automatic Taxation of Meals and Accommodations Per Diems
    Its data type is CHAR (Character String) with field length 1
  • TAX_PD_MAN : Manually Triggered Taxation of Meals Per Diems
    Its data type is CHAR (Character String) with field length 1
  • TAX_OV_MAN : Manually Triggered Taxation of Accommodations Per Diems
    Its data type is CHAR (Character String) with field length 1
  • EXCHANGE_DATE : Reference Date of Trip
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ROUNDING : Travel Amounts Are Rounded (Indicator)
    Its data type is CHAR (Character String) with field length 1
  • DZ_LIMIT_180 : Limit DA Fee to 180 Days
    Its data type is CHAR (Character String) with field length 1