| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____00BA | SID-Tabelle fuer Ext. Material Group | 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 79 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 79 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 80 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
5 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 79 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
6 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 79 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
7 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 81 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPCommand and Support Relationships |
8 | /ISDFPS/FORSUP | Attributes of Supply Relationships | 24 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
9 | /ISDFPS/ORSUP1 | Supply Relationships, Basic Types, Dependent Attributes | 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPConsumption-Based Planning See Also PP-MRP |
10 | MDRD_EXTWG | Delivery Relationships: Recipients per Plant and Material | 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
11 | WDRD_EXTWG | Delivery Relationships: Recipients per Plant and Material | 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
12 | MMARA | General material data | 81 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPLogistical Requirements |
13 | /ISDFPS/PNEPA | Application-Specific Attributes of Equipment Package | 12 | EXTWG | SysLog: unused area | nvarchar | 18 | 0 | | |
14 | /ISDFPS/PNMPA | Application-Specific MPA Attributes | 7 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPMaterial Master |
15 | MARA | General Material Data | 81 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
16 | MARA_TMP | File for Incorrect Data in Direct Input | 88 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
17 | MVRA | Cross-version fields for MARA | 81 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
18 | TWEW | External Material Groups | 2 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
19 | TWEWT | Descriptions for External Material Groups | 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPMaterials Management |
20 | /ISDFPS/CMATP_DQ | Adjust Requested Quantity for New PReqs | 3 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
21 | /ISDFPS/PRPLCNTL | Subsequent Processing for Prioritized Materials Planning | 5 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |
TOPPersonnel Categories |
22 | /ISDFPS/C_PE_MCC | Advice Code for Material Group | 2 | EXTWG | External Material Group | nvarchar | 18 | 0 | | |