| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTTM/BL_T_ARU | Automation and Assignment | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
2 | /OTTM/BL_T_DMC | Customizing table for default mappings of e-receipt types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
3 | /OTTM/BL_T_EDC | Customizing table for mapping of expense and doc types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
4 | /OTTM/BL_T_ENC | Customizing table for e-mail notification content | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
5 | /OTTM/BL_T_ENIC | Customizing table for email notification input channels | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
6 | /OTTM/BL_T_MAC | Mapping of Classification to Expense Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
7 | /OTTM/BL_T_PRE | Customizing table for e-receipt preview | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
8 | /OTTM/OCR_T_OCIC | Input Channels for OCR | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
9 | PAOC_CLAIM_CAT | Obsolete: Travel Expense FIORI Claim Categories | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
10 | PAOC_CLM_CAT | Map Text Fields for Travel and Expenses | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
11 | T5GPBS41 | Vehicle classes for car mileage | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
12 | T5GPBS42 | Declare vehicle types for private and business miles | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
13 | T5GPBS43 | Lump sum payment for car mileage | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
14 | T5GPBS_VEHCLASS | Derive vehicle class from car manufacturer and model | 4 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
15 | T5GPBS_VEHTYPE | Derive vehicle types from car information | 4 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
16 | T706_CITYCD_CHG | Replacement/Combination of Community Code Numbers, Date-Dep. | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
TOPLocalization |
17 | GLO_PTRV_COSTCL | Cost Classification | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
18 | GLO_PTRV_COSTCLT | Cost Classification (Text) | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
19 | PTRV_FUEL_TYPTXT | Names of Types of Fuel | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
20 | PTRV_FUEL_TYP_PR | Table for Fuel Type and Prices | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
TOPTravel Expenses |
21 | PTRV_ARCH_HEAD | Prearchiving FI-TV: Entries from PTRV_HEAD (Temporary) | 6 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
22 | PTRV_HEAD | General Trip Data | 6 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
23 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 9 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
24 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 9 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
25 | T702A | Employee Grouping for Travel Expense Type | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
26 | T702B | Credit Card Clearing Assignment Table | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
27 | T702C | Name for Employee Grouping for Travel Expense Type | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
28 | T702E | Vehicle Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
29 | T702G | Statutory trip types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
30 | T702H | Caculation Guide Lines: Meals PD/Max.Amounts Scaled by Time | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
31 | T702I | Statutory Reimbursement Groups for Meals/Accommodations | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
32 | T702J | Enterprise-spec.Reimbursement Groups for Meals/Accomm. | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
33 | T702K | Service provider | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
34 | T702L | Name of Service Provider | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
35 | T702N | Trip Provision Variants | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
36 | T702O | Trip country/Trip region/Trip country group | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
37 | T702P | Reimbursement Groups for Travel Costs/Add.Flat Rate Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
38 | T702Q | Name: Reimburs.Group for Travel Costs/Add.Flat Rate Types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
39 | T702R | Trip Activity Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
40 | T702V | Calc.Guide Lines for Scaling Meals PD/Max.Amounts by Hours | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
41 | T702W | Vehicle Classes | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
42 | T702X | Enterprise-specific Trip Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
43 | T702Y | Employee Groupings for Travel Management | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
44 | T702_BEREI_REL | Assignment of Trip Types Enterprise-Specific (PS AT) | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
45 | T706A | Trip Provision Deduction Amount/Percentage | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
46 | T706B | Travel Expense Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
47 | T706B1 | Travel Expense Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
48 | T706B2 | Travel Expense Types: Default Value/Maximum Amounts | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
49 | T706B3 | Travel Expense Type Grouping | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
50 | T706B4 | Travel Expense Types: Assignment of Wage Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
51 | T706B4_ALTERN | Travel Expense Type: Alternative Assignment of Wage Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
52 | T706B5 | Names for Travel Expense Types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
53 | T706B6 | Default Values When Difference Values Are Exceeded | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
54 | T706B6_T | Default Values When Difference Values Are Exceeded | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
55 | T706C | Names for Travel Expense Types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
56 | T706D | Default Values for Dialog | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
57 | T706E | Names for vehicle types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
58 | T706ESS2 | Travel Expenses Customizing for ESS Scenario | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
59 | T706F | Trip Provision: Flat Rates for Travel Costs | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
60 | T706F1 | Cumulation Procedure Dependent on Vehicle Type/Class | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
61 | T706F2 | Amount Accumulation Depending on Vehicle Type/Class | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
62 | T706FORM_BCKGRND | Form background | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
63 | T706FORM_BLKATTR | Form block attributes | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
64 | T706FORM_BLKHDLS | Form block titles | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
65 | T706FORM_BLK_HDL | Form block titles | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
66 | T706FORM_CLMATTR | Suppressable columns per block | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
67 | T706FORM_FIXTXT | Fixed texts | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
68 | T706FORM_FIXTXTS | Fixed texts (language-dependent) | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
69 | T706FORM_FLDS | Information in fixed positions | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
70 | T706FORM_VAR | Form variant | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
71 | T706FORM_VAR_TXT | Form variant (language-dependent) | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
72 | T706G | Names for statutory trip types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
73 | T706H | Trip Provision:Per-diem/Maximum Amount for Meals by Time | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
74 | T706I | Name for statutory reimbursement group for meals/accomm. | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
75 | T706J | Name for enterprise-specific reimburs.group for meals/acc. | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
76 | T706K | Initial Account Assignment for FI | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
77 | T706L | Assignment of Trip Country - Country Group - Region | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
78 | T706M | Input Tax for International Per Diems | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
79 | T706N | Names for trip provision variants | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
80 | T706O | Names for Trip Country/Trip Country Group/Trip Region | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
81 | T706P | Date Interval for Miles/Kms Accumulation | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
82 | T706Q | Names for period indicator for miles/kms accumulation | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
83 | T706R | Names for trip activity types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
84 | T706S | Trip Schema | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
85 | T706S_RECEIPT | Trip Schemas: Assignment of Travel Expense Types | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
86 | T706T | Names for trip schema | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
87 | T706T_ABWH | Texts for Absence Types (PS Separation Allowance) | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
88 | T706U | Trip Provision: Per Diem for Accommodations | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
89 | T706V | Trip Provision: Meals Per-diem/Maximum Amount by Hours | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
90 | T706W | Names for vehicle classes | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
91 | T706WWW | HTML Links and File Paths | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
92 | T706WWW_TXT | Text Table HTML Links and File Paths | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
93 | T706X | Names for enterprise-specific trip types | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
94 | T706Y | Names for Employee Groupings for Travel Management | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
95 | T706Z | Single Field Control for Dialog | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
96 | T706Z1 | Single Field Control for Dialog | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
97 | T706Z1_TXT | Text table: Individual Field Control for Dialog | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
98 | T706_ABWH | Absence Types from Place of Work (PS; Separation Allowance) | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
99 | T706_CITY_CD_46C | Table for Specifying the City Code/Community Code Number | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
100 | T706_CITY_CD_D | Definition: City Codes / Community Code No., Date-Dependent | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
101 | T706_CITY_CD_D_2 | Definition: City Codes / Community Code No., Date-Dependent | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
102 | T706_CITY_CODE | Table for Specifying the City Code/Community Code Number | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
103 | T706_CONST | PA parameters: Travel Management | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
104 | T706_CONSTTEXT | Names of Accounting Constants for Travel Expenses | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
105 | T706_COST_CP | Cost Comparison on Trip Level: Maximum Difference | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
106 | T706_COST_CP_R | Cost Comparison at Trip Level: Default Values | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
107 | T706_COST_CP_R_T | Cost Comparison at Trip Level: Default Values | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
108 | T706_DEFAULTTEXT | Names of Reference Texts for Entering Trips | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
109 | T706_LGART | Wage Type Assignmt Table for Clearing Add.Amts/Inc.Rel Exp. | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
110 | T706_REQ_CAT | Types of Transport/Accomm. and Est.Cost of Travel Request | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
111 | T706_REQ_CATTEXT | Name for Types of Transp/Accomm. and Est.Cost of Travel Req. | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
112 | T706_TEXTNAMES | Names of Reference Texts for Entering Trips | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
113 | T706_VAT_DEFLT | Country- and Expense Type-Dependent Defaults f. Receipt Data | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
114 | T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
115 | T706_VAT_POSTING | Data Entry and Posting of VAT Amount per Country of Receipt | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
TOPTravel Management |
116 | T706_WEB_DOCU | Documentation for a Web Application | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
117 | T706_WEB_DOCUTXT | Documentation for a Web Application | 3 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
TOPTravel Planning |
118 | TA22A | Assignment table expense code - service category | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |
119 | TA22B | Assignment trip schema - travel plan type | 2 | MOREI | Trip Provision Variant | nvarchar | 2 | 0 | | |