| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBusiness Consolidation |
1 | UCFTL01 | Data Transfer Overview Screen: Methods | 7 | METHOD_ID | GUID for Identifying the Method | nvarchar | 22 | 0 | | |
TOPMedia Product Sales and Distribution |
2 | TJKSDFCSEGMETHD | Method Definition for Segmentation (Forecast) | 2 | METHOD_ID | Segmentation Method (Forecast) | nvarchar | 3 | 0 | | |
3 | TJKSDFCSEGMETHDT | Method Definition for Segmentation (Forecast) | 2 | METHOD_ID | Segmentation Method (Forecast) | nvarchar | 3 | 0 | | |
4 | TJKSDFCSEGVAR | Segmentation Variant | 3 | METHOD_ID | Rule for Assigning Contracts to Segments | nvarchar | 2 | 0 | | |
5 | TJKSDPQPCALC3 | Calculation Procedure for Purchase Planning | 4 | METHOD_ID | Calculation Method in Purchase Order Quantity Planning | nvarchar | 3 | 0 | | |
6 | TJKSDSQPCALC3 | Calculation Procedure in Sales Planning | 4 | METHOD_ID | Calculation Method in Quantity Planning | nvarchar | 3 | 0 | | |
7 | TJKSDVIEWAGGMETH | Assignment of Distribution Methods to Quantity Planning View | 3 | METHOD_ID | Distribution Method in Quantity Planning | nvarchar | 3 | 0 | | |
8 | TJKSDVIEWEXFUNC | Assignment of Calculation Methods to Quantity Planning View | 4 | METHOD_ID | Calculation Method in Quantity Planning | nvarchar | 3 | 0 | | |
9 | TJKSDVIEWFUNC | Calculation Method for Quantity Planning View | 2 | METHOD_ID | Calculation Method in Quantity Planning | nvarchar | 3 | 0 | | |
10 | TJKSDVIEWFUNCT | Text - Calculation Method for Quantity Planning View | 2 | METHOD_ID | Calculation Method in Quantity Planning | nvarchar | 3 | 0 | | |
11 | TJKSDVIEWMETHOD | Distribution Method for Quantity Planning View | 2 | METHOD_ID | Distribution Method in Quantity Planning | nvarchar | 3 | 0 | | |
12 | TJKSDVIEWMETHODT | Text - Distribution Method for Planning View | 2 | METHOD_ID | Distribution Method in Quantity Planning | nvarchar | 3 | 0 | | |
13 | TJVSDWLOPTMETH | Optimization Methods for Shipping Worklist | 2 | METHOD_ID | Optimization Method for Shipping Worklist | nvarchar | 3 | 0 | | |
14 | TJVSDWLOPTMETHT | Texts - Optimization Methods for Shipping Worklist | 2 | METHOD_ID | Optimization Method for Shipping Worklist | nvarchar | 3 | 0 | | |
15 | TJVSDWL_ADDIN | Optimization Methods in Shipping Worklist | 3 | METHOD_ID | Optimization Method for Shipping Worklist | nvarchar | 3 | 0 | | |
TOPTemplates |
16 | TFW_METHOD | TFW: Read Methods | 3 | METHOD_ID | Read Method ID | nvarchar | 10 | 0 | | |
17 | TFW_METHOD_T | TFW: Read Methods, Texts | 4 | METHOD_ID | Read Method ID | nvarchar | 10 | 0 | | |
18 | TFW_STRATEGY01 | TFW: Assignment of Methods to Read Strategies | 5 | METHOD_ID | Read Method ID | nvarchar | 10 | 0 | | |