| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 10 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 2 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 10 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| TOPBasic Data |
| 3 | TIVBDPM | PM Integration: Settings per Object Type | 6 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 4 | TIVBDPMAO | PM Integration: Settings for Each Architect. Object Type | 5 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| TOPBasic Functions |
| 5 | ANLZ | Time-Dependent Asset Allocations | 20 | TPLKZ | Unused field length 3 | nvarchar | 3 | 0 | | |
| TOPFunctional Locations |
| 6 | IFLOCUSTA | System-Specific Settings (Permitted Labeling Systems) | 5 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 7 | IFLOS | Functional Location Labels | 7 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 8 | IFLOS_VS | Functional Location Labels (Version Table) | 8 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 9 | IFLOT | Functional Location (Table) | 4 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 10 | IFLOT_VS | Functional Location (Version Table) | 5 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 11 | IFLOUSR | User Profile for Labeling Functional Locations | 7 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 12 | IRLOT | Reference Functional Location (Table) | 4 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 13 | T370S | Functional Location Structure Indicators | 2 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| 14 | T370S_T | Language-Dependent Texts for T370S | 3 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| TOPMaster Data |
| 15 | TE130 | IS-U: Struc. Ind. and Cat. of Functional Loc. | 3 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| TOPPlant Maintenance |
| 16 | TFUNCT_LOC_HIER | Definition of Hierarchies for Functional Locations | 8 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| TOPReporting |
| 17 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 20 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
| TOPTakeoverHandover of Technical Objects |
| 18 | PHINT | Phase In Table | 56 | TPLKZ | Functional location structure indicator | nvarchar | 5 | 0 | | |
