| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Functions |
| 1 | T854S | Selected FS items | 3 | ITKEY | Classification key for selected FS items | nvarchar | 3 | 0 | | |
| TOPBusiness Consolidation |
| 2 | UCMI200 | Selected Items: Cross-Functional | 3 | ITKEY | Classification Key for Selected Items | nvarchar | 3 | 0 | | |
| 3 | UCMI201 | Selected Items: Document Type-dependent | 3 | ITKEY | Classification Key for Selected Items | nvarchar | 3 | 0 | | |
| 4 | UCMI20C | Selected Items: Check Table | 1 | ITKEY | Classification Key for Selected Items | nvarchar | 3 | 0 | | |
| 5 | UCMI20T | Selected Items: Text Table | 2 | ITKEY | Classification Key for Selected Items | nvarchar | 3 | 0 | | |
| 6 | UCMI210 | Selected Items: Consolidation of Investments | 3 | ITKEY | Classification Key for Selected Items | nvarchar | 3 | 0 | | |
| 7 | UCMI220 | Selected Items: Elimination of IU Profit/Loss in Inventory | 3 | ITKEY | Classification Key for Selected Items | nvarchar | 3 | 0 | | |
| TOPConsolidation |
| 8 | TF141 | Selected FS Items | 4 | ITKEY | Classification key for selected items | nvarchar | 3 | 0 | | |
| 9 | TF390 | Selected Items for Carryforwards | 4 | ITKEY | Classification key for carryforward | nvarchar | 3 | 0 | | |
| 10 | TF591 | Elim of IU Profit/Loss in Inventory: FS Items (NOT USED) | 5 | ITKEY | Elim. IU P/L in inventory: classif. key for posted items | nvarchar | 3 | 0 | | |
| 11 | TF592A | Elimination of IU Profit/Loss in Inventory: FS Items | 5 | ITKEY | Elim. IU P/L in inventory: classif. key for posted items | nvarchar | 3 | 0 | | |
| 12 | TF695 | Selected Items for Consolidation of Investments | 4 | ITKEY | Classification key | nvarchar | 3 | 0 | | |
| TOPPersonnel Time Management |
| 13 | PTARQ_DIR | ESA: Interface Table for Infotypes (Directory Table) | 2 | ITKEY | Document ID | nvarchar | 32 | 0 | | |
