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

Hierarchy

☛

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

FI-TV (Application Component) Travel Management
⤷

PTRM_WEB_INTERFACE (Package) RFC Modules for Web User Interface: General Travel Mgt

Basic Data

Table Category	INTTAB	Structure
Structure	PTRV_WEB_TRIPS_EXT	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_NO	PTRV_PEROD	PTRV_PEROD	NUMC	3	0	Trip Period Number
3	PDVRS_NO	PTRV_PDVRS	NUMC2	NUMC	2	0	Sequential Number of Period
4	PLAN_NO	PLAN_NR	FTPD_PLAN_NR	NUMC	2	0	Travel Plan Number (Sequential Number)	*
5	SCHEME	RSCHE	RSCHE	CHAR	2	0	Trip schema	*
6	MEALS_PER_DIEM	VERPA	VERPA	CHAR	1	0	Per-Diem Accounting for Meals
7	ACCOMMODATION_PER_DIEM	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	.INCLU-DEP				0	0	Start of Leg of Trip
10	DATEDEP	REBED	REDAT	DATS	8	0	Beginning Date of Trip Segment
11	TIMEDEP	REBEU	REUHR	TIMS	6	0	Beginning Time of Trip Segment
12	.INCLU-ARR				0	0	End of Leg of Trip
13	DATEARR	REEND	REDAT	DATS	8	0	End Date of Trip Segment
14	TIMEARR	REENU	REUHR	TIMS	6	0	End Time of Trip Segment
15	CUSTOMER	RKUNDE	RKUNDE	CHAR	59	0	Reason for Trip (for example, customer/requisitioner)
16	LOCATION	RZIELORT	RZIELORT	CHAR	59	0	Location
17	COUNTRY	LNDGR	LNDGR	CHAR	3	0	Trip Country / Trip Country Group	*
18	PNR_LOCATOR	PNR_RECORD_LOCATOR	FTPD_PNR_RECORD_LOCATOR	CHAR	20	0	Passenger Name Record Locator
19	TICKET_NUMBER	TICKET_NUMBER	FTPD_TICKET_NUMBER	NUMC	15	0	Ticket Number
20	MILEAGE_TOTAL	KMGES	KMANZ	DEC	5	0	Total Miles/Kilometers
21	.INCLUDE				0	0	Status of Trip Creation/Processing as Request, Plan, Acctg
22	REQUEST	PTRV_OBJEKT	CHAR1	CHAR	1	0	Indicator for objects request, plan and expense report
23	TRAVEL_PLAN	PTRV_OBJEKT	CHAR1	CHAR	1	0	Indicator for objects request, plan and expense report
24	EXPENSES	PTRV_OBJEKT	CHAR1	CHAR	1	0	Indicator for objects request, plan and expense report
25	.INCLUDE				0	0	STATUS and ALERTS for PTRV_TRIPS
26	REQUEST_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
27	REQUEST_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
28	PLAN_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
29	PLAN_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
30	ACCOUNTING_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
31	ACCOUNTING_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
32	CATS_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
33	CATS_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
34	SUPPOSABLY_STATUS	PTRV_STATUS	PTRV_STATUS	CHAR	2	0	Status of Trip Objects (Request, Plan or Expense Report)
35	SUPPOSABLY_STATUS_ALERT	PTRV_TRAVEL_ALERT	PTRV_TRAVEL_ALERT	CHAR	2	0	Trip Needs Editing
36	PRINT_STATUS	P_PRINT	P_PRINT	CHAR	1	0	Trip Print Status
37	APPVL_STATUS	ANTRG	ANTRG	CHAR	1	0	Travel Request or Trip Approved (Indicator)
38	PLANT_STATUS	PLAN_STATUS	FTPD_PSTAT	CHAR	1	0	Travel Plan Status
39	REQ_STATUS	PLAN_STATUS	FTPD_PSTAT	CHAR	1	0	Travel Plan Status
40	SETTL_STATUS	ABREC	ABREC	CHAR	1	0	Open / To be Settled / Settled (Indicator)
41	PAY_STATUS	UEBLG	UEBLG	CHAR	1	0	HR Payroll Transfer (Indicator)
42	FIN_STATUS	UEBRF	UEBRF	CHAR	1	0	FI Transfer (Indicator)
43	DME_STATUS	UEBDT	UEBDT	CHAR	1	0	Data Medium Exchange Transfer (Indicator)
44	AGENCYSTATUS	AGENCY_STATUS	PTPD_AGENCY_STATUS	CHAR	1	0	Travel Agency Status
45	AGENCYSTATUS_NAME	TEXT25	TEXT25	CHAR	25	0	Text length 25
46	.INCLUDE				0	0	Possible Activities for PTRV_TRIPS
47	SHOW_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
48	CHANGE_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
49	DELETE_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
50	CANCEL_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
51	ACCOUNT_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
52	ANALYSE_REQUEST_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
53	SHOW_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
54	CHANGE_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
55	DELETE_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
56	CANCEL_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
57	ACCOUNT_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
58	ANALYSE_EXPENSE_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
59	SHOW_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
60	CHANGE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
61	APPROVE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
62	BOOK_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
63	BOOK_PLAN_IN_GDS_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
64	SAMPLE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
65	DELETE_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
66	CANCEL_PLAN_ENABLE	XFELD	XFELD	CHAR	1	0	Checkbox
67	.INCLUDE				0	0	Designations of Trip Data
68	REQUEST_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
69	REQUEST_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
70	PLAN_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
71	PLAN_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
72	ACCOUNTING_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
73	ACCOUNTING_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
74	CATS_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
75	CATS_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
76	SUPPOSABLY_STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
77	SUPPOSABLY_STATUS_ALERT_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
78	PRINT_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
79	PLANT_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
80	REQ_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
81	APPVL_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
82	SETTL_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
83	PAY_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
84	FIN_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
85	DME_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
86	STATUS_NAME	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
87	REIMBU_AMOUNT_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
88	PROCESSING_STATUS_NAME	PTRV_STATUS_ICON		CHAR	50	0	Trip Status
89	PROCESSING_REQ_STATUS_NAME	PTRV_STATUS_ICON		CHAR	50	0	Trip Status
90	PROCESSING_PLAN_STATUS_NAME	PTRV_STATUS_ICON		CHAR	50	0	Trip Status
91	STEXT	TEXT_RSCHE	REITX	CHAR	30	0	Name for trip schema
92	.INCLUDE				0	0	Amounts for PTRV_TRIPS
93	CURRENCY_KEY	TRVWAERS	WAERS	CUKY	5	0	Currency Key	*
94	NUMBER_OF_DECIMAL_PLACE	CURRDEC	CURRDEC	INT1	3	0	Number of decimal places
95	ADDITIONAL_AMOUNT	PTRV_ADDIT_AMNT	WERTV7	CURR	13	2	Additional Amount of a Trip (Taxable for Employee)
96	AMOUNT_SUM_REIMBURSEMENT	PTRV_SUM_REIMBU	WERTV7	CURR	13	2	Reimbursement Amount for a Trip
97	AMOUNT_SUM_ADVANCE	PTRV_SUM_ADVANC	WERTV7	CURR	13	2	Total Advances for a Trip
98	AMOUNT_SUM_PAID	PTRV_SUM_REIMBU	WERTV7	CURR	13	2	Reimbursement Amount for a Trip
99	AMOUNT_SUM_PAID_COMPANY	PTRV_SUM_PAIDCO	WERTV7	CURR	13	2	Travel Expenses Paid by Company
100	AMOUNT_SUM_TRIP_TOTAL	PTRV_TRIP_TOTAL	WERTV7	CURR	13	2	Total Cost of Trip
101	REFUND_AMOUNT_FOOD	PTRV_PD_FOOD	WERTV7	CURR	13	2	Reimbursement Amount (Total) for Meals per Diems
102	REFUND_AMOUNT_HOUSING	PTRV_PD_HOUSING	WERTV7	CURR	13	2	Reimbursement Amount (Total) for Accommodations per Diems
103	REFUND_AMOUNT_MILEAGE	PTRV_PD_MILEAGE	WERTV7	CURR	13	2	Reimbursement Amount (Total) for Travel Flat Rates