| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 87 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 23 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 87 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 23 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
5 | PA3362 | HR Master Record: Infotype 3362 | 36 | SUBMT | Submitted | nvarchar | 1 | 0 | | |
TOPEquipment |
6 | EQUZ | Equipment time segment | 18 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
7 | IEQT_WL_ITEMS | Interim Statuses - Items | 36 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
8 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 37 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
TOPFunctional Locations |
9 | IFLOT | Functional Location (Table) | 17 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
10 | IFLOT_VS | Functional Location (Version Table) | 18 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
11 | IRLOT | Reference Functional Location (Table) | 13 | SUBMT | Construction type material of the object | nvarchar | 18 | 0 | | |
TOPReporting |
12 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 45 | SUBMT | Material number for equipment | nvarchar | 18 | 0 | | |
13 | S062 | Object class and manufacturer | 9 | SUBMT | Material number for equipment | nvarchar | 18 | 0 | | |
14 | S062E | S062 - Structural Information | 4 | SUBMT | Material number for equipment | nvarchar | 18 | 0 | | |
15 | S065 | Object statistics | 9 | SUBMT | Material number for equipment | nvarchar | 18 | 0 | | |
16 | S065E | S065 - Structural Information | 4 | SUBMT | Material number for equipment | nvarchar | 18 | 0 | | |