| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 147 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| 2 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 91 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| 3 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 147 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| 4 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 91 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| 5 | PA3350 | Personál.kmen.záznam Infotyp 3350 | 31 | ANLNR | Car Asset Number | nvarchar | 20 | 0 | | |
| TOPEquipment |
| 6 | IEQT_WL_ITEMS | Interim Statuses - Items | 91 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| 7 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 92 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| TOPFunctional Locations |
| 8 | ILOA | PM Object Location and Account Assignment | 29 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| 9 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 30 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| TOPMaster Data Distribution |
| 10 | /ISDFPS/EQUI_CO | Distribution of Equipment: Save CO Data of Central System | 5 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
| TOPPersonnel Administration |
| 11 | PA0032 | HR Master Record: Infotype 0032 (Internal Data) | 30 | ANLNR | Car Asset Number | nvarchar | 20 | 0 | | |
| TOPPublic Sector |
| 12 | T5D95 | Foreign Service Bonus | 6 | ANLNR | Number of Appendix to Sect. 55 BBesG for Foreign Serv. Bonus | nvarchar | 1 | 0 | | |
| TOPReporting |
| 13 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 40 | ANLNR | Main Asset Number | nvarchar | 12 | 0 | | |
