| 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 | 176 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 176 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 177 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 176 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 176 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 207 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
7 | MMARA | General material data | 207 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
8 | PICMAP | Mapping Table for Interchangeable Materials as in PICHD | 2 | PICNUM | Parts Interchangeability Group Number | nvarchar | 18 | 0 | | |
TOPManufacturer Part Number |
9 | ADPIC_HOLD_MPN | Store MPN subitems for MIGO hold / restore functionality | 19 | PICNUM | Parts Interchangeability Group Number | nvarchar | 18 | 0 | | |
TOPMaterial Master |
10 | MARA | General Material Data | 207 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
11 | MARA_TMP | File for Incorrect Data in Direct Input | 214 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
12 | MVRA | Cross-version fields for MARA | 207 | PICNUM | Supersession chain number | nvarchar | 18 | 0 | | |
TOPSCM Basis |
13 | CIF_IMFFF | IM Reference Table for FFF Classes | 2 | PICNUM | Parts Interchangeability Group Number | nvarchar | 18 | 0 | | |
14 | CIF_IMSUS | IMod Reference Table for Supersession | 2 | PICNUM | Parts Interchangeability Group Number | nvarchar | 18 | 0 | | |
TOPSupersession Chains |
15 | PICHD | Parts Interchangeability Header Data (Sus+MPN) | 4 | PICNUM | Parts Interchangeability Group Number | nvarchar | 18 | 0 | | |