| 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 | 394 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 203 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
3 | FIEUD_MMINV_I | SAFT:MM: Item Details for XML Purchase Invoice | 36 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
4 | ZEIM_LIPS | SD document: Delivery: Item data | 231 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPBalance Sheet Valuation Procedures |
5 | MYMP1R | Storage for Invoice Differences (LIFO/FIFO) | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPBatches |
6 | WBEW | Active Ingredient Valuation | 30 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
7 | MMARC | Plant Data for Material | 198 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
8 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 60 | LFGJA | Material Document Year | nvarchar | 4 | 0 | | |
TOPFunds Management-Specific Postings |
9 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 59 | LFGJA | Material Document Year | nvarchar | 4 | 0 | | |
10 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 58 | LFGJA | Material Document Year | nvarchar | 4 | 0 | | |
TOPHydrocarbon Product Management |
11 | MARCHO1 | MARCH: Additional quantities appendix | 4 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
12 | MARDHO1 | MARDH: Aditional quantities appendix | 5 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
13 | MCHBHO1 | MCHBH: Additional quantities appendix | 6 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
14 | MKOLHO1 | MKOLH: Additional quantities appendix | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
15 | MSKAHO1 | MSKAH: Additional quantities appendix | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
16 | MSKUHO1 | MSKUH: Additional quantities appendix | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
17 | MSLBHO1 | MSLB: Additional quantities appendix | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
18 | MSPRHO1 | MSPRH: Additional quantities appendix | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
19 | MSPRO1 | Project Stock additional quantities | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPInventory Management |
20 | MMINKON_UP | Corrections due to Technical Problems with Stock | 18 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
21 | MSTB | Stock in Transit | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
22 | MSTBH | Stock in Transit - History | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
23 | MSTE | Stock in Transit to Sales and Distribution Document | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
24 | MSTEH | SiT to Sales and Distribution Document - History | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
25 | MSTQ | Stock in Transit for Project | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
26 | MSTQH | Stock in Transit for Project - History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
27 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 29 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
28 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 29 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPInvoice Verification |
29 | RBDRSEG | Batch IV: Invoice Document Items | 24 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
30 | RSEG | Document Item: Incoming Invoice | 49 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPLocalization |
31 | IDEU_VAT | EU VAT Posting | 20 | LFGJA | Fiscal Year of a Reference Document | nvarchar | 4 | 0 | | |
TOPMaterial Master |
32 | EBEW | Sales Order Stock Valuation | 32 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
33 | EBEWH | Valuation of Sales Order Stock: History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
34 | MARC | Plant Data for Material | 198 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
35 | MARCH | Material Master C Segment: History | 4 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
36 | MARC_TMP | File for Incorrect Data in Direct Input | 201 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
37 | MARD | Storage Location Data for Material | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
38 | MARDH | Material Master Storage Location Segment: History | 5 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
39 | MARD_TMP | File for Incorrect Data in Direct Input | 10 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
40 | MARV | Material Control Record | 3 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
41 | MARVCD | Change Document: Period Initialization when System in Op. | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
42 | MBEW | Material Valuation | 30 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
43 | MBEWH | Material Valuation: History | 5 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
44 | MBEW_TMP | File for Incorrect Data in Direct Input | 33 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
45 | MCHB | Batch Stocks | 11 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
46 | MCHBH | Batch Stocks: History | 6 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
47 | MKOL | Special Stocks from Vendor | 13 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
48 | MKOLH | Special Stocks from Vendor: History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
49 | MSCA | Sales Orders on Hand with Vendor | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
50 | MSCAH | Sales Order Stock at Vendor: History | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
51 | MSKA | Sales Order Stock | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
52 | MSKAH | Sales Order Stock: History | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
53 | MSKU | Special Stocks with Customer | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
54 | MSKUH | Special Stocks at Customer: History | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
55 | MSLB | Special Stocks with Vendor | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
56 | MSLBH | Special Stocks at Vendor: History | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
57 | MSOA | Total Sales Orders on Hand with Vendor | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
58 | MSPR | Project Stock | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
59 | MSPRH | Project Stock: History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
60 | MSSA | Total Customer Orders on Hand | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
61 | MSSAH | Total Sales Order Stocks: History | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
62 | MSSL | Total Special Stocks with Vendor | 6 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
63 | MSSQ | Project Stock Total | 6 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
64 | MSSQH | Total Project Stocks: History | 6 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
65 | MVEW | Material Valuation | 30 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
66 | MVEWH | Material Valuation: History | 5 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
67 | MVRC | Cross-version fields for MARC | 198 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
68 | MVRD | Storage Location Data for Material | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
69 | OBEW | Valuated Stock with Subcontractor | 31 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
70 | OBEWH | Valuated Stock with Subcontractor: History | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
71 | QBEW | Project Stock Valuation | 31 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
72 | QBEWH | Valuation of Project Stock: History | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPPurchasing |
73 | EKBE | History per Purchasing Document | 24 | LFGJA | Fiscal Year of a Reference Document | nvarchar | 4 | 0 | | |
74 | EKBEH | Removed PO History Records | 24 | LFGJA | Fiscal Year of a Reference Document | nvarchar | 4 | 0 | | |
75 | EKBEH_MA | Removed PO History Records at Account Assignment Level | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
76 | EKBE_MA | History of Purchasing Document at Account Assignment Level | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
77 | EKBE_SC | Component Consumption History for Subcontracting | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
78 | EKDF | Document Flow for Logistics Differential Invoice | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
79 | EKRS | ERS Procedure: Goods (Merchandise) Movements to be Invoiced | 11 | LFGJA | Fiscal Year of a Reference Document | nvarchar | 4 | 0 | | |
TOPShipping |
80 | LIPS | SD document: Delivery: Item data | 231 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
TOPSpare Part Sharing and Stock Providede by Customer |
81 | MCSD | Customer Stock | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
82 | MCSDH | Customer Stock: History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
83 | MCSS | Total Customer Stock | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
84 | MCSSH | Kundenbeistellbestand - Historie - Summe | 6 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
85 | MSCD | Customer stock with vendor | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
86 | MSCDH | Customer stock with vendor - History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
87 | MSCS | Customer stock with vendor - Total | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
88 | MSFD | Sales Order Stock with Vendor | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
89 | MSFDH | Sales Order Stock at Vendor: History | 9 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
90 | MSFS | Sales Order Stock with Vendor - Total | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
91 | MSID | Vendor Stock with Vendor | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
92 | MSIDH | Vendor Stock with Vendor - History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
93 | MSIS | Vendor Stock with Vendor - Total | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
94 | MSRD | Project Stock with Vendor | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
95 | MSRDH | Project Stock with Vendor - History | 8 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |
96 | MSRS | Project Stock with Vendor - Total | 7 | LFGJA | Fiscal Year of Current Period | nvarchar | 4 | 0 | | |