PTRV_ARCH_PERIO - Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary)

Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) information is stored in SAP table PTRV_ARCH_PERIO.
It is part of development package PTRA in software component FI-TV-COS. This development package consists of objects that can be grouped under "Travel Expenses Application Dev. (R/3 Enterprise Core)".

Fields for table PTRV_ARCH_PERIO

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXPTP400
MANDTClientXMANDTCLNT6*
PERNRPersonnel NumberXPERNR_DNUMC16
REINRTrip NumberXREINRNUMC20
PERIOTrip Period NumberXPTRV_PERODNUMC6
PDVRSSequential Number of PeriodXPTRV_PDVRSNUMC4
.INCLUDEPTPPD0
HDVRSSequential Number of Travel Expenses Table THEADERPTRV_HDVRSNUMC4
PDATVBeginning Date of Trip SegmentREBEDDATS16
PUHRVBeginning Time of Trip SegmentREBEUTIMS12
PDATBEnd Date of Trip SegmentREENDDATS16
PUHRBEnd Time of Trip SegmentREENUTIMS12
DRUCKTrip Print StatusP_PRINTCHAR2
ANTRGTravel Request or Trip Approved (Indicator)ANTRGCHAR2
ABRECOpen / To be Settled / Settled (Indicator)ABRECCHAR2
UEBLGHR Payroll Transfer (Indicator)UEBLGCHAR2
UEBRFFI Transfer (Indicator)UEBRFCHAR2
UEBDTData Medium Exchange Transfer (Indicator)UEBDTCHAR2
TLOCKIndicator: Trip lockedPTRV_TLOCKCHAR2
WAERSCurrency KeyWAERSCUKY10*
ABRJ1Payroll YearPABRJNUMC8
ABRP1Payroll PeriodPABRPNUMC4
PERM1Period modifierIPERMCHAR4
ABKR1Payroll AreaABKRSCHAR4*
BEGP1Start of Settlement PeriodPTRV_BEGP1DATS16
ENDP1End of Settlement PeriodPTRV_ENDP1DATS16
ABRJ2Payroll YearPABRJNUMC8
ABRP2Payroll PeriodPABRPNUMC4
PERM2Period modifierIPERMCHAR4
ABKR2Payroll AreaABKRSCHAR4*
BEGP2Start of Settlement PeriodPTRV_BEGP2DATS16
ENDP2End of Settlement PeriodPTRV_ENDP2DATS16
ACCDTTrip Settlement DatePTRV_ACCDTDATS16
ACCTMTrip Settlement TimePTRV_ACCTMTIMS12
RUNIDSequential number of posting runTR_EVNUMNUMC20
VERPAPer-Diem Accounting for MealsVERPACHAR2
UEBKZPer-Diem Accounting for AccommodationsUEPKZCHAR2
ANUEPNumber of Overnight Stays for Per-Diem SettlementANUEPDEC2
NO_MILESIndicator: No repeat of travel costs accountingPTRV_NO_MILES_ACCOUNTINGCHAR2
LSTAYMeals per diem reduct. for longer stay at same place of workPTRV_LSTAYCHAR2
KATRE_STATUSKATRE StatusKATRE_STATUSCHAR2
KATRE_IDKATRE_IDKATRE_IDCHAR64
KATRE_DELIDKATRE_DELID - Delivery IDKATRE_DELIDCHAR64
KATRE_SAPDELIDKATRE_SAPDELID SAP Delivery IDKATRE_SAPDELIDCHAR64
.INCLU--APPTPPD_APPEND0
TR_DOPP_ANZAHLDaily Return: No. of Days with Outb. and Return TripPTRVPS_TR_DOPP_ANZAHLNUMC6
TR_EINF_ANZAHLDaily Return: No. of Days only with Outb./ or Return TripPTRVPS_TR_EINF_ANZAHLNUMC6
TR_ENTFERNUNGDaily Return: Distance fr. Residence to New Place of WorkPTRVPS_TR_ENTFERNUNGDEC3
VU_EA_DOPP_ANZOwn Contribution: No. of Days with Outb./Return Trip b. MovePTRVPS_VU_EA_DOPP_ANZAHLNUMC6
VU_EA_EINF_ANZOwn Contribution: No. of Days wth Outb./Return Trip b. MovePTRVPS_VU_EA_EINF_ANZAHLNUMC6
VU_EA_ENTFERNOwn Contribution: Distance to Place of Work before MovePTRVPS_VU_EA_ENTFERNUNGDEC3
VU_EA_KM_SATZOwn Contribution: KM Rate to Place of Work Before MovePTRVPS_VU_EA_KM_SATZCURR6
NU_EA_DOPP_ANZOwn Contrib.: No. of Days wth Outb. and Ret. Trip after MovePTRVPS_NU_EA_DOPP_ANZAHLNUMC6
NU_EA_EINF_ANZOwn Contrib.: No. of Days with Outb. or Ret. Trip after MovePTRVPS_NU_EA_EINF_ANZAHLNUMC6
NU_EA_ENTFERNOwn Contribution: Distance to Place of Work after MovePTRVPS_NU_EA_ENTFERNUNGDEC3
NU_EA_KM_SATZOwn Contribution: KM Rate to Place of Work after MovePTRVPS_NU_EA_KM_SATZCURR6
V_UNENTGELTLICHGratuitous Meals for the Entire MonthPTRV_V_UNENTGELTLICHCHAR2
U_UNENTGELTLICHGratuitous Accommodations for the Entire MonthPTRV_U_UNENTGELTLICHCHAR2
REDUC_ERGRUNew Reimbursement Group for Reduction in Meals per DiemPTRV_REDUC_ERGRUCHAR4
NOT_PAIDNo Reimbursement of TripPTRV_NOT_PAIDCHAR2
WEG_ERH_MAXIncreased Maximum Trip Segment ReimbursementPTRV_WEG_ERH_MAXCHAR2
ERH_DIENST_INTSignificant Official InterestPTRV_ERH_DIENST_INTCHAR2
ENTF_WO_DOShort Distance to Residence/WorkplacePTRV_ENTF_WO_DOCHAR2
DRITTMITTELPayments and Contributions from Third PartiesPTRV_DRITTMITTELCHAR2
ANTRAG_GWERequest for Full Trip Segment ReimbursementPTRV_ANTRAG_GWECHAR2
POLICY_VIOLATIONViolation of Travel PolicyPTRV_POLICY_VIOLATIONCHAR2
EXCEPTION_FLAGException IndicatorPTRV_EXCEPTIONCHAR2
NR_RECEIPTSNumber of ReceiptsPTRV_NR_RECEIPTSNUMC6
PERM_TRIP_APPRStanding Approval of Business TripsPTRV_PERM_TRIP_APPROVALCHAR2
TR_NR_FROM_HOMENumber of Days with Round Trip from HomePTRVPS_NR_COMMUTES_FROM_HOMENUMC6
VAT_STATUSStatus of Data for VAT RefundPTRV_VAT_STATUSCHAR2
EST_COST_PLANEstimated Costs from PlanPTRV_EST_COST_PLANCURR7
EST_COST_REQEstimated Costs from RequestPTRV_EST_COST_REQCURR7
REASONReason for DifferencePTRV_REASONCHAR100
LSTAY_ACCReduction of Accommodations Per Diem During Longer StayPTRV_LSTAY_ACCCHAR2
EXCL_PERIOD_EXCStatutory Exclusion Period ExpiredPTRV_EXCL_PERIOD_EXCCHAR2
.INCLU--APPTPPD_APPEND_20
TAX_TRIPTaxation of Whole TripPTRVPS_TAX_TRIPCHAR2
Privacy Policy