| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 96 | TIDNR | Technical identification number | nvarchar | 25 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 96 | TIDNR | Technical identification number | nvarchar | 25 | 0 | | |
TOPEquipment |
3 | EQUZ | Equipment time segment | 27 | TIDNR | Technical identification number | nvarchar | 25 | 0 | | |
4 | IEQT_WL_ITEMS | Interim Statuses - Items | 45 | TIDNR | Technical identification number | nvarchar | 25 | 0 | | |
5 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 46 | TIDNR | Technical identification number | nvarchar | 25 | 0 | | |
TOPPlant Maintenance |
6 | Z9I_STK_IF_NPV | PM/PS-Schnittstelle: Netzplanvorgänge | 15 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |
7 | Z9I_STK_IF_NPV_W | PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht | 20 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |
8 | Z9I_STK_IF_PSP | PM/PS-Interface: PSP-Elemente | 7 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |
9 | Z9I_STK_IF_PSP_W | PM/PS-Interface: PSP-Elemente Werkstattsicht | 7 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |
10 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 6 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |
11 | Z9MIANF | Stillstanndsplanung - Daten für Anfragen | 4 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |
12 | Z9MISTP | Stillstandsplanung | 13 | TIDNR | Technische Identnummer | nvarchar | 25 | 0 | | |