SAP ABAP View V_PTRV_APPR (Join to Tables PTRV_HEAD & 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_APPR
Short Description	Join to Tables PTRV_HEAD & 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_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				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PTRV_PERIO	MANDT		☐	MANDT	☐	Client
2	PERNR	PTRV_PERIO	PERNR		☐	PERNR_D	☐	Personnel Number
3	REINR	PTRV_PERIO	REINR		☐	REINR	☐	Trip Number
4	PERIO	PTRV_PERIO	PERIO		☐	PTRV_PEROD	☐	Trip Period Number
5	PDVRS	PTRV_PERIO	PDVRS		☐	PTRV_PDVRS	☐	Sequential Number of Period
6	DRUCK	PTRV_PERIO	DRUCK		☐	P_PRINT	☐	Trip Print Status
7	ANTRG	PTRV_PERIO	ANTRG		☐	ANTRG	☐	Travel Request or Trip Approved (Indicator)
8	ABREC	PTRV_PERIO	ABREC		☐	ABREC	☐	Open / To be Settled / Settled (Indicator)
9	UEBLG	PTRV_PERIO	UEBLG		☐	UEBLG	☐	HR Payroll Transfer (Indicator)
10	UEBRF	PTRV_PERIO	UEBRF		☐	UEBRF	☐	FI Transfer (Indicator)
11	UEBDT	PTRV_PERIO	UEBDT		☐	UEBDT	☐	Data Medium Exchange Transfer (Indicator)
12	VERPA	PTRV_PERIO	VERPA		☐	VERPA	☐	Per-Diem Accounting for Meals
13	ABRJ1	PTRV_PERIO	ABRJ1		☐	PABRJ	☐	Payroll Year
14	ABRP1	PTRV_PERIO	ABRP1		☐	PABRP	☐	Payroll Period
15	PERM1	PTRV_PERIO	PERM1		☐	IPERM	☐	Period modifier
16	ABKR1	PTRV_PERIO	ABKR1		☐	ABKRS	☐	Payroll Area
17	WAERS	PTRV_PERIO	WAERS		☐	WAERS	☐	Currency Key
18	HDVRS	PTRV_HEAD	HDVRS		☐	PTRV_HDVRS	☐	Sequential Number of Travel Expenses Table THEADER
19	MOREI	PTRV_HEAD	MOREI		☐	MOREI	☐	Trip Provision Variant
20	SCHEM	PTRV_HEAD	SCHEM		☐	RSCHE	☐	Trip schema
21	ZORT1	PTRV_HEAD	ZORT1		☐	RZIELORT	☐	Location
22	ZLAND	PTRV_HEAD	ZLAND		☐	LNDGR	☐	Trip Country / Trip Country Group
23	HRGIO	PTRV_HEAD	HRGIO		☐	HRGIO	☐	Region of Main Destination
24	KUNDE	PTRV_HEAD	KUNDE		☐	RKUNDE	☐	Reason for Trip (for example, customer/requisitioner)
25	DATV1	PTRV_HEAD	DATV1		☐	REBED	☐	Beginning Date of Trip Segment
26	UHRV1	PTRV_HEAD	UHRV1		☐	REBEU	☐	Beginning Time of Trip Segment
27	DATB1	PTRV_HEAD	DATB1		☐	REEND	☐	End Date of Trip Segment
28	UHRB1	PTRV_HEAD	UHRB1		☐	REENU	☐	End Time of Trip Segment
29	REQUEST	PTRV_HEAD	REQUEST		☐	PTRV_OBJEKT	☐	Indicator for objects request, plan and expense report
30	TRAVEL_PLAN	PTRV_HEAD	TRAVEL_PLAN		☐	PTRV_OBJEKT	☐	Indicator for objects request, plan and expense report
31	EXPENSES	PTRV_HEAD	EXPENSES		☐	PTRV_OBJEKT	☐	Indicator for objects request, plan and expense report

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