| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1ISRWP/800H0111 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 10 | FILGRP | Filialgruppe | nvarchar | 2 | 0 | | |
2 | /1ISRWP/800H0112 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 10 | FILGRP | Filialgruppe | nvarchar | 2 | 0 | | |
3 | /1ISRWP/800H0113 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 10 | FILGRP | Filialgruppe | nvarchar | 2 | 0 | | |
4 | /1ISRWP/800H0208 | MAC: Planning Hierarchy Tables | 8 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
5 | /1ISRWP/800H0209 | MAC: Planning Hierarchy Tables | 8 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
6 | S955E | S955 - Strukturinformationen | 7 | FILGRP | Filialgruppe | nvarchar | 2 | 0 | | |
7 | S958E | S958 - Structural information | 9 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
TOPData Collection |
8 | S955 | Istdatenspeicher MAP - BW | 12 | FILGRP | Filialgruppe | nvarchar | 2 | 0 | | |
9 | S958 | Reference Structure for Generating Info Structures | 14 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
TOPMaterial Master |
10 | WSTN_AL_ALLOC | Prepack allocation planning lines | 4 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
11 | WSTN_AL_AULW | Prepack allocation planning delivery phases | 4 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
12 | WSTN_AL_FILGRP | Prepack allocation planning site group assignation | 4 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
13 | WSTN_AL_SGROUP | Prepack allocation planning site group definition | 4 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
TOPMerchandise and Assortment Planning |
14 | S208 | MAP: Assortment Planning | 9 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
15 | S208E | S208 - Structural Information | 9 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
16 | TWISPC_ASORTZ | Assignment of Store Groups to Assortments | 2 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
17 | TWISPC_FILGRP | Store Groups | 2 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
18 | TWISPC_FILGRPT | Store Groups | 3 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
19 | TWISPC_FILGRPZ | Assignment of Stores to Store Groups | 6 | FILGRP | Store Group | nvarchar | 2 | 0 | | |
20 | TWISPS_NOPROMO1 | Parameters for Promotions Created in MAP | 16 | FILGRP | Plant grouping, sales promotion | nvarchar | 18 | 0 | | |