SAP ABAP View V_PTRV_HEAD (Join to Tables PTRV_HEAD & PTRV_SHDR & PTRV_PERIO)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA (Package) Travel Expenses Application Dev. (R/3 Enterprise Core)

Basic Data

View Type	D	Database View
Database View	V_PTRV_HEAD
Short Description	Join to Tables PTRV_HEAD & PTRV_SHDR & PTRV_PERIO
Root table	PTRV_HEAD	General Trip Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PTRV_HEAD	PTRV_HEAD
2	PTRV_SHDR
3	PTRV_PERIO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PTRV_PERIO	MANDT	JL	EQ				0	0
2	PTRV_HEAD	MANDT	JR	EQ			AND	0	0
3	PTRV_PERIO	PERNR	JL	EQ				0	0
4	PTRV_HEAD	PERNR	JR	EQ			AND	0	0
5	PTRV_PERIO	HDVRS	JL	EQ				0	0
6	PTRV_HEAD	HDVRS	JR	EQ			AND	0	0
7	PTRV_PERIO	REINR	JL	EQ				0	0
8	PTRV_HEAD	REINR	JR	EQ			AND	0	0
9	PTRV_SHDR	MANDT	JL	EQ				0	0
10	PTRV_PERIO	MANDT	JR	EQ			AND	0	0
11	PTRV_SHDR	PERNR	JL	EQ				0	0
12	PTRV_PERIO	PERNR	JR	EQ			AND	0	0
13	PTRV_SHDR	REINR	JL	EQ				0	0
14	PTRV_PERIO	REINR	JR	EQ			AND	0	0
15	PTRV_SHDR	PERIO	JL	EQ				0	0
16	PTRV_PERIO	PERIO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	PTRV_HEAD	*		☐		☐
2	MANDT	PTRV_HEAD	MANDT		☐	MANDT	☐	Client
3	PERNR	PTRV_HEAD	PERNR		☐	PERNR_D	☐	Personnel Number
4	REINR	PTRV_HEAD	REINR		☐	REINR	☐	Trip Number
5	HDVRS	PTRV_HEAD	HDVRS		☐	PTRV_HDVRS	☐	Sequential Number of Travel Expenses Table THEADER
6	MOLGA	PTRV_HEAD	MOLGA		☐	MOLGA	☐	Country Grouping
7	MOREI	PTRV_HEAD	MOREI		☐	MOREI	☐	Trip Provision Variant
8	SCHEM	PTRV_HEAD	SCHEM		☐	RSCHE	☐	Trip schema
9	KZREA	PTRV_HEAD	KZREA		☐	KZREA	☐	Trip Type: Statutory
10	BEREI	PTRV_HEAD	BEREI		☐	BEREI	☐	Trip Type: Enterprise-Specific
11	KZTKT	PTRV_HEAD	KZTKT		☐	KZTKT	☐	Trip Activity Type
12	ZORT1	PTRV_HEAD	ZORT1		☐	RZIELORT	☐	Location
13	ZLAND	PTRV_HEAD	ZLAND		☐	LNDGR	☐	Trip Country / Trip Country Group
14	HRGIO	PTRV_HEAD	HRGIO		☐	HRGIO	☐	Region of Main Destination
15	NDNST	PTRV_HEAD	NDNST		☐	PTRV_NDNST	☐	Name of new administrative office (P.S.)
16	KUNDE	PTRV_HEAD	KUNDE		☐	RKUNDE	☐	Reason for Trip (for example, customer/requisitioner)
17	DATV1	PTRV_HEAD	DATV1		☐	REBED	☐	Beginning Date of Trip Segment
18	UHRV1	PTRV_HEAD	UHRV1		☐	REBEU	☐	Beginning Time of Trip Segment
19	DATB1	PTRV_HEAD	DATB1		☐	REEND	☐	End Date of Trip Segment
20	UHRB1	PTRV_HEAD	UHRB1		☐	REENU	☐	End Time of Trip Segment
21	DATH1	PTRV_HEAD	DATH1		☐	DATGH	☐	Border Crossing (Trip Out): Date
22	UHRH1	PTRV_HEAD	UHRH1		☐	UHRGH	☐	Time: Border crossing(trip out)
23	DATR1	PTRV_HEAD	DATR1		☐	DATGZ	☐	Border Crossing (Return Trip): Date
24	UHRR1	PTRV_HEAD	UHRR1		☐	UHRGZ	☐	Time: Border crossing(return trip)
25	AGRZ1	PTRV_HEAD	AGRZ1		☐	LNDGR	☐	Trip Country / Trip Country Group
26	GRGIO	PTRV_HEAD	GRGIO		☐	GRGIO	☐	Region of Border Crossing: Return Trip
27	GRBER	PTRV_HEAD	GRBER		☐	PTRV_GRBER	☐	Border crossing: Trip type enterprise-specific
28	UZKVG	PTRV_HEAD	UZKVG		☐	PTRV_UZKVG	☐	Confirmation of Moving Costs Refund
29	ZUSAG	PTRV_HEAD	ZUSAG		☐	PTRV_ZUSAG	☐	Admin. Office That Confirmed Moving Costs Compensation (PS)
30	ENDRG	PTRV_HEAD	ENDRG		☐	PTRV_ENDRG	☐	Different End of Travel Allowance (in Separation Allowance)
31	DEPAR	PTRV_HEAD	DEPAR		☐	PTRV_DEPAR	☐	Departure from Residence or Place of Work
32	ARRVL	PTRV_HEAD	ARRVL		☐	PTRV_ARRVL	☐	Arrival Accommodations/New Place of Work
33	RETRN	PTRV_HEAD	RETRN		☐	PTRV_RETRN	☐	Return to residence/admin. office
34	DATES	PTRV_HEAD	DATES		☐	AEDAT	☐	Last Changed On
35	TIMES	PTRV_HEAD	TIMES		☐	AEUHR	☐	Time of Last Change
36	UNAME	PTRV_HEAD	UNAME		☐	AENAM	☐	Name of Person Who Changed Object
37	REPID	PTRV_HEAD	REPID		☐	AEREP	☐	Change Report
38	DANTN	PTRV_HEAD	DANTN		☐	PTRV_DANTN	☐	Trip Number of Corresponding Trip to Start Work
39	FINTN	PTRV_HEAD	FINTN		☐	PTRV_FINTN	☐	Trip Number of Associated Business Trip Return
40	REQUEST	PTRV_HEAD	REQUEST		☐	PTRV_OBJEKT	☐	Indicator for objects request, plan and expense report
41	TRAVEL_PLAN	PTRV_HEAD	TRAVEL_PLAN		☐	PTRV_OBJEKT	☐	Indicator for objects request, plan and expense report
42	EXPENSES	PTRV_HEAD	EXPENSES		☐	PTRV_OBJEKT	☐	Indicator for objects request, plan and expense report
43	ST_TRGTG	PTRV_HEAD	ST_TRGTG		☐	PTRV_PS_ST_TRGTG	☐	Start of Taxation for Per Diem Separation Allowance
44	ST_TRGALL	PTRV_HEAD	ST_TRGALL		☐	PTRV_PS_ST_TRGALL	☐	Start of Taxation for Complete Separation Allowance
45	PERIODENART	PTRV_HEAD	PERIODENART		☐	PTRV_PS_PERIODENART	☐	Associated Trip Period Types
46	DAT_REDUC1	PTRV_HEAD	DAT_REDUC1		☐	PTRV_PS_DAT_REDUC1	☐	Reduction of Entire Separation or Travel Allowance Level 1
47	DAT_REDUC2	PTRV_HEAD	DAT_REDUC2		☐	PTRV_PS_DAT_REDUC2	☐	Reduction of Separation or Travel Allowance Level 2
48	DATV1_DIENST	PTRV_HEAD	DATV1_DIENST		☐	PTRV_PS_DATV1_DIENST	☐	Date of Commencement of Work
49	UHRV1_DIENST	PTRV_HEAD	UHRV1_DIENST		☐	PTRV_PS_UHRV1_DIENST	☐	Time at Which Work Commences
50	DATB1_DIENST	PTRV_HEAD	DATB1_DIENST		☐	PTRV_PS_DATB1_DIENST	☐	Date on Which Work Ends
51	UHRB1_DIENST	PTRV_HEAD	UHRB1_DIENST		☐	PTRV_PS_UHRB1_DIENST	☐	Time at Which Work Ends
52	ABORDNUNG	PTRV_HEAD	ABORDNUNG		☐	PTRV_PS_ABORD	☐	Associated Superior Separation Allowance
53	ST_TRG_TYP	PTRV_HEAD	ST_TRG_TYP		☐	PTRV_PS_ST_TYP	☐	Temporary Assignment (Indicator)
54	ST_WOHN_TYP	PTRV_HEAD	ST_WOHN_TYP		☐	PTRV_ST_WOHN_TYP	☐	Home for Separation Allowance Taxation
55	KEIN_REISEGELD	PTRV_HEAD	KEIN_REISEGELD		☐	PTRV_KEIN_REISEGELD	☐	No Separation Allowance for Travel Is Paid (Indicator)
56	TAX_PER_DIEM	PTRV_HEAD	TAX_PER_DIEM		☐	PTRV_TAX_PER_DIEM	☐	Automatic Taxation of Meals and Accommodations Per Diems
57	TAX_PD_MAN	PTRV_HEAD	TAX_PD_MAN		☐	PTRV_TAX_PD_MAN	☐	Manually Triggered Taxation of Meals Per Diems
58	TAX_OV_MAN	PTRV_HEAD	TAX_OV_MAN		☐	PTRV_TAX_OV_MAN	☐	Manually Triggered Taxation of Accommodations Per Diems
59	EXCHANGE_DATE	PTRV_HEAD	EXCHANGE_DATE		☐	PTRV_DATTN	☐	Reference Date of Trip
60	ROUNDING	PTRV_HEAD	ROUNDING		☐	PTRV_ROUNDING	☐	Travel Amounts Are Rounded (Indicator)
61	DZ_LIMIT_180	PTRV_HEAD	DZ_LIMIT_180		☐	PTRV_PS_DZ_LIMIT_180	☐	Limit DA Fee to 180 Days
62	*	PTRV_PERIO	*		☐		☐
63	-	PTRV_PERIO	MANDT		☐	MANDT	☐	Client
64	-	PTRV_PERIO	PERNR		☐	PERNR_D	☐	Personnel Number
65	-	PTRV_PERIO	REINR		☐	REINR	☐	Trip Number
66	PERIO	PTRV_PERIO	PERIO		☐	PTRV_PEROD	☐	Trip Period Number
67	PDVRS	PTRV_PERIO	PDVRS		☐	PTRV_PDVRS	☐	Sequential Number of Period
68	-	PTRV_PERIO	HDVRS		☐	PTRV_HDVRS	☐	Sequential Number of Travel Expenses Table THEADER
69	PDATV	PTRV_PERIO	PDATV		☐	REBED	☐	Beginning Date of Trip Segment
70	PUHRV	PTRV_PERIO	PUHRV		☐	REBEU	☐	Beginning Time of Trip Segment
71	PDATB	PTRV_PERIO	PDATB		☐	REEND	☐	End Date of Trip Segment
72	PUHRB	PTRV_PERIO	PUHRB		☐	REENU	☐	End Time of Trip Segment
73	DRUCK	PTRV_PERIO	DRUCK		☐	P_PRINT	☐	Trip Print Status
74	ANTRG	PTRV_PERIO	ANTRG		☐	ANTRG	☐	Travel Request or Trip Approved (Indicator)
75	ABREC	PTRV_PERIO	ABREC		☐	ABREC	☐	Open / To be Settled / Settled (Indicator)
76	UEBLG	PTRV_PERIO	UEBLG		☐	UEBLG	☐	HR Payroll Transfer (Indicator)
77	UEBRF	PTRV_PERIO	UEBRF		☐	UEBRF	☐	FI Transfer (Indicator)
78	UEBDT	PTRV_PERIO	UEBDT		☐	UEBDT	☐	Data Medium Exchange Transfer (Indicator)
79	TLOCK	PTRV_PERIO	TLOCK		☐	PTRV_TLOCK	☐	Indicator: Trip locked
80	WAERS	PTRV_PERIO	WAERS		☐	WAERS	☐	Currency Key
81	ABRJ1	PTRV_PERIO	ABRJ1		☐	PABRJ	☐	Payroll Year
82	ABRP1	PTRV_PERIO	ABRP1		☐	PABRP	☐	Payroll Period
83	PERM1	PTRV_PERIO	PERM1		☐	IPERM	☐	Period modifier
84	ABKR1	PTRV_PERIO	ABKR1		☐	ABKRS	☐	Payroll Area
85	BEGP1	PTRV_PERIO	BEGP1		☐	PTRV_BEGP1	☐	Start of Settlement Period
86	ENDP1	PTRV_PERIO	ENDP1		☐	PTRV_ENDP1	☐	End of Settlement Period
87	ABRJ2	PTRV_PERIO	ABRJ2		☐	PABRJ	☐	Payroll Year
88	ABRP2	PTRV_PERIO	ABRP2		☐	PABRP	☐	Payroll Period
89	PERM2	PTRV_PERIO	PERM2		☐	IPERM	☐	Period modifier
90	ABKR2	PTRV_PERIO	ABKR2		☐	ABKRS	☐	Payroll Area
91	BEGP2	PTRV_PERIO	BEGP2		☐	PTRV_BEGP2	☐	Start of Settlement Period
92	ENDP2	PTRV_PERIO	ENDP2		☐	PTRV_ENDP2	☐	End of Settlement Period
93	ACCDT	PTRV_PERIO	ACCDT		☐	PTRV_ACCDT	☐	Trip Settlement Date
94	ACCTM	PTRV_PERIO	ACCTM		☐	PTRV_ACCTM	☐	Trip Settlement Time
95	RUNID	PTRV_PERIO	RUNID		☐	TR_EVNUM	☐	Sequential number of posting run
96	VERPA	PTRV_PERIO	VERPA		☐	VERPA	☐	Per-Diem Accounting for Meals
97	UEBKZ	PTRV_PERIO	UEBKZ		☐	UEPKZ	☐	Per-Diem Accounting for Accommodations
98	ANUEP	PTRV_PERIO	ANUEP		☐	ANUEP	☐	Number of Overnight Stays for Per-Diem Settlement
99	NO_MILES	PTRV_PERIO	NO_MILES		☐	PTRV_NO_MILES_ACCOUNTING	☐	Indicator: No repeat of travel costs accounting
100	LSTAY	PTRV_PERIO	LSTAY		☐	PTRV_LSTAY	☐	Meals per diem reduct. for longer stay at same place of work
101	TR_DOPP_ANZAHL	PTRV_PERIO	TR_DOPP_ANZAHL		☐	PTRVPS_TR_DOPP_ANZAHL	☐	Daily Return: No. of Days with Outb. and Return Trip
102	TR_EINF_ANZAHL	PTRV_PERIO	TR_EINF_ANZAHL		☐	PTRVPS_TR_EINF_ANZAHL	☐	Daily Return: No. of Days only with Outb./ or Return Trip
103	TR_ENTFERNUNG	PTRV_PERIO	TR_ENTFERNUNG		☐	PTRVPS_TR_ENTFERNUNG	☐	Daily Return: Distance fr. Residence to New Place of Work
104	VU_EA_DOPP_ANZ	PTRV_PERIO	VU_EA_DOPP_ANZ		☐	PTRVPS_VU_EA_DOPP_ANZAHL	☐	Own Contribution: No. of Days with Outb./Return Trip b. Move
105	VU_EA_EINF_ANZ	PTRV_PERIO	VU_EA_EINF_ANZ		☐	PTRVPS_VU_EA_EINF_ANZAHL	☐	Own Contribution: No. of Days wth Outb./Return Trip b. Move
106	VU_EA_ENTFERN	PTRV_PERIO	VU_EA_ENTFERN		☐	PTRVPS_VU_EA_ENTFERNUNG	☐	Own Contribution: Distance to Place of Work before Move
107	VU_EA_KM_SATZ	PTRV_PERIO	VU_EA_KM_SATZ		☐	PTRVPS_VU_EA_KM_SATZ	☐	Own Contribution: KM Rate to Place of Work Before Move
108	NU_EA_DOPP_ANZ	PTRV_PERIO	NU_EA_DOPP_ANZ		☐	PTRVPS_NU_EA_DOPP_ANZAHL	☐	Own Contrib.: No. of Days wth Outb. and Ret. Trip after Move
109	NU_EA_EINF_ANZ	PTRV_PERIO	NU_EA_EINF_ANZ		☐	PTRVPS_NU_EA_EINF_ANZAHL	☐	Own Contrib.: No. of Days with Outb. or Ret. Trip after Move
110	NU_EA_ENTFERN	PTRV_PERIO	NU_EA_ENTFERN		☐	PTRVPS_NU_EA_ENTFERNUNG	☐	Own Contribution: Distance to Place of Work after Move
111	NU_EA_KM_SATZ	PTRV_PERIO	NU_EA_KM_SATZ		☐	PTRVPS_NU_EA_KM_SATZ	☐	Own Contribution: KM Rate to Place of Work after Move
112	V_UNENTGELTLICH	PTRV_PERIO	V_UNENTGELTLICH		☐	PTRV_V_UNENTGELTLICH	☐	Gratuitous Meals for the Entire Month
113	U_UNENTGELTLICH	PTRV_PERIO	U_UNENTGELTLICH		☐	PTRV_U_UNENTGELTLICH	☐	Gratuitous Accommodations for the Entire Month
114	REDUC_ERGRU	PTRV_PERIO	REDUC_ERGRU		☐	PTRV_REDUC_ERGRU	☐	New Reimbursement Group for Reduction in Meals per Diem
115	NOT_PAID	PTRV_PERIO	NOT_PAID		☐	PTRV_NOT_PAID	☐	No Reimbursement of Trip
116	WEG_ERH_MAX	PTRV_PERIO	WEG_ERH_MAX		☐	PTRV_WEG_ERH_MAX	☐	Increased Maximum Trip Segment Reimbursement
117	ERH_DIENST_INT	PTRV_PERIO	ERH_DIENST_INT		☐	PTRV_ERH_DIENST_INT	☐	Significant Official Interest
118	ENTF_WO_DO	PTRV_PERIO	ENTF_WO_DO		☐	PTRV_ENTF_WO_DO	☐	Short Distance to Residence/Workplace
119	DRITTMITTEL	PTRV_PERIO	DRITTMITTEL		☐	PTRV_DRITTMITTEL	☐	Payments and Contributions from Third Parties
120	ANTRAG_GWE	PTRV_PERIO	ANTRAG_GWE		☐	PTRV_ANTRAG_GWE	☐	Request for Full Trip Segment Reimbursement
121	POLICY_VIOLATION	PTRV_PERIO	POLICY_VIOLATION		☐	PTRV_POLICY_VIOLATION	☐	Violation of Travel Policy
122	EXCEPTION_FLAG	PTRV_PERIO	EXCEPTION_FLAG		☐	PTRV_EXCEPTION	☐	Exception Indicator
123	NR_RECEIPTS	PTRV_PERIO	NR_RECEIPTS		☐	PTRV_NR_RECEIPTS	☐	Number of Receipts
124	PERM_TRIP_APPR	PTRV_PERIO	PERM_TRIP_APPR		☐	PTRV_PERM_TRIP_APPROVAL	☐	Standing Approval of Business Trips
125	TR_NR_FROM_HOME	PTRV_PERIO	TR_NR_FROM_HOME		☐	PTRVPS_NR_COMMUTES_FROM_HOME	☐	Number of Days with Round Trip from Home
126	VAT_STATUS	PTRV_PERIO	VAT_STATUS		☐	PTRV_VAT_STATUS	☐	Status of Data for VAT Refund
127	TAX_TRIP	PTRV_PERIO	TAX_TRIP		☐	PTRVPS_TAX_TRIP	☐	Taxation of Whole Trip
128	*	PTRV_SHDR	*		☐		☐
129	-	PTRV_SHDR	MANDT		☐	MANDT	☐	Client
130	-	PTRV_SHDR	PERNR		☐	PERNR_D	☐	Personnel Number
131	-	PTRV_SHDR	REINR		☐	REINR	☐	Trip Number
132	-	PTRV_SHDR	PERIO		☐	PTRV_PEROD	☐	Trip Period Number
133	SEQNO	PTRV_SHDR	SEQNO		☐	PTRV_SHDRSEQNO	☐	Sequential number for trip totals
134	ADDIT_AMNT	PTRV_SHDR	ADDIT_AMNT		☐	PTRV_ADDIT_AMNT	☐	Additional Amount of a Trip (Taxable for Employee)
135	SUM_REIMBU	PTRV_SHDR	SUM_REIMBU		☐	PTRV_SUM_REIMBU	☐	Reimbursement Amount for a Trip
136	SUM_ADVANC	PTRV_SHDR	SUM_ADVANC		☐	PTRV_SUM_ADVANC	☐	Total Advances for a Trip
137	SUM_PAYOUT	PTRV_SHDR	SUM_PAYOUT		☐	PTRV_SUM_PAYOUT	☐	Payment Amount
138	SUM_PAIDCO	PTRV_SHDR	SUM_PAIDCO		☐	PTRV_SUM_PAIDCO	☐	Travel Expenses Paid by Company
139	TRIP_TOTAL	PTRV_SHDR	TRIP_TOTAL		☐	PTRV_TRIP_TOTAL	☐	Total Cost of Trip
140	PD_FOOD	PTRV_SHDR	PD_FOOD		☐	PTRV_PD_FOOD	☐	Reimbursement Amount (Total) for Meals per Diems
141	PD_HOUSING	PTRV_SHDR	PD_HOUSING		☐	PTRV_PD_HOUSING	☐	Reimbursement Amount (Total) for Accommodations per Diems
142	PD_MILEAGE	PTRV_SHDR	PD_MILEAGE		☐	PTRV_PD_MILEAGE	☐	Reimbursement Amount (Total) for Travel Flat Rates
143	CURRENCY	PTRV_SHDR	CURRENCY		☐	TRVWAERS	☐	Currency Key
144	M_TOTAL	PTRV_SHDR	M_TOTAL		☐	KMGES	☐	Total Miles/Kilometers
145	TRIPDUR	PTRV_SHDR	TRIPDUR		☐	PTRV_TRIPDUR	☐	Trip Duration in Days
146	CHNGDATE	PTRV_SHDR	CHNGDATE		☐	AEDAT	☐	Last Changed On
147	CHNGTIME	PTRV_SHDR	CHNGTIME		☐	AEUHR	☐	Time of Last Change
148	TXF_FOOD	PTRV_SHDR	TXF_FOOD		☐	PTRV_TXF_FOOD	☐	Total of Tax-Exempt Paid Meals per Diems

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in