| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTTM/BL_T_EDC | Customizing table for mapping of expense and doc types | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
2 | /OTTM/BL_T_ERM | E-Receipt metadata | 19 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
3 | /OTTM/BL_T_MAC | Mapping of Classification to Expense Types | 4 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
4 | PAOC_CLAIM_CAT | Obsolete: Travel Expense FIORI Claim Categories | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
5 | PAOC_CLM_CAT | Map Text Fields for Travel and Expenses | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
TOPTravel Expenses |
6 | T702B | Credit Card Clearing Assignment Table | 8 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
7 | T706B | Travel Expense Types | 10 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
8 | T706B1 | Travel Expense Types | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
9 | T706B2 | Travel Expense Types: Default Value/Maximum Amounts | 10 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
10 | T706B4 | Travel Expense Types: Assignment of Wage Types | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
11 | T706B4_ALTERN | Travel Expense Type: Alternative Assignment of Wage Types | 5 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
12 | T706B5 | Names for Travel Expense Types | 4 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
13 | T706B6 | Default Values When Difference Values Are Exceeded | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
14 | T706B6_T | Default Values When Difference Values Are Exceeded | 4 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
15 | T706C | Names for Travel Expense Types | 4 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
16 | T706S_RECEIPT | Trip Schemas: Assignment of Travel Expense Types | 4 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
17 | T706_DEFAULTTEXT | Names of Reference Texts for Entering Trips | 4 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
18 | T706_VAT_DEFLT | Country- and Expense Type-Dependent Defaults f. Receipt Data | 3 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |
TOPTravel Planning |
19 | TA22A | Assignment table expense code - service category | 7 | SPKZL | Travel Expense Type | nvarchar | 4 | 0 | | |