| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDSD Connector |
1 | /DSD/ME_CUST_HD | DSD CN: Customer Details | 55 | PRICE_GROUP | DSD Connector: Price Group | nvarchar | 2 | 0 | | |
2 | /DSD/ME_CUST_SA | DSD CN: Sales area dependent customer master data | 22 | PRICE_GROUP | DSD Connector: Price Group | nvarchar | 2 | 0 | | |
TOPLogistics Basic Data |
3 | WRF_CMMD_CDT1 | Category | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
4 | WRF_CMMD_CDT2 | Subcategory | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
5 | WRF_CMMD_CDT3 | Segment | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
6 | WRF_CMMD_CDT4 | Subsegment | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
7 | WRF_CMMD_CDT5 | Sub-Subsegment | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
8 | WRF_CMMD_CDT6 | Product Group | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
9 | WRF_CMMD_CDT7 | Brand | 17 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
10 | WRF_MATGRP_MD1 | Hierarchy Level 1 - Time-Dependent | 22 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
11 | WRF_MATGRP_MD10 | Hierarchy Level 10 - Time-Dependent | 31 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
12 | WRF_MATGRP_MD2 | Hierarchy Level 2 - Time-Dependent | 23 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
13 | WRF_MATGRP_MD3 | Hierarchy Level 3 - Time-Dependent | 24 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
14 | WRF_MATGRP_MD4 | Hierarchy Level 4 - Time-Dependent | 25 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
15 | WRF_MATGRP_MD5 | Hierarchy Level 5 - Time-Dependent | 26 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
16 | WRF_MATGRP_MD6 | Hierarchy Level 6 - Time-Dependent | 27 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
17 | WRF_MATGRP_MD7 | Hierarchy Level 7 - Time-Dependent | 28 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
18 | WRF_MATGRP_MD8 | Hierarchy Level 8 - Time-Dependent | 29 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
19 | WRF_MATGRP_MD9 | Hierarchy Level 9 - Time-Dependent | 30 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
20 | WRF_MATGRP_STRUC | Category Structure | 12 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
TOPMaterial Groups |
21 | T023 | Material Groups | 15 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
TOPMaterial Master |
22 | WRF_PRGRP | Price Level Groups | 2 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
23 | WRF_PRGRPLEVELS | Price Levels of a Price Pattern | 2 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
24 | WRF_PRGRPSCHEMA | Price Pattern | 2 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |
25 | WRF_PRGRPT | Names of Price Groups | 2 | PRICE_GROUP | Price Level Group | nvarchar | 6 | 0 | | |