| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | HDVRS | Sequential Number of Travel Expenses Table THEADER | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | PERIO | Trip Period Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | RULE_TAG | Rule Used To Change The Accounting and Taxation Method | char | 1 | 0 | | | | Allow NULL? |
| 8 | OLD_ZIKEY | Destination Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | NEW_ZIKEY | Destination Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | NEW_DESTINATION | Insertion of Specified Destination | char | 1 | 0 | | | | Allow NULL? |
| 11 | DEL_DESTINATION | Deletion of Specified Destination | char | 1 | 0 | | | | Allow NULL? |
| 12 | HEAD_BEREI | Trip Type: Enterprise-Specific | char | 1 | 0 | | | | Allow NULL? |
| 13 | ZIKEY | Destination Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | KZREA | Trip Type: Statutory | char | 1 | 0 | | | | Allow NULL? |
| 15 | KZTKT | Trip Activity Type | char | 1 | 0 | | | | Allow NULL? |
| 16 | ZLAND | Trip Country / Trip Country Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | BEREI | Trip Type: Enterprise-Specific | char | 1 | 0 | | | | Allow NULL? |
| 18 | ZORT1 | Location | nvarchar | 17 | 0 | | | | Allow NULL? |
| 19 | KUNDE | Reason for trip (e.g. customer/requisitioner) | nvarchar | 17 | 0 | | | | Allow NULL? |
| 20 | RVDAT | Beginning Date of Trip Segment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | RVUHR | Beginning Time of Trip Segment | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | RBDAT | End Date of Trip Segment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | RBUHR | End Time of Trip Segment | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | RADAT | Trip Segment: Arrival Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | RAUHR | Part of trip: Arrival time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | UEBPA | Number of Overnight Stays for Per-Diem Settlement | decimal | 2 | 0 | | | | |
| 27 | KZPRI | Private Stopover | char | 1 | 0 | | | | Allow NULL? |
| 28 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | PROTECT | Protection Indicator of Entry | char | 1 | 0 | | | | Allow NULL? |
| 30 | ABWH_ART | Absence type | char | 1 | 0 | | | | Allow NULL? |
| 31 | ZUSCH_ART | Allowance Type | char | 1 | 0 | | | | Allow NULL? |
| 32 | TRG_PARTNER | Separation Allowance Action of Spouse at Same Location | char | 1 | 0 | | | | Allow NULL? |
| 33 | ENTGELT_UNTERK | Chargeable Accommodations Retained During Absence | char | 1 | 0 | | | | Allow NULL? |
| 34 | TAX_PER_DIEM | Automatic Taxation of Meals and Accommodations Per Diems | char | 1 | 0 | | | | Allow NULL? |
| 35 | TAX_PD_MAN | Manually Triggered Taxation of Meals Per Diems | char | 1 | 0 | | | | Allow NULL? |
| 36 | TAX_OV_MAN | Manually Triggered Taxation of Accommodations Per Diems | char | 1 | 0 | | | | Allow NULL? |
| 37 | SLEEP_AT_HOME | Overnight Stay at Home | char | 1 | 0 | | | | Allow NULL? |
| 38 | MPD_EXCL | Exclude Meals Per Diem From Calculation | char | 1 | 0 | | | | Allow NULL? |
