| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 214 | VLWRK | Original plant (deactivated) | nvarchar | 4 | 0 | ||
| Material Master | ||||||||||
| 2 | MCH1 | Batches (if Batch Management Cross-Plant) | 17 | VLWRK | Original plant (deactivated) | nvarchar | 4 | 0 | ||
| 3 | MCHA | Batches | 18 | VLWRK | Original plant (deactivated) | nvarchar | 4 | 0 | ||
| Materials Management | ||||||||||
| 4 | J_1GVL_ML | Material Ledger | 13 | VLWRK | Plant (empty if valuation at Company Level) | nvarchar | 4 | 0 | ||