| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | FITV_MEAL_ACCOM | Additional Amounts for Meals in Accommodations Receipts | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 2 | FITV_NOT_CH_TR | Key Fields of Temp. Non-Changeable Trips/Duty Allocation | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 3 | PTRV_DELETE_LOG | Log Table for Deleted Trips | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 4 | ZCATSDB | Records changed with processing status '10' | 34 | REINR | | nvarchar | 10 | 0 | | |
| 5 | ZCATSDB2 | Records changed with processing status '10' | 35 | REINR | | nvarchar | 10 | 0 | | |
| TOPAttendancesAbsences |
| 6 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 42 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPESS Based on WD ABAP |
| 7 | HRESS_D_CATS_FAV | CATS Favorites: database table | 41 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPLocalization |
| 8 | GLO_PTRV_TRANSP | Reimbursement Amounts for Transport | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPRussia |
| 9 | PA0298 | HR Master Record: Infotype 0298 | 37 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPTime Sheet |
| 10 | CATSDB | CATS: Database Table for Time Sheet | 34 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 11 | CATS_TEMP | CATS: Database Table for Templates | 36 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPTravel Expenses |
| 12 | FITV_HINZ_WERB_B | Additional Amounts and Income-Related Expenses for Receipts | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 13 | FITV_HINZ_WERB_S | Additional Amounts and Income-Related Expenses | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 14 | FTPT_REQ_CAT | Type of Transport/Accomm. and Est.Cost of Travel Request | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 15 | PTRV_ARCHIVE | Administrative Table for Archived Trip Data | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 16 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 17 | PTRV_ARCH_PERIO | Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary) | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 18 | PTRV_BEIHILFE | Subsidies for Trips Home for Entire Separation Allowance | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 19 | PTRV_BEIH_BEL | Assignment of Receipts to a Subsidy for Trips Home | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 20 | PTRV_BEIH_TAG | Assignment of Days to a Subsidy for Trips Home | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 21 | PTRV_BEIH_WEG | Assignment of Trip Segments to a Subsidy for Trips Home | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 22 | PTRV_CHANGE | Change to Trip | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 23 | PTRV_COMM_AMT | Detail Data: Transfer to FM When Trip Saved | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 24 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 25 | PTRV_COMP | Comparison Calculation Results PS | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 26 | PTRV_HEAD | General Trip Data | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 27 | PTRV_NOT_CH_TR | Storage of New Data from Temporarily Unchangable Trips | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 28 | PTRV_PERIO | Period Data of a Trip | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 29 | PTRV_REASGN_FM | Conversion of FM Data in Trip (e.g. Fiscal Year Change) | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 30 | PTRV_RECDETAIL | Participant(s) in Entertainment Receipts | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 31 | PTRV_ROT_AWKEY | Assignment of Trip Results to Posting Doc. Number and Line | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 32 | PTRV_SADD | Trip Statistics - Add. Receipt Data | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 33 | PTRV_SBACKLOG | Trip Statistics - Batch/Backlog Processing | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 34 | PTRV_SCOM | Travel Statistic - Request/Plan/Settlement Cost Comparison | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 35 | PTRV_SCOS | Trip Statistics - Cost Assignment | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 36 | PTRV_SHDR | Trip Statistics - Trip Amounts | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 37 | PTRV_SREC | Trip Statistics - Receipts | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 38 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 39 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 40 | PTRV_TRIP_DELETE | Trips Deleted in SAP System for Offline Travel Manager | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 41 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 42 | PTRV_VERSION | History Table | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 43 | PTRV_WAF_CONFLCT | Offline Travel Management: Conflict Processing | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 44 | PTRV_WAF_RESTART | Restart File for Mobile Solution with Overlapping Trips | 4 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPTravel Management |
| 45 | FITV_REJECT | Rejected Trips | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 46 | PTRV_SYNC_OUT | Synchronization Table for Trips in Microsoft Outlook | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| TOPTravel Planning |
| 47 | FTPT_CAR | Travel Request Item - Car Rental Service | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 48 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 49 | FTPT_FARE_COMP | Rate components | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 50 | FTPT_FARE_NOTE | Rate Rules | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 51 | FTPT_FLIGHT | Travel Request Item - Flight Service | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 52 | FTPT_FLIGHT_FARE | Assignment table: flights <-> rate components | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 53 | FTPT_FLIGHT_FCMP | Assignment table: flights <-> rate components | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 54 | FTPT_FLIGHT_LEG | Leg of flight | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 55 | FTPT_FLIGHT_PREF | Flight service preferences of a travel plan | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 56 | FTPT_FLIGHT_TST | Ticket information | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 57 | FTPT_FLIGHT_TSTK | Ticket Information | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 58 | FTPT_HOTEL | Travel Request Item - Hotel Service | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 59 | FTPT_HOTEL_PREF | Hotel service preferences of a travel plan | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 60 | FTPT_ITEM | Travel Service Request Item | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 61 | FTPT_OTHER | Travel Reservation Request Item - Other Service | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 62 | FTPT_PLAN | General Plan Data | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 63 | FTPT_PLANHISTORY | General Plan Data | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 64 | FTPT_PNR | Elements of passenger name records of travel plan variant | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 65 | FTPT_PNR_ADDRESS | PNR delivery / billing addresses | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 66 | FTPT_PNR_NAME | Name element of PNR | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 67 | FTPT_PNR_OSI | Other PNR service information | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 68 | FTPT_PNR_PHONE | PNR telephone references | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 69 | FTPT_PNR_REMARKS | PNR remarks | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 70 | FTPT_PNR_SSR | Special PNR service requests | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 71 | FTPT_REQUEST | Travel Plan Requests | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 72 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 73 | FTPT_REQ_ADVANCE | Travel Request Advance | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 74 | FTPT_REQ_HEAD | Framework Data of Travel Request | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 75 | FTPT_REQ_REASON | Reason for Travel Request | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 76 | FTPT_SERVICE | General Services | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 77 | FTPT_SYNC_DATA | Data Synchronization: SAP - External System | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 78 | FTPT_TM_MEMO | Memo table for Travel Management | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 79 | FTPT_TRAIN | Travel Request Item - Train Service | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 80 | FTPT_TRAIN_PREF | Train service preferences of a travel plan | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 81 | FTPT_VARIANT | Table of Travel Plan Variants | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
| 82 | FTPT_VAR_INFO | Info texts for travel plan variants | 3 | REINR | Trip Number | nvarchar | 10 | 0 | | |
