| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogistics Basic Data |
1 | CMMD_CDT5 | Master Data Sub-Subsegment | 2 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
2 | CMMD_CDT5T | Master Data Texts Sub-Subsegment | 3 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
3 | CMMD_SKU | CDT-SKU Assignment Table | 9 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
4 | WRF_CMMD_CDT5 | Sub-Subsegment | 2 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
5 | WRF_CMMD_CDT5T | Sub-Subsegment Texts | 2 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
6 | WRF_CMMD_SKU | CDT-SKU Assignment Table | 9 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
TOPMerchandise and Assortment Planning |
7 | S212 | CatMan: Hohe Ebene | 13 | CDT5 | Subsubsegment | nvarchar | 18 | 0 | | |
8 | S212BIW1 | S212BIW1 * CatMan: High Level | 8 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
9 | S212BIW2 | S212BIW2 * CatMan: High Level | 8 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
10 | S212E | S212 - Strukturinformationen | 8 | CDT5 | Subsubsegment | nvarchar | 18 | 0 | | |
11 | S214 | CatMan: Indizees für ROP | 31 | CDT5 | Subsubsegment | nvarchar | 18 | 0 | | |
12 | S214BIW1 | S214BIW1 * CatMan: Indexes for Space Management Program | 31 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
13 | S214BIW2 | S214BIW2 * CatMan: Indexes for Space Management Program | 31 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
14 | S219 | CatMan: Feine Ebene | 20 | CDT5 | Subsubsegment | nvarchar | 18 | 0 | | |
15 | S219BIW1 | S219BIW1 * CatMan: Fine Level | 20 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |
16 | S219BIW2 | S219BIW2 * CatMan: Detailed Level | 20 | CDT5 | Sub-Subsegment | nvarchar | 18 | 0 | | |