| 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 | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 41 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
7 | ZSMAT | Materialschlüssel der Fluggesellschaften | 7 | STOFF | Gefahrstoffnummer | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
8 | MMARA | General material data | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
TOPMaterial Master |
9 | MARA | General Material Data | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
10 | MARA_TMP | File for Incorrect Data in Direct Input | 47 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
11 | MVRA | Cross-version fields for MARA | 40 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
TOPRecycling Administration Core Functions |
12 | J_7LC69 | REA Customizing: RePartner-Dep. Consistency Check Items | 15 | STOFF | Internal Fraction | nvarchar | 6 | 0 | | |
13 | J_7LE04 | REA Partner Master Record: Volume/Area Classes | 20 | STOFF | Partner Fraction | nvarchar | 6 | 0 | | |
14 | J_7LE05 | REA Partner Master Record: Packaging Types | 13 | STOFF | Partner Fraction | nvarchar | 6 | 0 | | |
15 | J_7LS01T | REA Internal Fractions: Short Text | 2 | STOFF | Internal Fraction | nvarchar | 6 | 0 | | |
16 | J_7LS02 | REA Fractions: Partner Fractions | 2 | STOFF | Partner Fraction | nvarchar | 6 | 0 | | |
17 | J_7LS02T | REA Partner Fractions: Short Text | 2 | STOFF | Partner Fraction | nvarchar | 6 | 0 | | |
18 | J_7LV02 | REA Packaging Master Data: Fraction Assignment (Weight) | 4 | STOFF | Internal Fraction | nvarchar | 6 | 0 | | |
19 | J_7LV08 | REA Packag. Mast. Data: Re.Partner-Dep. Data Asgmt Fraction | 4 | STOFF | Internal Fraction | nvarchar | 6 | 0 | | |
TOPWarehouse Management |
20 | LTAP | Transfer order item | 13 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |
21 | MGEF | Hazardous materials | 2 | STOFF | Hazardous material number | nvarchar | 18 | 0 | | |