| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /GEP/T_NEED | Graphischer Leitstand: Bedarfe (einzuplanende Objekte) | 21 | KUNUM | Kundennummer | nvarchar | 10 | 0 | | |
| 2 | /GEP/T_SPLIT | Graphischer Leitstand: Splits (eingeplante Objekte) | 22 | KUNUM | Kundennummer | nvarchar | 10 | 0 | | |
| 3 | S901E | S901 - Strukturinformationen | 4 | KUNUM | Kundennummer | nvarchar | 10 | 0 | | |
| 4 | ZSMSM | control table for SMS in SD | 4 | KUNUM | Debitorennummer | nvarchar | 10 | 0 | | |
| TOPData Collection |
| 5 | S099 | QM notifications: customer analysis | 8 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 6 | S099E | S099 - Structural Information | 3 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 7 | S103 | Problems: Customer Analysis | 8 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 8 | S103E | S103 - Structural Information | 3 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 9 | S116 | Customer Analysis | 13 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 10 | S116E | S116 - Structural information | 8 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 11 | S901 | Garantieauswertung | 9 | KUNUM | ????? ??????? | nvarchar | 10 | 0 | | |
| TOPInformation System |
| 12 | MCAFKOV | Versions: Order Header Data - PP Orders | 32 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| 13 | MCSFIS | R/2 SFIS Data: Old | 38 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| TOPMaintenance History |
| 14 | HIKO | Order master data history | 44 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| TOPMaintenance Notifications |
| 15 | QMEL | Quality Notification | 30 | KUNUM | Account Number of Customer | nvarchar | 10 | 0 | | |
| TOPMaintenance Orders |
| 16 | AFIH | Maintenance order header | 15 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| TOPMaintenance Task Lists |
| 17 | MPLA | Maintenance plan | 14 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
| TOPSimulation |
| 18 | VSAFIH_CN | Version: Order header for plant maintenance | 16 | KUNUM | Customer Number | nvarchar | 10 | 0 | | |
