| 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 | 56 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 56 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 57 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 56 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 56 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 57 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPActual CostingMaterial Ledger |
7 | FCML_MAT | ML Characteristics for Material (Selection Criteria) | 28 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPAdvertising Management |
8 | JJTBB | IS-M/AM: Requirement Element of Media Sales Agent Contract | 16 | PRDHA | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
9 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 26 | PRDHA | IS-M/AM: Product Hierarchy | nvarchar | 18 | 0 | | |
TOPBasis Components |
10 | ZMATERIAL_IDES | Material Master(IDES Demo) | 6 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
11 | MMARA | General material data | 57 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPInventory Management |
12 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 125 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
13 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 125 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPMaintenance Notifications |
14 | QMEL | Quality Notification | 27 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPMaterial Master |
15 | MARA | General Material Data | 57 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
16 | MARA_TMP | File for Incorrect Data in Direct Input | 64 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
17 | MVRA | Cross-version fields for MARA | 57 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPMerchandise and Assortment Planning |
18 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 17 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPRecycling Administration Core Functions |
19 | J_7LV1P | REA Document: Item Data | 66 | PRDHA | Product hierarchy | nvarchar | 18 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
20 | NWCHGALDAT | IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat) | 7 | PRDHA | Gerarchia prodotti | nvarchar | 18 | 0 | | |