| 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 | | |
