| 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 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_HDVRS | Allow NULL? |
| 5 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T500L | MOLGA | Allow NULL? |
| 6 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T702N | MOREI | Allow NULL? |
| 7 | SCHEM | Trip schema | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T706S | RSCHE | Allow NULL? |
| 8 | KZREA | Trip Type: Statutory | char | 1 | 0 | CHAR | (N' ') | Yes | T702G | KZREA | Allow NULL? |
| 9 | BEREI | Trip Type: Enterprise-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | T702X | BEREI | Allow NULL? |
| 10 | KZTKT | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | T702R | KZTKT | Allow NULL? |
| 11 | ZORT1 | Location | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | RZIELORT | Allow NULL? |
| 12 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T702O | LNDGR | Allow NULL? |
| 13 | HRGIO | Region of Main Destination | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T702O | HRGIO | Allow NULL? |
| 14 | NDNST | Name of new administrative office (P.S.) | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PTRV_NDNST | Allow NULL? |
| 15 | KUNDE | Reason for Trip (for example, customer/requisitioner) | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | RKUNDE | Allow NULL? |
| 16 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REBED | Allow NULL? |
| 17 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REBEU | Allow NULL? |
| 18 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REEND | Allow NULL? |
| 19 | UHRB1 | End Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REENU | Allow NULL? |
| 20 | DATH1 | Border Crossing (Trip Out): Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATGH | Allow NULL? |
| 21 | UHRH1 | Time: Border crossing(trip out) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UHRGH | Allow NULL? |
| 22 | DATR1 | Border Crossing (Return Trip): Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATGZ | Allow NULL? |
| 23 | UHRR1 | Time: Border crossing(return trip) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UHRGZ | Allow NULL? |
| 24 | AGRZ1 | Trip Country / Trip Country Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T702O | LNDGR | Allow NULL? |
| 25 | GRGIO | Region of Border Crossing: Return Trip | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T702O | GRGIO | Allow NULL? |
| 26 | GRBER | Border crossing: Trip type enterprise-specific | char | 1 | 0 | CHAR | (N' ') | Yes | T702X | PTRV_GRBER | Allow NULL? |
| 27 | UZKVG | Confirmation of Moving Costs Refund | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_UZKVG | Allow NULL? |
| 28 | ZUSAG | Admin. Office That Confirmed Moving Costs Compensation (PS) | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PTRV_ZUSAG | Allow NULL? |
| 29 | ENDRG | Different End of Travel Allowance (in Separation Allowance) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_ENDRG | Allow NULL? |
| 30 | DEPAR | Departure from Residence or Place of Work | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_DEPAR | Allow NULL? |
| 31 | ARRVL | Return Trip: Arrival at Place of Residence or Work | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ARRVL | Allow NULL? |
| 32 | RETRN | Arrival at Accommodations or New Workplace | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_RETRN | Allow NULL? |
| 33 | DATES | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 34 | TIMES | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEUHR | Allow NULL? |
| 35 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 36 | REPID | Change Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AEREP | Allow NULL? |
| 37 | DANTN | Trip Number of Corresponding Trip to Start Work | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_DANTN | Allow NULL? |
| 38 | FINTN | Trip Number of Associated Business Trip Return | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_FINTN | Allow NULL? |
| 39 | REQUEST | Indicator for objects request, plan and expense report | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_OBJEKT | Allow NULL? |
| 40 | TRAVEL_PLAN | Indicator for objects request, plan and expense report | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_OBJEKT | Allow NULL? |
| 41 | EXPENSES | Indicator for objects request, plan and expense report | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_OBJEKT | Allow NULL? |
| 42 | ST_TRGTG | Start of Taxation for Per Diem Separation Allowance | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_ST_TRGTG | Allow NULL? |
| 43 | ST_TRGALL | Start of Taxation for Complete Separation Allowance | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_ST_TRGALL | Allow NULL? |
| 44 | PERIODENART | Associated Trip Period Types | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_PS_PERIODENART | Allow NULL? |
| 45 | DAT_REDUC1 | Reduction of Entire Separation or Travel Allowance Level 1 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_DAT_REDUC1 | Allow NULL? |
| 46 | DAT_REDUC2 | Reduction of Separation or Travel Allowance Level 2 | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_DAT_REDUC2 | Allow NULL? |
| 47 | DATV1_DIENST | Date of Commencement of Work | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_DATV1_DIENST | Allow NULL? |
| 48 | UHRV1_DIENST | Time at Which Work Commences | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_PS_UHRV1_DIENST | Allow NULL? |
| 49 | DATB1_DIENST | Date on Which Work Ends | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_DATB1_DIENST | Allow NULL? |
| 50 | UHRB1_DIENST | Time at Which Work Ends | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_PS_UHRB1_DIENST | Allow NULL? |
| 51 | ABORDNUNG | Associated Superior Separation Allowance | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | PTRV_PS_ABORD | Allow NULL? |
| 52 | ST_TRG_TYP | Temporary Assignment (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_PS_ST_TYP | Allow NULL? |
| 53 | ST_WOHN_TYP | Home for Separation Allowance Taxation | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ST_WOHN_TYP | Allow NULL? |
| 54 | KEIN_REISEGELD | No Separation Allowance for Travel Is Paid (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_KEIN_REISEGELD | Allow NULL? |
| 55 | TAX_PER_DIEM | Automatic Taxation of Meals and Accommodations Per Diems | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TAX_PER_DIEM | Allow NULL? |
| 56 | TAX_PD_MAN | Manually Triggered Taxation of Meals Per Diems | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TAX_PD_MAN | Allow NULL? |
| 57 | TAX_OV_MAN | Manually Triggered Taxation of Accommodations Per Diems | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TAX_OV_MAN | Allow NULL? |
| 58 | EXCHANGE_DATE | Reference Date of Trip | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_DATTN | Allow NULL? |
| 59 | ROUNDING | Travel Amounts Are Rounded (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ROUNDING | Allow NULL? |
| 60 | DZ_LIMIT_180 | Limitation of DA Fee to 180 Days | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_PS_DZ_LIMIT_180 | Allow NULL? |
