SAP Table PTRV_APPR

Trip Approval

PTRV_APPR (Trip Approval) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PTRV_APPR to other SAP tables.

Source: PTRV_APPR (Trip Approval)

PTRV_APPR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PERNR Personnel Number PERNR_D NUMC 8 0
REINR Trip Number REINR NUMC 10 0
PERIO Trip Period Number PTRV_PEROD NUMC 3 0
PDVRS Sequential Number of Period PTRV_PDVRS NUMC 2 0
DRUCK Trip Print Status P_PRINT CHAR 1 0
1 Not Yet Printed
2 Printed, Subsequently Changed
3 Printed
ANTRG Travel Request or Trip Approved (Indicator) ANTRG CHAR 1 0
1 Request Recorded
2 Request Approved
3 Trip Completed
4 Trip Approved
5 Request Awaiting Documents
6 Trip Awaiting Documents
ABREC Open / To be Settled / Settled (Indicator) ABREC CHAR 1 0
0 Open
1 To Be Settled
2 Settled
3 Canceled
4 Draft
UEBLG HR Payroll Transfer (Indicator) UEBLG CHAR 1 0
NULL Not Paid via Payroll Accounting
1 Paid via Payroll Accounting
2 Payment via Payroll Accounting Canceled
3 Cancellation of Payment via Payroll Taken into Account
UEBRF FI Transfer (Indicator) UEBRF CHAR 1 0
NULL Not Posted to Financial Accounting
1 Posted to Financial Accounting
2 Posting to Financial Accounting Canceled
3 Cancellation Posted to Financial Accounting
UEBDT Data Medium Exchange Transfer (Indicator) UEBDT CHAR 1 0
NULL Not Paid via Data Medium
1 Paid via Data Medium
2 Payment via Data Medium Canceled
3 Cancellation of Payment via Data Medium Taken into Account
VERPA Per-Diem Accounting for Meals VERPA CHAR 1 0
NULL Meals are not to be settled by per diem
X Meals are to be settled by per diem
ABRJ1 Payroll Year PABRJ NUMC 4 0
ABRP1 Payroll Period PABRP NUMC 2 0
PERM1 Period modifier IPERM CHAR 2 0
ABKR1 Payroll Area ABKRS CHAR 2 0
WAERS Currency Key WAERS CUKY 5 0
HDVRS Sequential Number of Travel Expenses Table THEADER PTRV_HDVRS NUMC 2 0
MOREI Trip Provision Variant MOREI T702N CHAR 2 0
SCHEM Trip schema RSCHE T706S CHAR 2 0
ZORT1 Location RZIELORT CHAR 59 0
ZLAND Trip Country / Trip Country Group LNDGR T702O CHAR 3 0
HRGIO Region of Main Destination HRGIO T702O CHAR 5 0
KUNDE Reason for Trip (for example, customer/requisitioner) RKUNDE CHAR 59 0
DATV1 Beginning Date of Trip Segment REBED DATS 8 0
UHRV1 Beginning Time of Trip Segment REBEU TIMS 6 0
DATB1 End Date of Trip Segment REEND DATS 8 0
UHRB1 End Time of Trip Segment REENU TIMS 6 0
REQUEST Indicator for objects request, plan and expense report PTRV_OBJEKT CHAR 1 0
TRAVEL_PLAN Indicator for objects request, plan and expense report PTRV_OBJEKT CHAR 1 0
EXPENSES Indicator for objects request, plan and expense report PTRV_OBJEKT CHAR 1 0
TRIP_TOTAL Total Cost of Trip PTRV_TRIP_TOTAL CURR 13 2
CURRENCY Currency Key WAERS CUKY 5 0
TRIPDUR Trip Duration in Days PTRV_TRIPDUR DEC 4 0
CORR_ICON Correction Indicator PTRV_CORR_ICON STRG 0 0
ANTRG_TXT Travel Request or Trip Approved - Long Text ANTRG_TXT CHAR 20 0
ABREC_TXT Trip Open/To be Settled/Settled - Long Text ABREC_TXT CHAR 20 0
ENAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
SNAME Employee's Name (Sortable by LAST NAME FIRST NAME) SMNAM CHAR 30 0
PFLAG_ICON Trip Status PTRV_PFLAG_ICON STRG 0 0
RACCOBJ Account Assignment PTRV_RACCOBJ CHAR 25 0
RACCOBJ_GENREC Account Assignment Object PTRV_RACCOBJ_GENREC CHAR 35 0
RACCOBJ_TEXT Account Assignment Text PTRV_RACCOBJ_TEXT STRG 0 0
ADDITIONAL_RECEIVERS Multiple Account Assignment PTRV_ADDITIONAL_RECEIVERS STRG 0 0

PTRV_APPR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PTRV_APPR HRGIO SYST MANDT T702O Trip country/Trip region/Trip country group MANDT
PTRV_APPR HRGIO PTRV_APPR MOREI T702O Trip country/Trip region/Trip country group MOREI
PTRV_APPR HRGIO PTRV_APPR ZLAND T702O Trip country/Trip region/Trip country group LAND1
PTRV_APPR HRGIO PTRV_APPR HRGIO T702O Trip country/Trip region/Trip country group RGION
PTRV_APPR MOREI SYST MANDT T702N Trip Provision Variants MANDT
PTRV_APPR MOREI PTRV_APPR MOREI T702N Trip Provision Variants MOREI
PTRV_APPR SCHEM SYST MANDT T706S Trip Schema MANDT
PTRV_APPR SCHEM PTRV_APPR MOREI T706S Trip Schema MOREI
PTRV_APPR SCHEM PTRV_APPR SCHEM T706S Trip Schema SCHEM
PTRV_APPR ZLAND SYST MANDT T702O Trip country/Trip region/Trip country group MANDT
PTRV_APPR ZLAND PTRV_APPR MOREI T702O Trip country/Trip region/Trip country group MOREI
PTRV_APPR ZLAND PTRV_APPR ZLAND T702O Trip country/Trip region/Trip country group LAND1
PTRV_APPR ZLAND PTRV_APPR HRGIO T702O Trip country/Trip region/Trip country group RGION