| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | P44V | Planning Versions | 18 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| TOPDemand Management |
| 2 | PBID | Planned independent requirements index: MRP area | 21 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 3 | PBIM | Independent Requirements for Material | 19 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| TOPKANBAN |
| 4 | PKPR | Change Proposals from Kanban Calculation | 42 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| TOPMaster Data |
| 5 | DBVL | Planning File Entry, MRP Area, Long-Term Planning | 3 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 6 | EMRP_RUN | Blocking argument for MRP | 3 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 7 | KBVL | Individual Customer Plng File Entry, MRP Area Long-Term Plng | 3 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 8 | KDVL | Individual Customer Planning File Entry, Long-Term Planning | 3 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 9 | MDCOV | Table with Range of Coverage Information | 2 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 10 | MDDMAP | Mapping Table for External User for MRP Evaluations | 4 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 11 | MDFD | MRP firming date | 4 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 12 | MDFDDB | Firming Data of MRP - MRP Area | 4 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 13 | MDKP | Header Data for MRP Document | 5 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 14 | MDKPDB | Header Data for MRP Document | 5 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 15 | MDSM | Simulative dependent requirements | 9 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 16 | MDVL | Planning file entry for long-term planning | 3 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 17 | PLAF | Planned Order | 75 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 18 | PLPB | Long-term planning: Independent requirements versions | 2 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 19 | PLPT | Long-term planning: Plants of planning scenario | 2 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 20 | PLSC | Planning scenarios in long-term planning | 2 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 21 | T442C | Control: activity reqmts transfer MRP/SOP -> CO | 8 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| TOPProduct Cost Planning |
| 22 | KEKO | Product Costing - Header Data | 49 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| TOPScheduling |
| 23 | KBED | Capacity Requirements Records | 65 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 24 | TCX0L | Scheduling long term planning: Levels and control parameters | 6 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| TOPSimulation |
| 25 | VSKBED_CN | Version: Capacity requirement records | 66 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
| 26 | VSPLAF_CN | Version: Planned order | 75 | PLSCN | Planning Scenario of Long-Term Planning | nvarchar | 3 | 0 | | |
