SAP ABAP Table PTRV_WEB_GENERAL_DATA_EXT (General Trip Data for External Display)

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_WEB_GENERAL_DATA_EXT	Table Relationship Diagram
Short Description	General Trip Data for External Display

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	.INCLUDE				0	0	General Trip Data
2	.INCLU-DEP				0	0	Start of Leg of Trip
3	DATEDEP	REBED	REDAT	DATS	8	0	Beginning Date of Trip Segment
4	TIMEDEP	REBEU	REUHR	TIMS	6	0	Beginning Time of Trip Segment
5	.INCLU-ARR				0	0	End of Leg of Trip
6	DATEARR	REEND	REDAT	DATS	8	0	End Date of Trip Segment
7	TIMEARR	REENU	REUHR	TIMS	6	0	End Time of Trip Segment
8	CUSTOMER	RKUNDE	RKUNDE	CHAR	59	0	Reason for Trip (for example, customer/requisitioner)
9	LOCATION	RZIELORT	RZIELORT	CHAR	59	0	Location
10	COUNTRY	LNDGR	LNDGR	CHAR	3	0	Trip Country / Trip Country Group	*
11	REGION	HRGIO	RGION	CHAR	5	0	Region of Main Destination	*
12	.INCLU-OUT				0	0	Border Crossing During Domestic Departure
13	DATEOUT	DATGH	REDAT	DATS	8	0	Border Crossing (Trip Out): Date
14	TIMEOUT	UHRGH	REUHR	TIMS	6	0	Time: Border crossing(trip out)
15	.INCLU-FAR				0	0	Domestic Departure Landing in Destination Country: Date/Time
16	DATEFAR	PTRV_DATFH	REDAT	DATS	8	0	Domestic Departure, Landing in Destination Country: Date
17	TIMEFAR	PTRV_UHRFH	REUHR	TIMS	6	0	Trip out, landing at destination: Time
18	.INCLU-FDP				0	0	Return Trip Departure by Air in Foreign Country: Date/Time
19	DATEFDP	PTRV_DATFZ	REDAT	DATS	8	0	Return Trip Departure in Foreign Country: Date
20	TIMEFDP	PTRV_UHRFZ	REUHR	TIMS	6	0	Return trip departure abroad: Time
21	.INCLU-RET				0	0	Border Crossing During Domestic Return
22	DATERET	DATGZ	REDAT	DATS	8	0	Border Crossing (Return Trip): Date
23	TIMERET	UHRGZ	REUHR	TIMS	6	0	Time: Border crossing(return trip)
24	RET_COUN	RET_COUN	LNDGR	CHAR	3	0	Return trip from country	*
25	RET_RGIO	RET_RGIO	RGION	CHAR	5	0	Trip country/trip country group/trip region	*
26	RET_TTCS	RET_TTCS	BEREI	CHAR	1	0	Trip type: Enterprise-specific	*
27	T_SCHEMA	RSCHE	RSCHE	CHAR	2	0	Trip schema	*
28	TT_COMSP	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	*
29	TT_STATU	KZREA	KZREA	CHAR	1	0	Trip Type: Statutory	*
30	T_ACTYPE	KZTKT	KZTKT	CHAR	1	0	Trip Activity Type	*
31	PD_MEALS	VERPA	VERPA	CHAR	1	0	Per-Diem Accounting for Meals
32	PD_ACCOM	UEPKZ	UEPKZ	CHAR	1	0	Per-Diem Accounting for Accommodations
33	NO_NIGHT	ANUEP	ANUEP	DEC	2	0	Number of Overnight Stays for Per-Diem Settlement
34	ACT_NIGHTS	ANUEP	ANUEP	DEC	2	0	Number of Overnight Stays for Per-Diem Settlement
35	MAX_NIGHTS	ANUEP	ANUEP	DEC	2	0	Number of Overnight Stays for Per-Diem Settlement
36	MILES	KMGES	KMANZ	DEC	5	0	Total Miles/Kilometers
37	VEH_TYPE	KZPMF	KZPMF	CHAR	1	0	Vehicle Type	*
38	VEH_CLAS	PKWKL	PKWKL	CHAR	3	0	Vehicle Class	*
39	PLAN_ACTIVITY_TYPE	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	*
40	ESTIMATED_COST	PTRV_ESTIMATED_COST	WERTV7	CURR	13	2	Estimated Total Cost of Trip
41	ESTIMATED_COST_CURR	WAERS	WAERS	CUKY	5	0	Currency Key	*
42	PAY_CURR	WAERS	WAERS	CUKY	5	0	Currency Key	*
43	REQUEST	PTRV_REQUEST	PTRV_REQUEST	CHAR	1	0	Indicator for Existence of Object "Travel Request"
44	TRAVEL_PLAN	PTRV_TRAVEL_PLAN	PTRV_TRAVEL_PLAN	CHAR	1	0	Indicator for Existence of Object "Travel Plan"
45	EXPENSES	PTRV_EXPENSES	PTRV_EXPENSES	CHAR	1	0	Indicator for Existence of Object "Travel Expenses"
46	PRINT_STATUS	P_PRINT	P_PRINT	CHAR	1	0	Trip Print Status
47	APPVL_STATUS	ANTRG	ANTRG	CHAR	1	0	Travel Request or Trip Approved (Indicator)
48	SETTL_STATUS	ABREC	ABREC	CHAR	1	0	Open / To be Settled / Settled (Indicator)
49	FIN_STATUS	UEBRF	UEBRF	CHAR	1	0	FI Transfer (Indicator)
50	PAY_STATUS	UEBLG	UEBLG	CHAR	1	0	HR Payroll Transfer (Indicator)
51	DME_STATUS	UEBDT	UEBDT	CHAR	1	0	Data Medium Exchange Transfer (Indicator)
52	COUNTRY_GRP	MOLGA	MOLGA	CHAR	2	0	Country Grouping	*
53	TP_VARIANT	MOREI	MOREI	CHAR	2	0	Trip Provision Variant	*
54	.INCLU-SET				0	0	Date/Time of Trip Accounting
55	DATESET	PTRV_ACCDT	PTRV_BEGP1	DATS	8	0	Trip Settlement Date
56	TIMESET	PTRV_ACCTM	REUHR	TIMS	6	0	Trip Settlement Time
57	RUNID	TR_EVNUM	NUMC10	NUMC	10	0	Sequential number of posting run
58	NO_MILES	PTRV_NO_MILES_ACCOUNTING	CHAR1	CHAR	1	0	Indicator: No repeat of travel costs accounting
59	TLOCK	PTRV_TLOCK	PTRV_TLOCK	CHAR	1	0	Indicator: Trip locked
60	.INCLU-CHA				0	0	Time Last Change Was Made
61	DATECHA	AEDAT	DATUM	DATS	8	0	Last Changed On
62	TIMECHA	AEUHR	ATIME	TIMS	6	0	Time of Last Change
63	UNAME	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
64	REPID	AEREP	AEREP	CHAR	40	0	Change Report
65	REMOVAL_COSTS	PTRV_UZKVG	UMZUGSKVG	CHAR	1	0	Confirmation of Moving Costs Refund
66	DEPT_OF_REIMB	PTRV_ZUSAG	PTRV_CHAR25	CHAR	25	0	Admin. Office That Confirmed Moving Costs Compensation (PS)
67	DIFF_END_ALLW	PTRV_ENDRG	REDAT	DATS	8	0	Different End of Travel Allowance (in Separation Allowance)
68	DEPARTURE_WORK	PTRV_DEPARTURE_WORK	PTRV_DEPARTURE_WORK	CHAR	1	0	Departure from Residence or Place of Work
69	ARRIVAL_WORK	PTRV_ARRVL	PTRV_CHAR1	CHAR	1	0	Arrival Accommodations/New Place of Work
70	RETURN_TO	PTRV_RETRN	PTRV_CHAR1	CHAR	1	0	Return to residence/admin. office
71	NO_COMMENCEMENT_TRIP	PTRV_DANTN	REINR	NUMC	10	0	Trip Number of Corresponding Trip to Start Work
72	NO_RETURN_TRIP	PTRV_FINTN	REINR	NUMC	10	0	Trip Number of Associated Business Trip Return
73	.INCLU-DPE				0	0	Start of Leg of Trip
74	DATEDPE	REBED	REDAT	DATS	8	0	Beginning Date of Trip Segment
75	TIMEDPE	REBEU	REUHR	TIMS	6	0	Beginning Time of Trip Segment
76	.INCLU-APE				0	0	End of Leg of Trip
77	DATEAPE	REEND	REDAT	DATS	8	0	End Date of Trip Segment
78	TIMEAPE	REENU	REUHR	TIMS	6	0	End Time of Trip Segment
79	.INCLUDE				0	0	Period Data of Trip for Public Sector
80	ST_TAX_PD	PTRV_PS_ST_TRGTG	REDAT	DATS	8	0	Start of Taxation for Per Diem Separation Allowance
81	ST_TAX_ALL	PTRV_PS_ST_TRGALL	REDAT	DATS	8	0	Start of Taxation for Complete Separation Allowance
82	DAT_REDUC1	PTRV_PS_DAT_REDUC1	REDAT	DATS	8	0	Reduction of Entire Separation or Travel Allowance Level 1
83	DAT_REDUC2	PTRV_PS_DAT_REDUC2	REDAT	DATS	8	0	Reduction of Separation or Travel Allowance Level 2
84	.INCLU-COW				0	0	Time Work Commences
85	DATECOW	PTRV_PS_DATV1_DIENST	REDAT	DATS	8	0	Date of Commencement of Work
86	TIMECOW	PTRV_PS_UHRV1_DIENST	REUHR	TIMS	6	0	Time at Which Work Commences
87	.INCLU-EOW				0	0	Time Work Ends
88	DATEEOW	PTRV_PS_DATB1_DIENST	REDAT	DATS	8	0	Date on Which Work Ends
89	TIMEEOW	PTRV_PS_UHRB1_DIENST	REUHR	TIMS	6	0	Time at Which Work Ends
90	ASSO_SU_SEP_ALLO	PTRV_PS_ABORD	REINR	NUMC	10	0	Associated Superior Separation Allowance
91	SA_TAX_TYP	PTRV_PS_ST_TYP	CHAR1	CHAR	1	0	Temporary Assignment (Indicator)
92	SA_TAX_HOUSING	PTRV_ST_WOHN_TYP	CHAR1	CHAR	1	0	Home for Separation Allowance Taxation
93	DR_NO_O_A_R_TRIP	PTRVPS_TR_DOPP_ANZAHL	NUMC3	NUMC	3	0	Daily Return: No. of Days with Outb. and Return Trip
94	DR_NO_O_O_R_TRIP	PTRVPS_TR_EINF_ANZAHL	NUMC3	NUMC	3	0	Daily Return: No. of Days only with Outb./ or Return Trip
95	DR_DIST_TO_WORKP	PTRVPS_TR_ENTFERNUNG	KMANZ	DEC	5	0	Daily Return: Distance fr. Residence to New Place of Work
96	OC_NO_O_A_R_TRIP_B_MOVE	PTRVPS_VU_EA_DOPP_ANZAHL	NUMC3	NUMC	3	0	Own Contribution: No. of Days with Outb./Return Trip b. Move
97	OC_NO_O_O_R_TRIP_B_MOVE	PTRVPS_VU_EA_EINF_ANZAHL	NUMC3	NUMC	3	0	Own Contribution: No. of Days wth Outb./Return Trip b. Move
98	OC_DIST_TO_WORKP_B_MOVE	PTRVPS_VU_EA_ENTFERNUNG	KMANZ	DEC	5	0	Own Contribution: Distance to Place of Work before Move
99	OC_KM_RATE_WORKP_B_MOVE	PTRVPS_VU_EA_KM_SATZ	GESBE	CURR	10	2	Own Contribution: KM Rate to Place of Work Before Move
100	OC_NO_O_A_R_TRIP_A_MOVE	PTRVPS_NU_EA_DOPP_ANZAHL	NUMC3	NUMC	3	0	Own Contrib.: No. of Days wth Outb. and Ret. Trip after Move
101	OC_NO_O_O_R_TRIP_A_MOVE	PTRVPS_NU_EA_EINF_ANZAHL	NUMC3	NUMC	3	0	Own Contrib.: No. of Days with Outb. or Ret. Trip after Move
102	OC_DIST_TO_WORKP_A_MOVE	PTRVPS_NU_EA_ENTFERNUNG	KMANZ	DEC	5	0	Own Contribution: Distance to Place of Work after Move
103	OC_KM_RATE_WORKP_A_MOVE	PTRVPS_NU_EA_KM_SATZ	GESBE	CURR	10	2	Own Contribution: KM Rate to Place of Work after Move
104	GRAT_MEALS_PER_MONTH	PTRV_V_UNENTGELTLICH	CHAR1	CHAR	1	0	Gratuitous Meals for the Entire Month
105	GRAT_ACCMM_PER_MONTH	PTRV_U_UNENTGELTLICH	CHAR1	CHAR	1	0	Gratuitous Accommodations for the Entire Month
106	REIMB_GRP_DEDUCTN_PD	PTRV_REDUC_ERGRU	CHAR2	CHAR	2	0	New Reimbursement Group for Reduction in Meals per Diem
107	.INCLU-ADR				0	0	Travel Web Interface: Addresses
108	ADRNRADR	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
109	CITYADR	AD_CITY1	TEXT40	CHAR	40	0	City
110	CITY_DISTRICTADR	AD_CITY2	TEXT40	CHAR	40	0	District
111	POST_CODEADR	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
112	CITY_CODEADR	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
113	STREETADR	AD_STREET	TEXT60	CHAR	60	0	Street
114	HOUSE_NUMADR	AD_HSNM1	TEXT10	CHAR	10	0	House Number
115	COUNTRYADR	LAND1	LAND1	CHAR	3	0	Country Key	*
116	REGIONADR	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
117	EDITOR	PTRV_WEB_EDITOR		STRG	0	0	Editor in Web Structures
118	.INCLU-TAX				0	0	Fields for Controlling Taxation of Per Diems
119	TAX_PER_DIEMTAX	PTRV_TAX_PER_DIEM	XFELD	CHAR	1	0	Automatic Taxation of Meals and Accommodations Per Diems
120	TAX_PD_MANTAX	PTRV_TAX_PD_MAN	XFELD	CHAR	1	0	Manually Triggered Taxation of Meals Per Diems
121	TAX_OV_MANTAX	PTRV_TAX_OV_MAN	XFELD	CHAR	1	0	Manually Triggered Taxation of Accommodations Per Diems
122	EXCHANGE_DATE	PTRV_DATTN	REDAT	DATS	8	0	Reference Date of Trip
123	DZ_LIMIT_180	PTRV_PS_DZ_LIMIT_180	XFELD	CHAR	1	0	Limit DA Fee to 180 Days
124	ROUNDING	PTRV_ROUNDING	XFELD	CHAR	1	0	Travel Amounts Are Rounded (Indicator)
125	TAX_TRIP	PTRVPS_TAX_TRIP	XFELD	CHAR	1	0	Taxation of Whole Trip
126	.INCLUDE				0	0	Designations of General Trip Data
127	COUNTRY_REGION_NAME	TEXT_RGION	TRV25	CHAR	25	0	Name of Trip Country/Country Group/Region
128	RET_COUN_RGIO_NAME	TEXT_RGION	TRV25	CHAR	25	0	Name of Trip Country/Country Group/Region
129	RET_TTS_NAME	TEXT_BEREI	TRV25	CHAR	25	0	Name for enterprise-specific trip type
130	T_SCHEMA_NAME	TEXT_RSCHE	REITX	CHAR	30	0	Name for trip schema
131	TT_COMSP_NAME	TEXT_BEREI	TRV25	CHAR	25	0	Name for enterprise-specific trip type
132	TT_STATU_NAME	TEXT_KZREA	REITX	CHAR	30	0	Name for Statutory Trip Type
133	T_ACTYPE_NAME	TEXT_KZTKT	REITX	CHAR	30	0	Name for trip activity type
134	PAY_CURR_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
135	REQUEST_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
136	TRAVEL_PLAN_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
137	EXPENSES_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
138	PRINT_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
139	APPVL_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
140	SETTL_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
141	FIN_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
142	PAY_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
143	DME_STATUS_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
144	COUNTRY_GRP_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
145	TP_VARIANT_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text
146	DEPARTURE_WORK_NAME	LTEXT	TEXT40	CHAR	40	0	Long Text