| 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 | 80 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 80 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 81 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 80 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 80 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
6 | FSH_SEASONS_MAT | Table for Seasons In Material | 13 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
7 | SGT_MARM | Segmentation | Weights and Volumes | 5 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
8 | SGT_MVKE | Segmentation | Sales Status | 8 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
9 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 82 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPAssortment Maintenance |
10 | WSOP | Modules SAP Retail / Item Data | 12 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
11 | FRE_MD_PRODUCT | Objects sent to F&R as Product | 6 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
12 | MMARA | General material data | 82 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPData Collection |
13 | S105 | Season: Movements | 12 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
14 | S105E | S105 - Structural Information | 7 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
15 | S106 | Season: Stock | 6 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
16 | S106E | S106 - Structural Information | 7 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
17 | S107 | Season: Movements + Stock | 12 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
18 | S107E | S107 - Structural Information | 7 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
19 | S108 | Additionals | 9 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
20 | S108E | S108 - Structural Information | 8 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
21 | S117 | Receipt/article | 27 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
22 | S160 | Perishables | 13 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
23 | S160E | S160 - Structural Information | 8 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
24 | S200 | Inventory Controlling Stores | 39 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
25 | S953 | BW Vorl.für BON/Artikel S117 | 27 | SATNR | Werksübergreifendes konfigurierbares Material | nvarchar | 18 | 0 | | |
TOPDefense Forces and Public Security |
26 | /ISDFPS/ZEBAN | Copy of EBAN | 89 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPElectronic Data Interchange |
27 | PRICAT_K003 | PRICAT: Catalog item basic data | 69 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPInventory Management |
28 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 126 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
29 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 126 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPInvoice Verification |
30 | RBDRSEG | Batch IV: Invoice Document Items | 79 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
31 | RBVDMAT | Invoice Verification - Aggregation Data, Material | 11 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPMaterial Master |
32 | MARA | General Material Data | 82 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
33 | MARA_TMP | File for Incorrect Data in Direct Input | 89 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
34 | MVRA | Cross-version fields for MARA | 82 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
35 | WRF_DISCONT_POS | Worklist Items: Discontinuation for Seasonal Procurement | 16 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPMaterials Management |
36 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 94 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPMerchandise and Assortment Planning |
37 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 19 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPPrice Planning Workbench |
38 | WRF_PPW_PPDART | PPD Material Item | 14 | SATNR | Material Number of the Generic Material | nvarchar | 18 | 0 | | |
TOPPromotion |
39 | WAKP | Promotion Item Data | 6 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
40 | WMFP | Markdown Planning - item data (materials) | 11 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPPurchasing |
41 | EBAN | Purchase Requisition | 89 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
42 | EKPO | Purchasing Document Item | 121 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
43 | MEREQX | Purchase Requisition Change Parameter | 89 | SATNR | Updated information in related user data field | nvarchar | 1 | 0 | | |
44 | WDFR1 | Requirements Planning for Perishables | 21 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
45 | WRF_POHF_POL | Order list | 27 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |
TOPSimulation |
46 | VSEBAN_CN | Version: Purchase requisition | 89 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | |