| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Functions |
1 | LFEI | Vendor Master: Preference for Import and Export | 5 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
2 | MAPEWG | Material master: Preference determination: Cross-plant | 5 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
3 | MMPREF_PRO_01 | Logging table for archiving object MMPREF | 6 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
4 | MMPREF_PRO_01_B | Log table - Preference - Information from rules | 6 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
5 | MMPREF_PRO_03 | Log table - Component - Information | 6 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
6 | MMPREK_PRO_01 | Log table for archiving object MMPREK | 9 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
7 | MMPREK_PRO_01_B | Log table - Preference - Info from rule | 9 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
8 | MMPREK_PRO_03 | Log table - Component - Information | 9 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
9 | MMPREW_PRO_01 | Log table for archiving object MMPREW | 10 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
10 | MMPREW_PRO_01_B | Preference CPG: Log - Information from rule | 8 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
11 | MMPREW_PRO_03 | Preference CPG: Log components - Information | 8 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
12 | T604B | Preference: Preference Zone Description | 4 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
13 | T604G | Preference: Preference Zone | 3 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
14 | T604P | Preference: Preference Zone/Rule | 4 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
15 | T604S | Preference: Determine Preference Zone in Export | 4 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
TOPConditions |
16 | A074 | Plant/Preference Zone/Material | 5 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
17 | A180 | Country/Preference Zone/Cross-Plant Grouping | 5 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
18 | A185 | Order no./Item/Configuration no./Material/Preference zone | 8 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |
TOPMaterial Master |
19 | MAPE | Material Master: Export Control File | 4 | GZOLX | Preference zone | nvarchar | 4 | 0 | | |