| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 411 | /MRSS/PROF_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| TOPCapacity and Resource Planning |
| 2 | /MRSS/D_RM_ROLE | Role Details | 5 | /MRSS/PROF_GUID | Profile Guid | nvarchar | 32 | 0 | | |
| TOPConstruction Equipment Management |
| 3 | J_3GBELK | Document File - Header Data | 108 | /MRSS/PROF_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
| 4 | J_3GBELP | Document Data - Item Data | 141 | /MRSS/PROF_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
| TOPCross-Application Components |
| 5 | MMARC | Plant Data for Material | 215 | /MRSS/PROF_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| TOPEquipment |
| 6 | EQUI | Equipment master data | 84 | /MRSS/PROF_GUID | GUID | varbinary | 16 | 0 | | |
| TOPMaterial Master |
| 7 | MARC | Plant Data for Material | 215 | /MRSS/PROF_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 8 | MARC_TMP | File for Incorrect Data in Direct Input | 218 | /MRSS/PROF_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| 9 | MVRC | Cross-version fields for MARC | 215 | /MRSS/PROF_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| TOPProduction Orders |
| 10 | AFVU | DB structure of the user fields of the operation | 34 | /MRSS/PROF_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
| TOPSimulation |
| 11 | VSAFVU_CN | Version: User fields in operation in order | 35 | /MRSS/PROF_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
