| 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 | | |