| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInformation System |
| 1 | TCNDB | Profile: Database parameters in Project Info System | 11 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | | |
| 2 | TCNDB_PSJT | Profile: as TCNDB, only for verification of LDB PSJ!! | 10 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | | |
| TOPOperative Structures |
| 3 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 76 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | | |
| 4 | PRTP | Subprojects | 2 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | | |
| TOPReport Selection for Product Costing |
| 5 | TKKBU | Application-Dependent Report Parameters | 5 | SUBPR | Subparameter | nvarchar | 1 | 0 | | |
| TOPSimulation |
| 6 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 77 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | | |
| TOPTemplates |
| 7 | PRPSS | Standard WBS Element (WBS element) - Master Data | 76 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | | |
