| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | A913 | Material/Customer/Sales org. | 5 | HIENR | Customer | nvarchar | 10 | 0 | | |
2 | A951 | Sales org./Distr. Chl/HierarchyNode/Material | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
3 | A952 | Sales org./Distr. Chl/HierarchyNode/PH1/PH2/PH3 | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
4 | KOTE960 | Sales org./Distr. Chl/Customer/Material | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
TOPConditions |
5 | A064 | Customer Hierarchy | 7 | HIENR | Customer | nvarchar | 10 | 0 | | |
6 | A065 | Customer Hierarchy/Material | 7 | HIENR | Customer | nvarchar | 10 | 0 | | |
7 | A976 | Sales Org/DistrChannel/Customer/Material/Personnel NR | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
8 | KOT3522 | Sales org./Distr. Chl/Customer Hierarchy/Material | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
9 | KOTE004 | Customer Hierarchy | 7 | HIENR | Customer | nvarchar | 10 | 0 | | |
10 | KOTE005 | Customer Hierarchy/Material | 7 | HIENR | Customer | nvarchar | 10 | 0 | | |
11 | KOTE522 | Camp. ID/Customer/Material | 5 | HIENR | Customer | nvarchar | 10 | 0 | | |
12 | KOTE524 | Camp. ID/Customer/Matl grp 1 | 5 | HIENR | Customer | nvarchar | 10 | 0 | | |
13 | KOTE950 | Condition Table for Rebate KOTE950 | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
14 | KOTE999 | Sales org./Distr. Chl/Customer/Prod.hier. | 6 | HIENR | Customer | nvarchar | 10 | 0 | | |
15 | KOTH007 | Customer Hierarchy | 4 | HIENR | Customer | nvarchar | 10 | 0 | | |
16 | KOTH008 | Customer Hierarchy/Material | 4 | HIENR | Customer | nvarchar | 10 | 0 | | |
TOPOverhead Cost Orders |
17 | COBRA | Settlement Rule for Order Settlement | 21 | HIENR | Hierarchy number for settlement | nvarchar | 3 | 0 | | |