SAP Table PTRV_SHDR
Trip Statistics - Trip Amounts
PTRV_SHDR (Trip Statistics - Trip Amounts) 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_SHDR to other SAP tables.
PTRV_SHDR table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | CLNT | 3 | 0 | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||
REINR | Trip Number | REINR | NUMC | 10 | 0 | |||
PERIO | Trip Period Number | PTRV_PEROD | NUMC | 3 | 0 | |||
SEQNO | Sequential number for trip totals | PTRV_SHDRSEQNO | NUMC | 2 | 0 | |||
ADDIT_AMNT | Additional Amount of a Trip (Taxable for Employee) | PTRV_ADDIT_AMNT | CURR | 13 | 2 | |||
SUM_REIMBU | Reimbursement amount for a trip | PTRV_SUM_REIMBU | CURR | 13 | 2 | |||
SUM_ADVANC | Total Advances for a Trip | PTRV_SUM_ADVANC | CURR | 13 | 2 | |||
SUM_PAYOUT | Payment Amount | PTRV_SUM_PAYOUT | CURR | 13 | 2 | |||
SUM_PAIDCO | Travel Expenses Paid by Company | PTRV_SUM_PAIDCO | CURR | 13 | 2 | |||
TRIP_TOTAL | Total Cost of Trip | PTRV_TRIP_TOTAL | CURR | 13 | 2 | |||
PD_FOOD | Reimbursement Amount (Total) for Meals per Diems | PTRV_PD_FOOD | CURR | 13 | 2 | |||
PD_HOUSING | Reimbursement Amount (Total) for Accommodations per Diems | PTRV_PD_HOUSING | CURR | 13 | 2 | |||
PD_MILEAGE | Reimbursement Amount (Total) for Travel Flat Rates | PTRV_PD_MILEAGE | CURR | 13 | 2 | |||
CURRENCY | Currency Key | TRVWAERS | CUKY | 5 | 0 | |||
M_TOTAL | Total Miles/Kilometers | KMGES | DEC | 5 | 0 | |||
TRIPDUR | Trip Duration in Days | PTRV_TRIPDUR | DEC | 4 | 0 | |||
CHNGDATE | Changed On | AEDAT | DATS | 8 | 0 | |||
CHNGTIME | Time of Last Change | AEUHR | TIMS | 6 | 0 | |||
TXF_FOOD | Total of Tax-Exempt Paid Meals per Diems | PTRV_TXF_FOOD | CURR | 13 | 2 | |||
PD_POCKET_MON | Total Reimbursement Amount for Pocket Money | GLO_PTRV_PD_POCKET_MONEY | CURR | 13 | 2 | |||
PD_PUB_TRANS | Total Reimbursement Amount for Public Transport | GLO_PTRV_PD_PUBLIC_TRANS | CURR | 13 | 2 | |||
PD_LOC_TRANS | Total Reimbursement Amount for Local Transport | GLO_PTRV_PD_LOCAL_TRANS | CURR | 13 | 2 |