| 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 | 324 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| TOPCross-Application Components |
| 2 | FRE_DB_PROCYC | Procurement cycle | 2 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 3 | MMARC | Plant Data for Material | 128 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| TOPMaster Data |
| 4 | MDKP | Header Data for MRP Document | 65 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 5 | MDKPDB | Header Data for MRP Document | 66 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 6 | MDMA | MRP Area for Material | 10 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| TOPMaterial Master |
| 7 | MARC | Plant Data for Material | 128 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 8 | MARC_TMP | File for Incorrect Data in Direct Input | 131 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 9 | MDIP | Material: MRP Profiles (Field Contents) | 47 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 10 | MVRC | Cross-version fields for MARC | 128 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| TOPMaterial Requirements Planning |
| 11 | CIFMDMAVR | Versions of Table MDMA | 11 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| TOPSAP Retail Store |
| 12 | WSAO_WORK_CTRL | Retail Store Store Order: Worklist Control | 29 | LFRHY | PPC planning calendar | nvarchar | 3 | 0 | | |
| TOPVendor Master |
| 13 | LFM1 | Vendor master record purchasing organization data | 27 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 14 | LFM2 | Vendor Master Record: Purchasing Data | 29 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
| 15 | WYT5 | Changes to Vendor Master Record | 16 | LFRHY | Planning cycle | nvarchar | 3 | 0 | | |
