| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 124 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 68 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 124 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| 4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 68 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| Equipment | ||||||||||
| 5 | IEQT_WL_ITEMS | Interim Statuses - Items | 68 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| 6 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 69 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| Functional Locations | ||||||||||
| 7 | ILOA | PM Object Location and Account Assignment | 6 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| 8 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 7 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| Maintenance Orders | ||||||||||
| 9 | /CUM/CONMS | CU: Construction Measure Master Data | 7 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| 10 | /CUM/CUNIT | CU: Master Data | 11 | EQFNR | Sort field | nvarchar | 30 | 0 | ||
| Reporting | ||||||||||
| 11 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 31 | EQFNR | Sort field | nvarchar | 30 | 0 | ||