SAP ABAP Table PTRV_SREC (Trip Statistics - Receipts)

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

Table Category	TRANSP	Transparent table
Transparent table	PTRV_SREC	Table Relationship Diagram
Short Description	Trip Statistics - Receipts

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	Trip Statistics - Key Fields
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	REINR	☑	REINR	REINR	NUMC	10	0	Trip Number
5	PERIO	☑	PTRV_PEROD	PTRV_PEROD	NUMC	3	0	Trip Period Number
6	RECEIPTNO	☑	NRBEL	NRBEL	CHAR	3	0	Document Number
7	SEQNO	☑	PTRV_RECSEQNO	NUMC2	NUMC	2	0	Sequential number for receipts
8	DED_FLAG	☐	BELAZ	BELAZ	CHAR	1	0	Deduction Indicator
9	PAID_COM	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
10	EXP_TYPE	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
11	REC_AMOUNT	☐	PTRV_REC_AMOUNT	WERTV7	CURR	13	2	Amount on Individual Receipt
12	REC_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
13	REC_RATE	☐	REC_RATE	UKURS	DEC	9	5	Exchange rate
14	LOC_AMOUNT	☐	PTRV_LOC_AMOUNT	WERTV7	CURR	13	2	Receipt amount in local currency
15	LOC_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
16	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
17	REC_DATE	☐	BELDT	REDAT	DATS	8	0	Receipt Date
18	SHORTTXT	☐	TXBEL	TXBEL	CHAR	10	0	Short Receipt Information
19	ABOVE_LIMIT	☐	PTRV_ABOVE_LIMIT	P_ATYPE	CHAR	1	0	Customizing Limit for Travel Expense Type Exceeded
20	.INCLU--AP	☐				0	0	Enhancement of Receipt Statistics
21	PAPER_RECEIPT	☐	PAPER_RECEIPT	XFELD	CHAR	1	0	Paper Receipt Exists
22	RECEIPT_OK	☐	RECEIPT_VALIDATED	XFELD	CHAR	1	0	Expense Receipt Checked
23	PAYOT	☐	PAYOT	PAYOT	CHAR	2	0	Service Provider	*
24	PAPER_MISSING	☐	PAPER_MISSING	P_ATYPE	CHAR	1	0	Required Paper Receipt Is Missing
25	RECEIPT_NO	☐	PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Receipt
26	RECEIPT_ITEM	☐	PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
27	REC_FWSTE	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
28	LOC_FWSTE	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
29	VAT_POSTING_TYPE	☐	PTRV_VAT_POSTING_TYPE	PTRV_VAT_POSTING_TYPE	CHAR	1	0	Reporting and Posting of VAT Amount
30	VAT_SERVICE_CODE	☐	PTRV_VAT_SERVICE_CODE	PTRV_VAT_SERVICE_CODE	CHAR	3	0	Type of Goods and Services	*
31	VAT_SERVICE_DESC	☐	PTRV_VAT_SERVICE_DESC	TEXT100	CHAR	100	0	Description of Goods and Services
32	VAT_STATUS	☐	PTRV_VAT_STATUS	PTRV_VAT_STATUS	CHAR	1	0	Status of Data for VAT Refund
33	VAT_CHANGED_MAN	☐	PTRV_VAT_CHANGED_MAN		CHAR	1	0	VAT Amount Changed Manually

History

Last changed by/on	SAP	20130529
SAP Release Created in