| 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 | 393 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 204 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
TOPBatches |
3 | WBEW | Active Ingredient Valuation | 31 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
4 | MMARC | Plant Data for Material | 197 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
TOPHydrocarbon Product Management |
5 | MARCHO1 | MARCH: Additional quantities appendix | 5 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
6 | MARDHO1 | MARDH: Aditional quantities appendix | 6 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
7 | MCHBHO1 | MCHBH: Additional quantities appendix | 7 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
8 | MKOLHO1 | MKOLH: Additional quantities appendix | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
9 | MSKAHO1 | MSKAH: Additional quantities appendix | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
10 | MSKUHO1 | MSKUH: Additional quantities appendix | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
11 | MSLBHO1 | MSLB: Additional quantities appendix | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
12 | MSPRHO1 | MSPRH: Additional quantities appendix | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
13 | MSPRO1 | Project Stock additional quantities | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
TOPInventory Management |
14 | MMINKON_UP | Corrections due to Technical Problems with Stock | 19 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
15 | MSTB | Stock in Transit | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
16 | MSTBH | Stock in Transit - History | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
17 | MSTE | Stock in Transit to Sales and Distribution Document | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
18 | MSTEH | SiT to Sales and Distribution Document - History | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
19 | MSTQ | Stock in Transit for Project | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
20 | MSTQH | Stock in Transit for Project - History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
21 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 30 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
22 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 30 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
TOPMaterial Master |
23 | EBEW | Sales Order Stock Valuation | 33 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
24 | EBEWH | Valuation of Sales Order Stock: History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
25 | MARC | Plant Data for Material | 197 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
26 | MARCH | Material Master C Segment: History | 5 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
27 | MARC_TMP | File for Incorrect Data in Direct Input | 200 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
28 | MARD | Storage Location Data for Material | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
29 | MARDH | Material Master Storage Location Segment: History | 6 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
30 | MARD_TMP | File for Incorrect Data in Direct Input | 11 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
31 | MARV | Material Control Record | 4 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
32 | MARVCD | Change Document: Period Initialization when System in Op. | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
33 | MBEW | Material Valuation | 31 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
34 | MBEWH | Material Valuation: History | 6 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
35 | MBEW_TMP | File for Incorrect Data in Direct Input | 34 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
36 | MCHB | Batch Stocks | 12 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
37 | MCHBH | Batch Stocks: History | 7 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
38 | MKOL | Special Stocks from Vendor | 14 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
39 | MKOLH | Special Stocks from Vendor: History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
40 | MSCA | Sales Orders on Hand with Vendor | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
41 | MSCAH | Sales Order Stock at Vendor: History | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
42 | MSKA | Sales Order Stock | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
43 | MSKAH | Sales Order Stock: History | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
44 | MSKU | Special Stocks with Customer | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
45 | MSKUH | Special Stocks at Customer: History | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
46 | MSLB | Special Stocks with Vendor | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
47 | MSLBH | Special Stocks at Vendor: History | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
48 | MSOA | Total Sales Orders on Hand with Vendor | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
49 | MSPR | Project Stock | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
50 | MSPRH | Project Stock: History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
51 | MSSA | Total Customer Orders on Hand | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
52 | MSSAH | Total Sales Order Stocks: History | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
53 | MSSL | Total Special Stocks with Vendor | 7 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
54 | MSSQ | Project Stock Total | 7 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
55 | MSSQH | Total Project Stocks: History | 7 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
56 | MVEW | Material Valuation | 31 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
57 | MVEWH | Material Valuation: History | 6 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
58 | MVRC | Cross-version fields for MARC | 197 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
59 | MVRD | Storage Location Data for Material | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
60 | OBEW | Valuated Stock with Subcontractor | 32 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
61 | OBEWH | Valuated Stock with Subcontractor: History | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
62 | QBEW | Project Stock Valuation | 32 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
63 | QBEWH | Valuation of Project Stock: History | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
TOPSpare Part Sharing and Stock Providede by Customer |
64 | MCSD | Customer Stock | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
65 | MCSDH | Customer Stock: History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
66 | MCSS | Total Customer Stock | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
67 | MCSSH | Kundenbeistellbestand - Historie - Summe | 7 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
68 | MSCD | Customer stock with vendor | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
69 | MSCDH | Customer stock with vendor - History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
70 | MSCS | Customer stock with vendor - Total | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
71 | MSFD | Sales Order Stock with Vendor | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
72 | MSFDH | Sales Order Stock at Vendor: History | 10 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
73 | MSFS | Sales Order Stock with Vendor - Total | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
74 | MSID | Vendor Stock with Vendor | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
75 | MSIDH | Vendor Stock with Vendor - History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
76 | MSIS | Vendor Stock with Vendor - Total | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
77 | MSRD | Project Stock with Vendor | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
78 | MSRDH | Project Stock with Vendor - History | 9 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |
79 | MSRS | Project Stock with Vendor - Total | 8 | LFMON | Current period (posting period) | nvarchar | 2 | 0 | | |