| 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 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_PDVRS | Allow NULL? |
| 6 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PTRV_HDVRS | Allow NULL? |
| 7 | PDATV | Beginning Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REBED | Allow NULL? |
| 8 | PUHRV | Beginning Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REBEU | Allow NULL? |
| 9 | PDATB | End Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REEND | Allow NULL? |
| 10 | PUHRB | End Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REENU | Allow NULL? |
| 11 | DRUCK | Trip Print Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P_PRINT | Allow NULL? |
| 12 | ANTRG | Travel Request or Trip Approved (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ANTRG | Allow NULL? |
| 13 | ABREC | Open / To be Settled / Settled (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ABREC | Allow NULL? |
| 14 | UEBLG | HR Payroll Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBLG | Allow NULL? |
| 15 | UEBRF | FI Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBRF | Allow NULL? |
| 16 | UEBDT | Data Medium Exchange Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBDT | Allow NULL? |
| 17 | TLOCK | Indicator: Trip locked | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TLOCK | Allow NULL? |
| 18 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 19 | ABRJ1 | Payroll Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PABRJ | Allow NULL? |
| 20 | ABRP1 | Payroll Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PABRP | Allow NULL? |
| 21 | PERM1 | Period modifier | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | IPERM | Allow NULL? |
| 22 | ABKR1 | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 23 | BEGP1 | Start of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_BEGP1 | Allow NULL? |
| 24 | ENDP1 | End of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_ENDP1 | Allow NULL? |
| 25 | ABRJ2 | Payroll Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PABRJ | Allow NULL? |
| 26 | ABRP2 | Payroll Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PABRP | Allow NULL? |
| 27 | PERM2 | Period modifier | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | IPERM | Allow NULL? |
| 28 | ABKR2 | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 29 | BEGP2 | Start of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_BEGP2 | Allow NULL? |
| 30 | ENDP2 | End of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_ENDP2 | Allow NULL? |
| 31 | ACCDT | Trip Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_ACCDT | Allow NULL? |
| 32 | ACCTM | Trip Settlement Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_ACCTM | Allow NULL? |
| 33 | RUNID | Sequential number of posting run | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | TR_EVNUM | Allow NULL? |
| 34 | VERPA | Per-Diem Accounting for Meals | char | 1 | 0 | CHAR | (N' ') | Yes | | VERPA | Allow NULL? |
| 35 | UEBKZ | Per-Diem Accounting for Accommodations | char | 1 | 0 | CHAR | (N' ') | Yes | | UEPKZ | Allow NULL? |
| 36 | ANUEP | Number of Overnight Stays for Per-Diem Settlement | decimal | 2 | 0 | DEC | ((0)) | Yes | | ANUEP | |
| 37 | NO_MILES | Indicator: No repeat of travel costs accounting | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_NO_MILES_ACCOUNTING | Allow NULL? |
| 38 | LSTAY | Meals per diem reduct. for longer stay at same place of work | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_LSTAY | Allow NULL? |
| 39 | TR_DOPP_ANZAHL | Daily Return: No. of Days with Outb. and Return Trip | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_TR_DOPP_ANZAHL | Allow NULL? |
| 40 | TR_EINF_ANZAHL | Daily Return: No. of Days only with Outb./ or Return Trip | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_TR_EINF_ANZAHL | Allow NULL? |
| 41 | TR_ENTFERNUNG | Daily Return: Distance fr. Residence to New Place of Work | decimal | 5 | 0 | DEC | ((0)) | Yes | | PTRVPS_TR_ENTFERNUNG | |
| 42 | VU_EA_DOPP_ANZ | Own Contribution: No. of Days with Outb./Return Trip b. Move | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_VU_EA_DOPP_ANZAHL | Allow NULL? |
| 43 | VU_EA_EINF_ANZ | Own Contribution: No. of Days wth Outb./Return Trip b. Move | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_VU_EA_EINF_ANZAHL | Allow NULL? |
| 44 | VU_EA_ENTFERN | Own Contribution: Distance to Place of Work before Move | decimal | 5 | 0 | DEC | ((0)) | Yes | | PTRVPS_VU_EA_ENTFERNUNG | |
| 45 | VU_EA_KM_SATZ | Own Contribution: KM Rate to Place of Work Before Move | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRVPS_VU_EA_KM_SATZ | |
| 46 | NU_EA_DOPP_ANZ | Own Contrib.: No. of Days wth Outb. and Ret. Trip after Move | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_NU_EA_DOPP_ANZAHL | Allow NULL? |
| 47 | NU_EA_EINF_ANZ | Own Contrib.: No. of Days with Outb. or Ret. Trip after Move | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_NU_EA_EINF_ANZAHL | Allow NULL? |
| 48 | NU_EA_ENTFERN | Own Contribution: Distance to Place of Work after Move | decimal | 5 | 0 | DEC | ((0)) | Yes | | PTRVPS_NU_EA_ENTFERNUNG | |
| 49 | NU_EA_KM_SATZ | Own Contribution: KM Rate to Place of Work after Move | decimal | 10 | 2 | CURR | ((0)) | Yes | | PTRVPS_NU_EA_KM_SATZ | |
| 50 | V_UNENTGELTLICH | Gratuitous Meals for the Entire Month | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_V_UNENTGELTLICH | Allow NULL? |
| 51 | U_UNENTGELTLICH | Gratuitous Accommodations for the Entire Month | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_U_UNENTGELTLICH | Allow NULL? |
| 52 | REDUC_ERGRU | New Reimbursement Group for Reduction in Meals per Diem | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PTRV_REDUC_ERGRU | Allow NULL? |
| 53 | NOT_PAID | No Reimbursement of Trip | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_NOT_PAID | Allow NULL? |
| 54 | WEG_ERH_MAX | Increased Maximum Trip Segment Reimbursement | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_WEG_ERH_MAX | Allow NULL? |
| 55 | ERH_DIENST_INT | Significant Official Interest | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ERH_DIENST_INT | Allow NULL? |
| 56 | ENTF_WO_DO | Short Distance to Residence/Workplace | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ENTF_WO_DO | Allow NULL? |
| 57 | DRITTMITTEL | Payments and Contributions from Third Parties | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_DRITTMITTEL | Allow NULL? |
| 58 | ANTRAG_GWE | Request for Full Trip Segment Reimbursement | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ANTRAG_GWE | Allow NULL? |
| 59 | POLICY_VIOLATION | Violation of Travel Policy | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_POLICY_VIOLATION | Allow NULL? |
| 60 | EXCEPTION_FLAG | Exception Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_EXCEPTION | Allow NULL? |
| 61 | NR_RECEIPTS | Number of Receipts | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRV_NR_RECEIPTS | Allow NULL? |
| 62 | PERM_TRIP_APPR | Standing Approval of Business Trips | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_PERM_TRIP_APPROVAL | Allow NULL? |
| 63 | TR_NR_FROM_HOME | Number of Days with Round Trip from Home | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRVPS_NR_COMMUTES_FROM_HOME | Allow NULL? |
| 64 | VAT_STATUS | Status of Data for VAT Refund | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_VAT_STATUS | Allow NULL? |
| 65 | EST_COST_PLAN | Estimated Costs from Plan | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_EST_COST_PLAN | |
| 66 | EST_COST_REQ | Estimated Costs from Request | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_EST_COST_REQ | |
| 67 | REASON | Reason for Difference | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | PTRV_REASON | Allow NULL? |
| 68 | TAX_TRIP | Taxation of Whole Trip | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRVPS_TAX_TRIP | Allow NULL? |
