SAP ABAP Table PTRV_UTIL_TRIPS (Read Current Trips of an Employee)

Hierarchy

☛

EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷

FI-TV-COS (Application Component) Travel Expenses
⤷

PTRA_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Expenses

Basic Data

Table Category	INTTAB	Structure
Structure	PTRV_UTIL_TRIPS	Table Relationship Diagram
Short Description	Read Current Trips of an Employee

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TRIPNUMBER	REINR	REINR	NUMC	10	0	Trip Number
2	PERIOD	PTRV_PEROD	PTRV_PEROD	NUMC	3	0	Trip Period Number
3	PDVRS	PTRV_PDVRS	NUMC2	NUMC	2	0	Sequential Number of Period
4	PLANNR	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
5	SCHEM	RSCHE	RSCHE	CHAR	2	0	Trip schema	*
6	VERPA	VERPA	VERPA	CHAR	1	0	Per-Diem Accounting for Meals
7	UEBKZ	UEPKZ	UEPKZ	CHAR	1	0	Per-Diem Accounting for Accommodations
8	OTH_EXP	PTRV_OTHER_EXPENSES	XFELD	CHAR	1	0	Indicator for Receipt Settlement Without Trip
9	DEP_DATE	REBED	REDAT	DATS	8	0	Beginning Date of Trip Segment
10	PUHRV	REENU	REUHR	TIMS	6	0	End Time of Trip Segment
11	ARR_DATE	REEND	REDAT	DATS	8	0	End Date of Trip Segment
12	PUHRB	REENU	REUHR	TIMS	6	0	End Time of Trip Segment
13	CUSTOMER	RKUNDE	RKUNDE	CHAR	59	0	Reason for Trip (for example, customer/requisitioner)
14	LOCATION	RZIELORT	RZIELORT	CHAR	59	0	Location
15	COUNTRY	LNDGR	LNDGR	CHAR	3	0	Trip Country / Trip Country Group	*
16	REIMBU_AMOUNT_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
17	REQUEST_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
18	REQUEST_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
19	REQUEST_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
20	REQUEST_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
21	PLAN_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
22	PLAN_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
23	PLAN_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
24	PLAN_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
25	ACCOUNTING_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
26	ACCOUNTING_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
27	ACCOUNTING_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
28	ACCOUNTING_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
29	CATS_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
30	CATS_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
31	CATS_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
32	CATS_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
33	SUPPOSABLY_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
34	SUPPOSABLY_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
35	SUPPOSABLY_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
36	SUPPOSABLY_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
37	PRINT_STATUS	P_PRINT	P_PRINT	CHAR	1	0	Trip Print Status
38	PRINT_STATUS_NAME	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
39	APPVL_STATUS	ANTRG	ANTRG	CHAR	1	0	Travel Request or Trip Approved (Indicator)
40	APPVL_STATUS_NAME	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
41	SETTL_STATUS	ABREC	ABREC	CHAR	1	0	Open / To be Settled / Settled (Indicator)
42	SETTL_STATUS_NAME	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
43	PAY_STATUS	UEBLG	UEBLG	CHAR	1	0	HR Payroll Transfer (Indicator)
44	PAY_STATUS_NAME	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
45	FIN_STATUS	UEBRF	UEBRF	CHAR	1	0	FI Transfer (Indicator)
46	FIN_STATUS_NAME	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
47	DME_STATUS	UEBDT	UEBDT	CHAR	1	0	Data Medium Exchange Transfer (Indicator)
48	DME_STATUS_NAME	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
49	STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
50	PROCESSING_STATUS_NAME	PTRV_STATUS_ICON		CHAR	50	0	Trip Status
51	STEXT	TEXT_RSCHE	REITX	CHAR	30	0	Name for trip schema
52	.INCLUDE				0	0	Status of Trip Creation/Processing as Request, Plan, Acctg
53	REQUEST	PTRV_OBJEKT	CHAR1	CHAR	1	0	Indicator for objects request, plan and expense report
54	TRAVEL_PLAN	PTRV_OBJEKT	CHAR1	CHAR	1	0	Indicator for objects request, plan and expense report
55	EXPENSES	PTRV_OBJEKT	CHAR1	CHAR	1	0	Indicator for objects request, plan and expense report
56	.INCLUDE				0	0	Possible Activities for PTRV_TRIPS
57	SHOW_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
58	CHANGE_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
59	DELETE_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
60	CANCEL_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
61	ACCOUNT_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
62	ANALYSE_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
63	SHOW_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
64	CHANGE_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
65	DELETE_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
66	CANCEL_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
67	ACCOUNT_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
68	ANALYSE_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
69	SHOW_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
70	CHANGE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
71	APPROVE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
72	BOOK_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
73	BOOK_PLAN_IN_GDS_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
74	SAMPLE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
75	DELETE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
76	CANCEL_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
77	.INCLUDE				0	0	Totals of a trip; Structure for BAPI interface
78	TRIPNO	REINR	REINR	NUMC	10	0	Trip Number
79	CURRENCY	TRVWAERS	WAERS	CUKY	5	0	Currency Key	TCURC
80	CURRDEC	CURRDEC	CURRDEC	INT1	3	0	Number of decimal places
81	ADDIT_AMNT	ADDIT_AMNT	BAPICURR	DEC	23	4	Additional Amount of a Trip (Taxable for Employee)
82	SUM_REIMBU	SUM_REIMBU	BAPICURR	DEC	23	4	Reimbursement amount for a trip
83	SUM_ADVANC	SUM_ADVANC	BAPICURR	DEC	23	4	Total advances for a trip
84	SUM_PAYOUT	SUM_PAYOUT	BAPICURR	DEC	23	4	Payment Amount
85	SUM_PAIDCO	SUM_PAIDCO	BAPICURR	DEC	23	4	Travel expenses paid by company
86	TRIP_TOTAL	TRIP_TOTAL	BAPICURR	DEC	23	4	Total costs for trip
87	.INCLUDE				0	0	Per Diem/Flat Rate (Reimbursement) Amounts for a Trip
88	PD_FOOD	PD_FOOD	BAPICURR	DEC	23	4	Reimbursement Amount (Total) for Meals per Diems
89	PD_HOUSING	PD_HOUSING	BAPICURR	DEC	23	4	Reimbursement Amount (Total) for Accommodations per Diems
90	PD_MILEAGE	PD_MILEAGE	BAPICURR	DEC	23	4	Reimbursement Amount (Total) for Travel Flat Rates
91	.INCLU--AP				0	0	Additional Fields for Public Sector
92	TXF_FOOD	TXF_FOOD	BAPICURR	DEC	23	4	Tax-Exempt Meals per Diems Without Withholding (PS) - Bapi
93	M_TOTAL	KMGES	KMANZ	DEC	5	0	Total Miles/Kilometers