| 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 | 399 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | | |
TOPBasic Data |
2 | MKAL | Production Versions of Material | 41 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | | |
TOPBatches |
3 | PROOB | Original Batch for Production Order | 6 | UCMAT | Material from Original Batch | nvarchar | 18 | 0 | | |
4 | PUROB | Original Batch for Purchase Order | 6 | UCMAT | Material from Original Batch | nvarchar | 18 | 0 | | |
TOPConfirmations |
5 | AFRU | Order Confirmations | 142 | UCMAT | Mill: Material in Process Batch | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
6 | MMARC | Plant Data for Material | 203 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | | |
TOPMaterial Master |
7 | MARC | Plant Data for Material | 203 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | | |
8 | MARC_TMP | File for Incorrect Data in Direct Input | 206 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | | |
9 | MVRC | Cross-version fields for MARC | 203 | UCMAT | Reference Material for Original Batches | nvarchar | 18 | 0 | | |
TOPProduction Planning and Control PP enhancements |
10 | MILL_UT | Mill: Relation Item / Process Batch for Partitioning Order | 6 | UCMAT | Mill: Material in Process Batch | nvarchar | 18 | 0 | | |