| 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 | PERIO | Trip Period Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PTRV_PEROD | Allow NULL? |
| 6 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_PDVRS | Allow NULL? |
| 7 | RULE_TAG | Rule Used To Change The Accounting and Taxation Method | char | 1 | 0 | CHAR | (N' ') | No | | PTRV_RULE_TAG_46C | Allow NULL? |
| 8 | ZIKEY | Destination Assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | KEYZI | Allow NULL? |
| 9 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MOREI | Allow NULL? |
| 10 | KZREA | Trip Type: Statutory | char | 1 | 0 | CHAR | (N' ') | Yes | * | KZREA | Allow NULL? |
| 11 | BEREI | Trip Type: Enterprise-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | * | BEREI | Allow NULL? |
| 12 | KZTKT | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | * | KZTKT | Allow NULL? |
| 13 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LNDGR | Allow NULL? |
| 14 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | RGION | Allow NULL? |
| 15 | PSTLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ | Allow NULL? |
| 16 | ORT01 | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_ORT01 | Allow NULL? |
| 17 | STRAS | Street and House Number | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | PAD_STRAS | Allow NULL? |
| 18 | STATE | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 19 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AD_ADDRNUM | Allow NULL? |
| 20 | DEST_IDENTIFIER | Unique Identification for Destination Per Personnel Number | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | PTRV_DEST_IDENTIFICATION_46C | Allow NULL? |
| 21 | KUNDE | Reason for Trip (for example, customer/requisitioner) | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | RKUNDE | Allow NULL? |
| 22 | DATV1 | Beginning Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REBED | Allow NULL? |
| 23 | UHRV1 | Beginning Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REBEU | Allow NULL? |
| 24 | DATB1 | End Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REEND | Allow NULL? |
| 25 | UHRB1 | End Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REENU | Allow NULL? |
| 26 | ACTION_DATE_REQ | Date, From Which The Settlement Method Should Be Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_ACTION_DATE_REQUIRED_46C | Allow NULL? |
| 27 | ACTION_DATE_ACT | Date, From Which the Settlement Method Was Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_ACTION_DATE_ACTUAL_46C | Allow NULL? |
| 28 | HOUSE_NUM | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 29 | ORT02 | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_ORT02 | Allow NULL? |
| 30 | CITY_CODE | Code Number for Location (e.g. Community Code Number) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PTRV_CITY_CODE_46C | Allow NULL? |
| 31 | START_ENTRY | Fictitious Time Period Before Activation of Trip Chains | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_START_TRIP_CHAIN_46C | Allow NULL? |
| 32 | TAX_DATE_PD_REQ | Date the Taxation of Meals Per Diems Should Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_TAX_DATE_PD_REQ_46C | Allow NULL? |
| 33 | TAX_TIME_PD_REQ | Time the Meals Per Diem Taxation Should Start At | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_TAX_TIME_PD_REQ_46C | Allow NULL? |
| 34 | TAX_DATE_PD_ACT | Date the Taxation of Meals Per Diems Started On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_TAX_DATE_PD_ACT_46C | Allow NULL? |
| 35 | TAX_TIME_PD_ACT | Time the Meals Per Diem Taxation Started At | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_TAX_TIME_PD_ACT_46C | Allow NULL? |
| 36 | TAX_DATE_OV_REQ | Date the Taxation of Accommodations Per Diem Should Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_TAX_DATE_OV_REQ_46C | Allow NULL? |
| 37 | TAX_TIME_OV_REQ | Time the Accommodations Per Diem Taxation Should Start At | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_TAX_TIME_OV_REQ_46C | Allow NULL? |
| 38 | TAX_DATE_OV_ACT | Date the Taxation of Accommodations Per Diem Started On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_TAX_DATE_OV_ACT_46C | Allow NULL? |
| 39 | TAX_TIME_OV_ACT | Time the Accommodations Per Diem Taxation Started At | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_TAX_TIME_OV_ACT_46C | Allow NULL? |
| 40 | NR_PER_DIEM | Number of Meals Per Diems for Trip Chains | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRV_NR_PER_DIEM_46C | Allow NULL? |
| 41 | NR_OVERN | Number of Accommodations Per Diems for Trip Chains | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PTRV_NR_OVERN_46C | Allow NULL? |
