| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Functions |
| 1 | VBBE | Sales Requirements: Individual Records | 35 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| TOPCross-Application Components |
| 2 | AAUUFK | Order master data | 63 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| TOPDemand Management |
| 3 | PBID | Planned independent requirements index: MRP area | 31 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
| 4 | PBIM | Independent Requirements for Material | 29 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
| TOPInventory Management |
| 5 | RESB | Reservation/dependent requirements | 96 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| TOPMaintenance History |
| 6 | HIKO | Order master data history | 23 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| TOPMaintenance Orders |
| 7 | T352R | Maintenance revisions | 14 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| TOPMaintenance Task Lists |
| 8 | MPOS | Maintenance item | 36 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 9 | MDSM | Simulative dependent requirements | 93 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| 10 | PLAF | Planned Order | 37 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| 11 | PSPL | Index project -> planned order | 2 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| TOPOverhead Cost Orders |
| 12 | AUFK | Order master data | 63 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| TOPProject System |
| 13 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 20 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| 14 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 20 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| TOPSimulation |
| 15 | VSAUFK_CN | Version: Order master data | 64 | PSPEL | Work breakdown structure element (WBS element) | nvarchar | 8 | 0 | | |
| 16 | VSPLAF_CN | Version: Planned order | 38 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| 17 | VSRESB_CN | Version: Reservation/Dependent requirements | 97 | PSPEL | WBS Element | nvarchar | 8 | 0 | | |
| TOPWork Clearance Management |
| 18 | WCAAP | WCM: Application | 36 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
| 19 | WCAHE | WCM: Work Clearance Document (Header) | 36 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
| 20 | WCAW | WCM: Work Approval | 34 | PSPEL | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | | |
