SAP ABAP View V_PTRV_SREC (Join to PTRV_SREC & PTRV_SADD)

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_SREC
Short Description	Join to PTRV_SREC & PTRV_SADD
Root table	PTRV_SREC	Trip Statistics - Receipts

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PTRV_SREC	PTRV_SREC
2	PTRV_SADD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PTRV_SADD	MANDT	JL	EQ				0	0
2	PTRV_SREC	MANDT	JR	EQ			AND	0	0
3	PTRV_SADD	PERNR	JL	EQ				0	0
4	PTRV_SREC	PERNR	JR	EQ			AND	0	0
5	PTRV_SADD	REINR	JL	EQ				0	0
6	PTRV_SREC	REINR	JR	EQ			AND	0	0
7	PTRV_SADD	PERIO	JL	EQ				0	0
8	PTRV_SREC	PERIO	JR	EQ			AND	0	0
9	PTRV_SADD	RECEIPTNO	JL	EQ				0	0
10	PTRV_SREC	RECEIPTNO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	PTRV_SREC	*		☐		☐
2	MANDT	PTRV_SREC	MANDT		☐	MANDT	☐	Client
3	PERNR	PTRV_SREC	PERNR		☐	PERNR_D	☐	Personnel Number
4	REINR	PTRV_SREC	REINR		☐	REINR	☐	Trip Number
5	PERIO	PTRV_SREC	PERIO		☐	PTRV_PEROD	☐	Trip Period Number
6	RECEIPTNO	PTRV_SREC	RECEIPTNO		☐	NRBEL	☐	Document Number
7	SEQNO	PTRV_SREC	SEQNO		☐	PTRV_RECSEQNO	☐	Sequential number for receipts
8	DED_FLAG	PTRV_SREC	DED_FLAG		☐	BELAZ	☐	Deduction Indicator
9	PAID_COM	PTRV_SREC	PAID_COM		☐	BEZFA	☐	Paid by Company
10	EXP_TYPE	PTRV_SREC	EXP_TYPE		☐	SPKZL	☐	Travel Expense Type
11	REC_AMOUNT	PTRV_SREC	REC_AMOUNT		☐	PTRV_REC_AMOUNT	☐	Amount on Individual Receipt
12	REC_CURR	PTRV_SREC	REC_CURR		☐	WAERS	☐	Currency Key
13	REC_RATE	PTRV_SREC	REC_RATE		☐	REC_RATE	☐	Exchange rate
14	LOC_AMOUNT	PTRV_SREC	LOC_AMOUNT		☐	PTRV_LOC_AMOUNT	☐	Receipt amount in local currency
15	LOC_CURR	PTRV_SREC	LOC_CURR		☐	WAERS	☐	Currency Key
16	TAX_CODE	PTRV_SREC	TAX_CODE		☐	MWSKZ	☐	Tax on sales/purchases code
17	REC_DATE	PTRV_SREC	REC_DATE		☐	BELDT	☐	Receipt Date
18	SHORTTXT	PTRV_SREC	SHORTTXT		☐	TXBEL	☐	Short Receipt Information
19	ABOVE_LIMIT	PTRV_SREC	ABOVE_LIMIT		☐	PTRV_ABOVE_LIMIT	☐	Customizing Limit for Travel Expense Type Exceeded
20	PAPER_RECEIPT	PTRV_SREC	PAPER_RECEIPT		☐	PAPER_RECEIPT	☐	Paper Receipt Exists
21	RECEIPT_OK	PTRV_SREC	RECEIPT_OK		☐	RECEIPT_VALIDATED	☐	Expense Receipt Checked
22	PAYOT	PTRV_SREC	PAYOT		☐	PAYOT	☐	Service Provider
23	PAPER_MISSING	PTRV_SREC	PAPER_MISSING		☐	PAPER_MISSING	☐	Required Paper Receipt Is Missing
24	RECEIPT_NO	PTRV_SREC	RECEIPT_NO		☐	PTRV_RECEIPT_NO	☐	Invoice Number of Original Receipt
25	RECEIPT_ITEM	PTRV_SREC	RECEIPT_ITEM		☐	PTRV_RECEIPT_ITEM	☐	Number of Invoice Item
26	REC_FWSTE	PTRV_SREC	REC_FWSTE		☐	WMWST	☐	Tax amount in document currency
27	LOC_FWSTE	PTRV_SREC	LOC_FWSTE		☐	WMWST	☐	Tax amount in document currency
28	VAT_POSTING_TYPE	PTRV_SREC	VAT_POSTING_TYPE		☐	PTRV_VAT_POSTING_TYPE	☐	Reporting and Posting of VAT Amount
29	VAT_SERVICE_CODE	PTRV_SREC	VAT_SERVICE_CODE		☐	PTRV_VAT_SERVICE_CODE	☐	Type of Goods and Services
30	VAT_SERVICE_DESC	PTRV_SREC	VAT_SERVICE_DESC		☐	PTRV_VAT_SERVICE_DESC	☐	Description of Goods and Services
31	VAT_STATUS	PTRV_SREC	VAT_STATUS		☐	PTRV_VAT_STATUS	☐	Status of Data for VAT Refund
32	VAT_CHANGED_MAN	PTRV_SREC	VAT_CHANGED_MAN		☐	PTRV_VAT_CHANGED_MAN	☐	VAT Amount Changed Manually
33	*	PTRV_SADD	*		☐		☐
34	-	PTRV_SADD	MANDT		☐	MANDT	☐	Client
35	-	PTRV_SADD	PERNR		☐	PERNR_D	☐	Personnel Number
36	-	PTRV_SADD	REINR		☐	REINR	☐	Trip Number
37	-	PTRV_SADD	PERIO		☐	PTRV_PEROD	☐	Trip Period Number
38	-	PTRV_SADD	RECEIPTNO		☐	NRBEL	☐	Document Number
39	NO_BRFT	PTRV_SADD	NO_BRFT		☐	FRANZ	☐	Number of Breakfasts
40	COUNTRY	PTRV_SADD	COUNTRY		☐	LNDGR	☐	Trip Country / Trip Country Group
41	REGION	PTRV_SADD	REGION		☐	RGION	☐	Trip Country/Trip Country Group/Trip Region
42	TT_COMSP	PTRV_SADD	TT_COMSP		☐	BEREI	☐	Trip Type: Enterprise-Specific
43	FROM_DATE	PTRV_SADD	FROM_DATE		☐	FRDAT	☐	From Date
44	TO_DATE	PTRV_SADD	TO_DATE		☐	TODAT	☐	To Date
45	MULTIPLI	PTRV_SADD	MULTIPLI		☐	ERANZ	☐	Number
46	DESCRIPT	PTRV_SADD	DESCRIPT		☐	ERDES	☐	Description
47	LOCATION	PTRV_SADD	LOCATION		☐	ERPLC	☐	Location
48	BUS_PURPO	PTRV_SADD	BUS_PURPO		☐	BUSPU	☐	Business Purpose
49	BUS_REASON	PTRV_SADD	BUS_REASON		☐	BUSRE	☐	Business Partners
50	CCOMP	PTRV_SADD	CCOMP		☐	CCOMP	☐	Code of Payment Card Company
51	C_DOC	PTRV_SADD	C_DOC		☐	C_DOC	☐	Document Number of Credit Card Receipt
52	C_TXT	PTRV_SADD	C_TXT		☐	C_TXT	☐	Delivered Description of a Credit Card Transaction
53	P_CTG	PTRV_SADD	P_CTG		☐	PROVIDER_CATEGORY	☐	Provider Category
54	P_PRV	PTRV_SADD	P_PRV		☐	PROVIDER_CODE	☐	Provider Code
55	P_DOC	PTRV_SADD	P_DOC		☐	P_DOC	☐	Document Number of a (Paper) Document
56	N_STF	PTRV_SADD	N_STF		☐	CH_NO_STAFF	☐	Number of Employees
57	N_PTN	PTRV_SADD	N_PTN		☐	CH_NO_PARTNERS	☐	Number of Employees of Business Partners
58	N_GST	PTRV_SADD	N_GST		☐	CH_NO_GUESTS	☐	Number of Additional Guests
59	ANZLU_DEC	PTRV_SADD	ANZLU_DEC		☐	PTRV_ANZLU_DEC	☐	Number of Lunches on Hotel Receipt
60	ANZDI_DEC	PTRV_SADD	ANZDI_DEC		☐	PTRV_ANZDI_DEC	☐	Number of Dinners on Hotel Receipt

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