| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /CPD/D_PFP_MS | Mapped Structure | 8 | RATIO | Ratio for mapping Bid to Execution structure | decimal | 6 | 2 | | |
| TOPAlternative Valuation Run |
| 2 | MLAVRSCALE | Re-scaling Amounts AVR | 21 | RATIO | | decimal | 5 | 0 | | |
| TOPBasic Functions |
| 3 | T870 | Consolidation method assignment | 7 | RATIO | Proportion | decimal | 7 | 4 | | |
| TOPBusiness Planning and Simulation |
| 4 | UPP_CHAR | Planning: Characteristics | 6 | RATIO | Screen Area Within Row/Column Structure | nvarchar | 1 | 0 | | |
| 5 | UPP_ELEMT | Planning: Column Elements Texts | 6 | RATIO | Screen Area Within Row/Column Structure | nvarchar | 1 | 0 | | |
| 6 | UPP_SPREADS | Planning: Spreadsheet Customizing | 5 | RATIO | Screen Area Within Row/Column Structure | nvarchar | 1 | 0 | | |
| TOPInvestment Programs |
| 7 | TAIGK | Key figure key for scale | 3 | RATIO | Key figure key for scale | nvarchar | 4 | 0 | | |
| 8 | TAIGM | Possible key figures keys for scale | 2 | RATIO | Key figure key for scale | nvarchar | 4 | 0 | | |
| 9 | TAIGS | Key figure key for scale (language-dependent) | 2 | RATIO | Key figure key for the scale of cap. investment measures | nvarchar | 4 | 0 | | |
| TOPPlanning |
| 10 | T8PL01 | FI-Planning: Summary Table Dimensions to be Planned | 18 | RATIO | Screen area within row/column structure | nvarchar | 1 | 0 | | |
| TOPTransaction Management |
| 11 | TIDX_PRICE_INDEX | Price Index Main Entity | 4 | RATIO | Index Base | decimal | 12 | 6 | | |
| TOPWaste Management |
| 12 | EWA_EL_WDPPROTYP | Transaction Category (Items) | 7 | RATIO | Portion of Total Quantity | decimal | 5 | 2 | | |
