| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | S952E | S952 - Structural information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 2 | S957E | S957 - Structural information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| TOPData Collection |
| 3 | S952 | Reference Structure for Generating Info Structures | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 4 | S957 | Reference Structure for Generating Info Structures | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| TOPMaterial Master |
| 5 | WSTN_BW_EXTRACT | Sample DB Table that contains pre-extracted data from B.W. | 6 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| TOPMerchandise and Assortment Planning |
| 6 | S202 | MAP: Merchandise Planning Structure | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 7 | S202E | S202 - Structural Information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 8 | S203 | MAP: Merchandise Planning Stock | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 9 | S203E | S203 - Structural Information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 10 | S204 | MAP: Merchandise Planning Movements | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 11 | S204E | S204 - Structural Information | 11 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 12 | S206 | MAP: Store Planning Stocks | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 13 | S206E | S206 - Structural Information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 14 | S207 | MAP: Store Planning Structure | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 15 | S207E | S207 - Structural Information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 16 | S209 | MAP: OTB Movements | 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 17 | S209E | S209 - Structural Information | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 18 | S210 | MAP: OTB Stock | 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 19 | S210E | S210 - Structural Information | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 20 | S211 | MAP: OTB Evaluation Structure | 17 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 21 | S211E | S211 - Structural Information | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 22 | S212 | CatMan: Hohe Ebene | 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
| 23 | S212BIW1 | S212BIW1 * CatMan: High Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 24 | S212BIW2 | S212BIW2 * CatMan: High Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 25 | S212E | S212 - Strukturinformationen | 11 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
| 26 | S214 | CatMan: Indizees für ROP | 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
| 27 | S214BIW1 | S214BIW1 * CatMan: Indexes for Space Management Program | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 28 | S214BIW2 | S214BIW2 * CatMan: Indexes for Space Management Program | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 29 | S214E | S214 - Strukturinformationen | 11 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
| 30 | S219 | CatMan: Feine Ebene | 18 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
| 31 | S219BIW1 | S219BIW1 * CatMan: Fine Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 32 | S219BIW2 | S219BIW2 * CatMan: Detailed Level | 18 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 33 | S219E | S219 - Strukturinformationen | 11 | PSWAE | Geheugenvaluta van plangegevens van een planningsscenario | nvarchar | 5 | 0 | | |
| 34 | TWISPA_AVERAGERT | Merchandise and Assortment Planning: Average Retail | 13 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 35 | TWISPA_AVGRET | Merchandise and Assortment Planning: Average Retail | 10 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 36 | TWISPC_PLSZN | Retail Planning: Planning Scenario | 3 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| TOPReporting |
| 37 | S205 | MAP: Store Planning Movements | 15 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
| 38 | S205E | S205 - Structure Information | 8 | PSWAE | Database Currency for Planning Data in a Planning Scenario | nvarchar | 5 | 0 | | |
