| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBusiness Planning and Simulation |
| 1 | UPS_ATTRIBUT | Attributes for Planning Session | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 2 | UPS_CHANGELOG | Change Log for Status | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 3 | UPS_EVENTS | Table for Event Coupling in Planning Session | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 4 | UPS_HASH | Connection Hierarchy Key/Hash | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 5 | UPS_HEADER | Header Selections for STS | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 6 | UPS_LINKS | Links to Org. Values | 3 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 7 | UPS_LOCKS | Lock Table for Status and Tracking System | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 8 | UPS_REALIGN | Logging of Hierarchy Conversions as of 3.5 | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 9 | UPS_SUBSTITUTE | Table for Substitute Concept | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 10 | UPS_TEILPLAN | Subplan for Status and Tracking System | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 11 | UPS_TEILPLAN_T | Text Table for UPS_TEILPLAN | 3 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 12 | UPS_TP_AREA | Connection Subplan-Area | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
| 13 | UPS_TP_HIERARCHY | Connection Subplan-Hierarchy | 2 | TEILPLAN | Subplan in STS | nvarchar | 8 | 0 | | |
