| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 10 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 10 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
3 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
4 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
5 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 16 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
6 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
7 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
8 | FIEUD_MMINV_I | SAFT:MM: Item Details for XML Purchase Invoice | 17 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
9 | MLAUFH | History table for summarized MLAUF data | 27 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
10 | S955E | S955 - Strukturinformationen | 19 | BSTME | Bestellmengeneinheit | nvarchar | 3 | 0 | | |
11 | YVIM_1ITEM | Document Item | 10 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
12 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPActual CostingMaterial Ledger |
13 | MLAUF | Material Ledger Item Table for Order History | 26 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPAllocation |
14 | AUBSI | Worklist for PO (Follow-on Document Generation) | 22 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
15 | AUFI | Allocation Table, Document Sub-item, Stores | 45 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
16 | AULW | Delivery Phases | 23 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
17 | AUVW | Delivery Phase for Distribution Center | 19 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
18 | AUVZ | Distribution Center | 20 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
19 | AUWEI | Index, Adjust Alloc Tbl After Entering Doc. | 12 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPConditions |
20 | A066 | Info record per order unit | 8 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
21 | A067 | Plant Info Record per Order Unit | 9 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
22 | KOTN001 | Info Record: Plant-Specific per Order Unit | 9 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
23 | KOTN002 | Info record per order unit | 8 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
24 | MMARA | General material data | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPData Collection |
25 | S270 | Do not use! | 17 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
26 | S270BIW1 | Do not use! | 17 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
27 | S270BIW2 | Do not use! | 17 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
28 | S270E | S270 - Structural Information | 10 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
29 | S275 | Transfer BW: Einkaufsdaten | 16 | BSTME | Bestelhoeveelheidseenheid | nvarchar | 3 | 0 | | |
30 | S275BIW1 | S275BIW1 * Transfer to BW: Purchasing Data | 16 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
31 | S275BIW2 | S275BIW2 * Transfer to BW: Purchasing Data | 16 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
32 | S955 | Istdatenspeicher MAP - BW | 26 | BSTME | Bestellmengeneinheit | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
33 | /OPT/VIM_1ITEM | Document Item | 10 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPInventory Management |
34 | MSEG | Document Segment: Material | 122 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
35 | MWXMSEG | ZMSEG: Interface for Posting of Value | 122 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
36 | MWZMSEG | ZMSEG:Interface for Posting of Value | 122 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPInvoice Verification |
37 | RKWA | Consignment Withdrawals | 17 | BSTME | Unit of measure for settlement | nvarchar | 3 | 0 | | |
38 | RSEG | Document Item: Incoming Invoice | 18 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPMaterial Master |
39 | MARA | General Material Data | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
40 | MARA_TMP | File for Incorrect Data in Direct Input | 22 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
41 | MVRA | Cross-version fields for MARA | 15 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPMaterials Management |
42 | /SAPNEA/ROWA | Chargeable component consumptions | 17 | BSTME | Unit of measure for settlement | nvarchar | 3 | 0 | | |
43 | ROWA | Index table : Chargeable component consumptions | 17 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPMerchandise and Assortment Planning |
44 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 26 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPPurchase Orders |
45 | WBO2 | Log item file for simulative list for load building | 31 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPPurchasing |
46 | WRF_POHF_POL | Order list | 16 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPR2-R3 Link |
47 | LDK05 | Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master | 19 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
48 | S468 | IS Beverage EM, Purchasing Information System Empties | 18 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
49 | S468E | S468 - Structure Information | 11 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPShipping |
50 | DVM01 | R/2-R/3 Link: R/3 Input Data for Material Master | 27 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
51 | OIH_MIGO_HTDP | Store the TDP-GOITEM for MIGOs hold/restore feature | 37 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |
TOPVendor Evaluation |
52 | ABS_IV_KEYFI_ITM | Absolute Key Figures at Item Level | 17 | BSTME | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | |