SAP Table PTRV_RECEIPTS
Travel Expenses Receipt (INPUT) incl. Tax Jurisdiction Code
PTRV_RECEIPTS (Travel Expenses Receipt (INPUT) incl. Tax Jurisdiction Code) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PTRV_RECEIPTS to other SAP tables.
PTRV_RECEIPTS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RECEIPTNO | Document Number | NRBEL | CHAR | 3 | 0 | |||||||||
| EXP_TYPE | Travel Expense Type | SPKZL | T706B1 | CHAR | 4 | 0 | ||||||||
| REC_AMOUNT | Receipt amount | REC_AMOUNT | DEC | 23 | 4 | |||||||||
| REC_CURR | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||
| REC_RATE | Direct Quoted Exchange Rate | UKURSP | DEC | 9 | 5 | |||||||||
| TAX_CODE | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 | 0 | ||||||||
| REC_DATE | Receipt Date | BELDT | DATS | 8 | 0 | |||||||||
| SHORTTXT | Short Receipt Information | TXBEL | CHAR | 10 | 0 | |||||||||
| KEY_STOP | Destination Assignment | KEYZI | CHAR | 2 | 0 | |||||||||
| SHARE_PERC | Amount or Percent | BETPR | CHAR | 1 | 0 | |||||||||
| REC_RATE_CM | Indirect Quoted Exchange Rate | UKURSM | DEC | 9 | 5 | |||||||||
| PAPER_RECEIPT | Paper Receipt Exists | PAPER_RECEIPT_CORE | CHAR | 1 | 0 |
Possible values
|
||||||||
| REC_PAYCURR | Accounting Currency of Expense Receipt or Advance | PTRV_PAYCURR | CUKY | 5 | 0 | |||||||||
| REC_REFNR | Reference Document Number | REC_NOBEL | CHAR | 3 | 0 | |||||||||
| RECEIPT_OK | Expense Receipt Checked | RECEIPT_VALIDATED_CORE | CHAR | 1 | 0 |
Possible values
|
||||||||
| TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||||||||
| PROTECT | Protection Indicator of Entry | PROTECT | CHAR | 1 | 0 |
Possible values
|
||||||||
PTRV_RECEIPTS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PTRV_RECEIPTS | EXP_TYPE | SYST | MANDT | T706B1 | Travel Expense Types | MANDT |
| PTRV_RECEIPTS | EXP_TYPE | * | T706B1 | Travel Expense Types | MOREI | |
| PTRV_RECEIPTS | EXP_TYPE | PTRV_RECEIPTS | EXP_TYPE | T706B1 | Travel Expense Types | SPKZL |
| PTRV_RECEIPTS | EXP_TYPE | * | T706B1 | Travel Expense Types | ENDDA | |
| PTRV_RECEIPTS | REC_CURR | PTRV_RECEIPTS | REC_CURR | TCURC | Currency Codes | WAERS |
| PTRV_RECEIPTS | REC_CURR | SYST | MANDT | TCURC | Currency Codes | MANDT |
| PTRV_RECEIPTS | TAX_CODE | PTRV_RECEIPTS | TAX_CODE | T007A | Tax Keys | MWSKZ |
| PTRV_RECEIPTS | TAX_CODE | SYST | MANDT | T007A | Tax Keys | MANDT |
| PTRV_RECEIPTS | TAX_CODE | * | T007A | Tax Keys | KALSM | |
