| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REINR | Allow NULL? |
| 4 | PERIO | Trip Period Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PTRV_PEROD | Allow NULL? |
| 5 | TRIP_COMPONENT | Plan/Request/Expense Report (Indicator) | char | 1 | 0 | CHAR | (N' ') | No | | PTRV_TRIP_COMPONENT | Allow NULL? |
| 6 | VERSION_NUMBER | Sequential Version Number of Table PTRV_VERSION | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | PTRV_VERSION_NUMBER | Allow NULL? |
| 7 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PTRV_PDVRS | Allow NULL? |
| 8 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PTRV_HDVRS | Allow NULL? |
| 9 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | REQUEST_VERSION | Allow NULL? |
| 10 | DATUM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 11 | UZEIT | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEUHR | Allow NULL? |
| 12 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 13 | REPID | Change Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AEREP | Allow NULL? |
| 14 | DRUCK | Trip Print Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P_PRINT | Allow NULL? |
| 15 | ANTRG | Travel Request or Trip Approved (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ANTRG | Allow NULL? |
| 16 | ABREC | Open / To be Settled / Settled (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ABREC | Allow NULL? |
| 17 | UEBLG | HR Payroll Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBLG | Allow NULL? |
| 18 | UEBRF | FI Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBRF | Allow NULL? |
| 19 | UEBDT | Data Medium Exchange Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBDT | Allow NULL? |
| 20 | RUNID | Sequential number of posting run | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | TR_EVNUM | Allow NULL? |
| 21 | STATU | Status of Travel Expense Posting Runs | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TR_EVSTS | Allow NULL? |
| 22 | REQ_STATUS | Travel Plan Status | char | 1 | 0 | CHAR | (N' ') | Yes | | PLAN_STATUS | Allow NULL? |
| 23 | SUM_REIMBU | Reimbursement amount for a trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_SUM_REIMBU | |
| 24 | SUM_ADVANC | Total Advances for a Trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_SUM_ADVANC | |
| 25 | TRIP_TOTAL | Total Cost of Trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_TRIP_TOTAL | |
| 26 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TRVWAERS | Allow NULL? |
| 27 | ESTIMATED_COST | Estimated Total Cost of Trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_ESTIMATED_COST | |
| 28 | EST_COST_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 29 | NR_RECEIPTS | Number of Receipts | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRV_NR_RECEIPTS | Allow NULL? |
| 30 | ARCHIVE_EXIST | Status of Document Archiving | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ARCHIVE_EXIST | Allow NULL? |
