SAP Table PTRV_TRIPS

Trip Overview

PTRV_TRIPS (Trip Overview) 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_TRIPS to other SAP tables.

PTRV_TRIPS 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
HDVRS Sequential Number of Travel Expenses Table THEADER PTRV_HDVRS NUMC 2 0
MOREI Trip Provision Variant MOREI CHAR 2 0
ZORT1 Location RZIELORT CHAR 59 0
ZLAND Trip Country / Trip Country Group LNDGR CHAR 3 0
KUNDE Reason for Trip (for example, customer/requisitioner) RKUNDE CHAR 59 0
DATV1 Beginning Date of Trip Segment REBED DATS 8 0
DATB1 End Date of Trip Segment REEND DATS 8 0
REQ_STATUS 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
PLAN_STATUS Travel Plan Status PLAN_STATUS CHAR 1 0
0 Open
1 For Approval
2 Approved
3 Rejected
6 Variant Activated, Not Booked (currently not used)
7 Variant Activated, Partially Booked (currently not used)
8 Variant Activated, Fully Booked (currently not used)
9 Canceled
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
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
SUM_REIMBU Reimbursement amount for a trip PTRV_SUM_REIMBU CURR 13 2
CURRENCY Currency Key TRVWAERS CUKY 5 0