| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCross-Application Components |
| 1 | MATERIALID | Material Identification | 3 | MATNR_EXT | External Long Material Number | nvarchar | 40 | 0 | | |
| 2 | MATERIALID_ARC | Archived Material Identification | 3 | MATNR_EXT | External Long Material Number | nvarchar | 40 | 0 | | |
| TOPMaterial Master |
| 3 | MATERIALIDDI_TMP | File for Incorrect Data in Direct Input | 6 | MATNR_EXT | External Long Material Number | nvarchar | 40 | 0 | | |
| TOPNetWeaver Enterprise Search |
| 4 | ESH_TST_MAT | ES Test Object Material - Main Data | 4 | MATNR_EXT | ES Test Object Material - Material Number | nvarchar | 18 | 0 | | |
