| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1RA/0SD010MI | Items for Class SD01 - Raw Data | 115 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
2 | CE1PR22 | Périm. résultat IDES | 77 | VRTNR | Commercial | nvarchar | 8 | 0 | | |
3 | CE2PR22 | Périm. résultat IDES | 61 | VRTNR | Commercial | nvarchar | 8 | 0 | | |
4 | CE4PR22 | Périm. résultat IDES | 46 | VRTNR | Commercial | nvarchar | 8 | 0 | | |
5 | CE4PR22_ACCT | Périm. résultat IDES | 47 | VRTNR | Commercial | nvarchar | 8 | 0 | | |
6 | CE4PR22_FLAG | Périm. résultat IDES | 43 | VRTNR | Flag : caract. imputée manuellement ou via TKEZU | nvarchar | 1 | 0 | | |
7 | CE4PR22_KENC | Périm. résultat IDES | 45 | VRTNR | Commercial | nvarchar | 8 | 0 | | |
8 | CNV_20800_KNVK | CNV backup copy: Customer master contact person | 21 | VRTNR | Representative number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
9 | SKNVK | Customer Master Contact table for BC417 Course | 20 | VRTNR | Representative number | nvarchar | 10 | 0 | | |
TOPCustomer Master |
10 | KNVK | Customer Master Contact Partner | 20 | VRTNR | Representative number | nvarchar | 10 | 0 | | |
TOPData Collection |
11 | CF703 | IDES Profitability | 14 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
12 | S006 | SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product | 8 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
13 | S006BIW1 | S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 3 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
14 | S006BIW2 | S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 3 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
15 | S006E | S006 - Structural Information | 3 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
TOPProfitability Analysis |
16 | CE18500 | | 61 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
17 | CE1IDEA | Op. Concern BR World | 77 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
18 | CE1IDES | Ergebnisbereich IDES | 77 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
19 | CE1INT1 | Ergebnisbereich IDES | 77 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
20 | CE1S300 | Operating Concern IDES | 60 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
21 | CE28500 | | 45 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
22 | CE2IDEA | Op. Concern BR World | 61 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
23 | CE2IDES | Ergebnisbereich IDES | 61 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
24 | CE2INT1 | Ergebnisbereich IDES | 61 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
25 | CE2S300 | Operating Concern IDES | 44 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
26 | CE48500 | | 30 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
27 | CE48500_ACCT | | 31 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
28 | CE48500_FLAG | | 27 | VRTNR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
29 | CE48500_KENC | | 29 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
30 | CE4IDEA | Op. Concern BR World | 46 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
31 | CE4IDEA_ACCT | Op. Concern BR World | 47 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
32 | CE4IDEA_FLAG | Op. Concern BR World | 43 | VRTNR | Flag: Characteristic Assigned Manually or Using TKEZU | nvarchar | 1 | 0 | | |
33 | CE4IDEA_KENC | Op. Concern BR World | 45 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
34 | CE4IDES | Ergebnisbereich IDES | 46 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
35 | CE4IDES_ACCT | Ergebnisbereich IDES | 47 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
36 | CE4IDES_FLAG | Ergebnisbereich IDES | 43 | VRTNR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
37 | CE4IDES_KENC | Ergebnisbereich IDES | 45 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
38 | CE4INT1 | Ergebnisbereich IDES | 46 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
39 | CE4INT1_ACCT | Ergebnisbereich IDES | 47 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
40 | CE4INT1_FLAG | Ergebnisbereich IDES | 43 | VRTNR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
41 | CE4INT1_KENC | Ergebnisbereich IDES | 45 | VRTNR | Vertriebsbeauftragter | nvarchar | 8 | 0 | | |
42 | CE4S300 | Operating Concern IDES | 29 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
43 | CE4S300_ACCT | Operating Concern IDES | 30 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |
44 | CE4S300_FLAG | Ergebnisbereich IDES Serv.Prov | 26 | VRTNR | Flag: Merkmal manuell oder über TKEZU kontiert | nvarchar | 1 | 0 | | |
45 | CE4S300_KENC | Operating Concern IDES | 28 | VRTNR | Sales employee | nvarchar | 8 | 0 | | |