SAP ABAP Table V_PTRV_SREC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_PTRV_SREC	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

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

History

Last changed by/on	SAP	20130529
SAP Release Created in