PTRV_SREC - Trip Statistics - Receipts

Trip Statistics - Receipts information is stored in SAP table PTRV_SREC.
It is part of development package PTRA in software component FI-TV-COS. This development package consists of objects that can be grouped under "Travel Expenses Application Dev. (R/3 Enterprise Core)".

Fields for table PTRV_SREC

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		PTP80	0
MANDT	Client	X	MANDT	CLNT	6	*
PERNR	Personnel Number	X	PERNR_D	NUMC	16
REINR	Trip Number	X	REINR	NUMC	20
PERIO	Trip Period Number	X	PTRV_PEROD	NUMC	6
RECEIPTNO	Document Number	X	NRBEL	CHAR	6
SEQNO	Sequential number for receipts	X	PTRV_RECSEQNO	NUMC	4
DED_FLAG	Deduction Indicator		BELAZ	CHAR	2
PAID_COM	Paid by Company		BEZFA	CHAR	2
EXP_TYPE	Travel Expense Type		SPKZL	CHAR	8
REC_AMOUNT	Amount on Individual Receipt		PTRV_REC_AMOUNT	CURR	7
REC_CURR	Currency Key		WAERS	CUKY	10
REC_RATE	Exchange rate		REC_RATE	DEC	5
LOC_AMOUNT	Receipt amount in local currency		PTRV_LOC_AMOUNT	CURR	7
LOC_CURR	Currency Key		WAERS	CUKY	10
TAX_CODE	Tax on sales/purchases code		MWSKZ	CHAR	4
REC_DATE	Receipt Date		BELDT	DATS	16
SHORTTXT	Short Receipt Information		TXBEL	CHAR	20
ABOVE_LIMIT	Customizing Limit for Travel Expense Type Exceeded		PTRV_ABOVE_LIMIT	CHAR	2
.INCLU--AP				PTRV_SREC_ADDON	0
PAPER_RECEIPT	Paper Receipt Exists		PAPER_RECEIPT	CHAR	2
RECEIPT_OK	Expense Receipt Checked		RECEIPT_VALIDATED	CHAR	2
PAYOT	Service Provider		PAYOT	CHAR	4	*
PAPER_MISSING	Required Paper Receipt Is Missing		PAPER_MISSING	CHAR	2
RECEIPT_NO	Invoice Number of Original Receipt		PTRV_RECEIPT_NO	CHAR	32
RECEIPT_ITEM	Number of Invoice Item		PTRV_RECEIPT_ITEM	NUMC	6
REC_FWSTE	Tax Amount in Document Currency (Travel Management Only)		TRV_WMWST	CURR	7
LOC_FWSTE	Tax Amount in Document Currency (Travel Management Only)		TRV_WMWST	CURR	7
VAT_POSTING_TYPE	Reporting and Posting of VAT Amount		PTRV_VAT_POSTING_TYPE	CHAR	2
VAT_SERVICE_CODE	Type of Goods and Services		PTRV_VAT_SERVICE_CODE	CHAR	6	*
VAT_SERVICE_DESC	Description of Goods and Services		PTRV_VAT_SERVICE_DESC	CHAR	200
VAT_STATUS	Status of Data for VAT Refund		PTRV_VAT_STATUS	CHAR	2
VAT_CHANGED_MAN	VAT Amount Changed Manually		PTRV_VAT_CHANGED_MAN	CHAR	2
DIFF_VIOLATION	Maximum Difference Exceeded		DIFF_VIOLATION	CHAR	2