| 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 | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 26 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
6 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 19 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
7 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 47 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
8 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 19 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
9 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 47 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
10 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
TOPCross-Application Components |
11 | MMARA | General material data | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
TOPEquipment |
12 | EQUI | Equipment master data | 13 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
TOPFunctional Locations |
13 | IFLOT | Functional Location (Table) | 41 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
14 | IFLOT_VS | Functional Location (Version Table) | 42 | GROES | Size/dimension | nvarchar | 18 | 0 | | |
TOPLogistics - General |
15 | WBHI | Trading Contract: Item Data | 16 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
TOPMaterial Master |
16 | MARA | General Material Data | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
17 | MARA_TMP | File for Incorrect Data in Direct Input | 32 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |
18 | MVRA | Cross-version fields for MARA | 25 | GROES | Size/dimensions | nvarchar | 32 | 0 | | |