| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPSRM/SH_MATPL | Table for ERP Search Help Maintenance Plan of SES | 3 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
2 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 55 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 55 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPEquipment |
4 | EQUI | Equipment master data | 50 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPExternal Services |
5 | ESSR | Service Entry Sheet Header Data | 42 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPIndustry-Specific Component Automotive |
6 | MHIO_UNPACKED | Copy of database table MHIO (Data cat.INT4 replaced by NUMC) | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
7 | MHIS_UNPACKED | Copy of DB table MHIS (Data category INT4 replaced by NUMC) | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPMaintenance History |
8 | HIKO | Order master data history | 54 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPMaintenance Notifications |
9 | QMIH | Quality message - maintenance data excerpt | 28 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPMaintenance Orders |
10 | AFIH | Maintenance order header | 25 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPMaintenance Task Lists |
11 | MHIO | Call Object from Maintenance Order | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
12 | MHIS | Maintenance plan history | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
13 | MMPT | Cycle definitions and MeasPoints for MaintPlan | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
14 | MMPX | Maintenance cycle short texts | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
15 | MPLA | Maintenance plan | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
16 | MPLAN_STRAT_UPD | Maintenance Plans Relevant to Restart in Cycle | 2 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
17 | MPOS | Maintenance item | 3 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPQuality Inspection |
18 | QALS | Inspection lot record | 222 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |
TOPSimulation |
19 | VSAFIH_CN | Version: Order header for plant maintenance | 26 | WARPL | Maintenance Plan | nvarchar | 12 | 0 | | |