| 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 | T000 | MANDT | Allow NULL? |
| 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | T702N | MOREI | Allow NULL? |
| 3 | SCHEM | Trip schema | nvarchar | 2 | 0 | CHAR | (N' ') | No | | RSCHE | Allow NULL? |
| 4 | INAUS | Domestic/International/No Distinction | char | 1 | 0 | CHAR | (N' ') | No | | INAUS | Allow NULL? |
| 5 | RLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | LNDGR | Allow NULL? |
| 6 | EINME | Multiday Trip | char | 1 | 0 | CHAR | (N' ') | No | | REIME | Allow NULL? |
| 7 | ANKUN | Border Crossing Entry for Trip Out | char | 1 | 0 | CHAR | (N' ') | No | | ANKUN | Allow NULL? |
| 8 | FRUEH | Entry of Breakfast Deduction | char | 1 | 0 | CHAR | (N' ') | No | | FRUEH | Allow NULL? |
| 9 | ESBON | Entry of Meals Coupon | char | 1 | 0 | CHAR | (N' ') | No | | ESBON | Allow NULL? |
| 10 | KFZVE | Miles/Km Distribution for Trip | char | 1 | 0 | CHAR | (N' ') | No | | KFZVE | Allow NULL? |
| 11 | SPLIT | Default value: several destinations | char | 1 | 0 | CHAR | (N' ') | No | | REISP | Allow NULL? |
| 12 | VERPF | Per Diem Settlement for Meals | char | 1 | 0 | CHAR | (N' ') | No | | VERPF_D | Allow NULL? |
| 13 | BEREI | Trip Type: Enterprise-Specific | char | 1 | 0 | CHAR | (N' ') | No | T702X | BEREI | Allow NULL? |
| 14 | NUMRV | Number Assignment for Trip Number (Internal/External) | char | 1 | 0 | CHAR | (N' ') | No | | NUMRV | Allow NULL? |
| 15 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | CHAR | (N' ') | No | T702O | RGION | Allow NULL? |
| 16 | KZREA | Trip Type: Statutory | char | 1 | 0 | CHAR | (N' ') | Yes | T702G | KZREA | Allow NULL? |
| 17 | KZTKT | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | T702R | KZTKT | Allow NULL? |
| 18 | D1300 | Trip Receipts | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1300 | Allow NULL? |
| 19 | D1310 | Additional Receipt Information | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1310 | Allow NULL? |
| 20 | D1400 | Trip Meals Deductions | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1400 | Allow NULL? |
| 21 | D1500 | Trip Advances | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1500 | Allow NULL? |
| 22 | D1600 | Trip Stopovers | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1600 | Allow NULL? |
| 23 | D1700 | Cost Assignment for Entire Trip | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1700 | Allow NULL? |
| 24 | D1701 | Receipt Cost Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1701 | Allow NULL? |
| 25 | D1702 | Stopover Cost Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1702 | Allow NULL? |
| 26 | D1703 | Miles/Kilometers Cost Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1703 | Allow NULL? |
| 27 | D1709 | Cost Assignment Overview | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1709 | Allow NULL? |
| 28 | D1950 | Trip History | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1950 | Allow NULL? |
| 29 | D1960 | Additional Trip Information | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D1960 | Allow NULL? |
| 30 | D9999 | User Data of Trip | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_D9999 | Allow NULL? |
| 31 | MSGID | Application Area | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | T100A | ARBGB | Allow NULL? |
| 32 | MSGNO | System Message Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T100 | MSGNO | Allow NULL? |
| 33 | FLIGHT | Indicator for Entry of Flight Times in Dialog | char | 1 | 0 | CHAR | (N' ') | No | | FLIGHT_TIMES | Allow NULL? |
| 34 | MEREI | More Than One Business Trip Per Day | char | 1 | 0 | CHAR | (N' ') | No | | MEREI | Allow NULL? |
| 35 | D1400_UNTER | Trip Accommodations Deductions | char | 1 | 0 | CHAR | (N' ') | No | | PTRV_D1400_UNTER | Allow NULL? |
| 36 | ADDINFO_KM | Additional Trip Segment Information | char | 1 | 0 | CHAR | (N' ') | No | | ADDINFO_KM | Allow NULL? |
| 37 | D9999_CUST_TEXT | Customizable Function Text for Calling User Screen 9999 | nvarchar | 30 | 0 | CHAR | (N' ') | No | | PTRV_D9999_CUST_TEXT | Allow NULL? |
| 38 | VALID_TO | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 39 | UEPKZ | Per Diem Settlement of Accommodations | char | 1 | 0 | CHAR | (N' ') | No | | UEPKZ_D | Allow NULL? |
| 40 | OTH_EXP | Indicator for Receipt Settlement Without Trip | char | 1 | 0 | CHAR | (N' ') | No | | PTRV_OTHER_EXPENSES | Allow NULL? |
| 41 | ADDR_DEST | Enter Addresses for Trip Destinations | char | 1 | 0 | CHAR | (N' ') | No | | ADDR_DEST | Allow NULL? |
| 42 | ADDR_MILEAGE | Enter Addresses for Legs of Trips | char | 1 | 0 | CHAR | (N' ') | No | | ADDR_MILEAGE | Allow NULL? |
| 43 | COMPUTE_DIST | Calculate Distance | char | 1 | 0 | CHAR | (N' ') | No | | COMPUTE_DIST | Allow NULL? |
| 44 | SCHEM_PS_RE | Trip schema | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RSCHE | Allow NULL? |
| 45 | SCHEM_PS_AN | Trip schema | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RSCHE | Allow NULL? |
| 46 | SCHEM_PS_VERW | Use of Schema in Public Sector | char | 1 | 0 | CHAR | (N' ') | Yes | | SCHEM_PS_VERW | Allow NULL? |
| 47 | NO_TAX_CHAIN | Automatic Taxation of Trip Chains | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_NO_TAX_CHAIN | Allow NULL? |
| 48 | REQUEST_SERVICES | Travel Services Entered in Travel Request (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | REQ_SERVICES | Allow NULL? |
| 49 | TRIP_BREAK | Trip Break | char | 1 | 0 | CHAR | (N' ') | Yes | | TRIP_BREAK | Allow NULL? |
| 50 | D2100 | Transport | char | 1 | 0 | CHAR | (N' ') | Yes | | GLO_PTRV_D2100 | Allow NULL? |
| 51 | EXCHANGE_DATE | Default Value for Reference Date | char | 1 | 0 | CHAR | (N' ') | Yes | | GLO_PTRV_REF_DATE_DEFAULT | Allow NULL? |
| 52 | TRIP_BREAK_CNTRY | Entry of Country for Trip Break | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TRIP_BREAK_COUNTRY_ENABLE | Allow NULL? |
