PTRV_A_SREC - Trip Statistics - Receipts
Trip Statistics - Receipts information is stored in SAP table PTRV_A_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)".
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_A_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_A_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 |