| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 98 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 40 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 98 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 40 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPEquipment |
| 5 | EQUZ | Equipment time segment | 29 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 6 | IEQT_WL_ITEMS | Interim Statuses - Items | 47 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 7 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 48 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPFunctional Locations |
| 8 | IFLOT | Functional Location (Table) | 34 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 9 | IFLOT_VS | Functional Location (Version Table) | 35 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 10 | ILOA | PM Object Location and Account Assignment | 2 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 11 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 3 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPMaintenance History |
| 12 | HIKO | Order master data history | 36 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPMaintenance Notifications |
| 13 | QMIH | Quality message - maintenance data excerpt | 4 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPMaintenance Orders |
| 14 | AFIH | Maintenance order header | 7 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPMaintenance Task Lists |
| 15 | MPOS | Maintenance item | 25 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPNetwork Objects |
| 16 | GHO_ILOA_EXT | OBSOLETE: DO NOT USE | 2 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPSerial Numbers |
| 17 | OBJK | Plant Maintenance Object List | 7 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPSimulation |
| 18 | VSAFIH_CN | Version: Order header for plant maintenance | 8 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| TOPWaste Management |
| 19 | EEWA_PROP_H | Header data of property | 8 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 20 | EWAELOCSD | Allocation Table: Container Loc.Data <-> Sales Document Item | 10 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 21 | EWAELOCSD_INT | EWAELOCSD Dummy Table With Key Fields as CHAR | 12 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 22 | EWAELOCSD_NEW | Allocation Table: Container Loc.Data <-> Sales Document Item | 12 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
| 23 | EWAPROPSD | Allocation Table: Property <-> Sales Document Item | 9 | ILOAN | Location and account assignment for technical object | nvarchar | 12 | 0 | | |
