| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_PM006 | Data staging - Equip List Set - Classifications - Cmplx Tab | 10 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 2 | /SMERP/STG_PM007 | Data staging - Equip List Set - Char Values - complex table | 12 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 3 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 10 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 4 | /SMERP/STG_PM012 | Data staging - Func Loc LSet - Char Values - complex table | 12 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 5 | AUSP_CONV | Characteristic Values | 5 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 6 | KSSK_CONV | Allocation Table: Object to Class | 3 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| TOPClasses |
| 7 | AUSP | Characteristic Values | 5 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 8 | KSSK | Allocation Table: Object to Class | 3 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| 9 | TCOBJ | Help table for optimization reports (INTERNAL USE ONLY!) | 3 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| TOPConfiguration management |
| 10 | CMTIB_CLFINT2EXT | Classification conversion: internal ID to external key | 3 | MAFID | Record type | nvarchar | 1 | 0 | | |
| TOPEnvironment |
| 11 | LKSSK | Allocation Table: Object to Class | 3 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| TOPMaster Data |
| 12 | DBVL | Planning File Entry, MRP Area, Long-Term Planning | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 13 | DBVM | Planning File Entry, MRP Area | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 14 | KBVL | Individual Customer Plng File Entry, MRP Area Long-Term Plng | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 15 | KBVM | Individual Customer Planning File Entry, MRP Area | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 16 | KDVL | Individual Customer Planning File Entry, Long-Term Planning | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 17 | KDVM | Individual Customer Planning File Entry | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 18 | MDVL | Planning file entry for long-term planning | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| 19 | MDVM | Entry in MRP File | 2 | MAFID | Record type | nvarchar | 1 | 0 | | |
| TOPProduct Safety |
| 20 | ESTAUSP | EHS: Shadow table for AUSP | 5 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| TOPTechnical Objects |
| 21 | EAML_D_AUSP_LFE | Linear Data for Characteristics - Database table | 5 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
| TOPVariant Configuration |
| 22 | CLRK | Recursiveness Info on Objects in Classes for BOM | 2 | MAFID | Indicator: Object/Class | nvarchar | 1 | 0 | | |
