SAP ABAP Table PTRV_WEB_GENERAL_DATA_INT (General Trip Data)

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_INT	Table Relationship Diagram
Short Description	General Trip Data

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