| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 94 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 94 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
TOPEquipment |
3 | EQUZ | Equipment time segment | 25 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
4 | IEQT_WL_ITEMS | Interim Statuses - Items | 43 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
5 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 44 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
TOPMaintenance History |
6 | HIKO | Order master data history | 43 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
TOPMaintenance Orders |
7 | AFIH | Maintenance order header | 14 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
8 | T352R | Maintenance revisions | 11 | GEWRK | Main work center for maintenance tasks | nvarchar | 8 | 0 | | |
9 | TPMUS | PM/SM - User default values | 22 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
TOPMaintenance Program Definition |
10 | MPDITEM | Maintenance Plan Items | 8 | GEWRK | Main work center for maintenance tasks | nvarchar | 8 | 0 | | |
TOPMaintenance Task Lists |
11 | MPOS | Maintenance item | 22 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |
TOPPlant Maintenance |
12 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 18 | GEWRK | Arbeitsplatz | nvarchar | 8 | 0 | | |
TOPSimulation |
13 | VSAFIH_CN | Version: Order header for plant maintenance | 15 | GEWRK | Object ID of the Work Center | nvarchar | 8 | 0 | | |