| 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 | 76 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 76 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 77 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 76 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 76 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 78 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPAssortment |
7 | WRFT_APC_GEN | Operational APC: General Customizing | 21 | SAISJ | Season Year for Transfer from LWB to OAPC | nvarchar | 4 | 0 | | |
8 | WRF_APC_IBID | Purchasing List Inbound Interface Detailed Totals | 5 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
9 | WRF_APC_IBIT | Purchasing List Inbound Interface Totals | 5 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
10 | WRF_APC_MPA | Markdown Profile Assignment | 11 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
11 | WRF_APC_PLH | Purchasing List Header Data | 6 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPAssortment Maintenance |
12 | WSOJOBMAP | MAP: Temporary Listing Table from Planning | 7 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
13 | MMARA | General material data | 78 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPData Collection |
14 | S105 | Season: Movements | 14 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
15 | S105E | S105 - Structural Information | 9 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
16 | S106 | Season: Stock | 8 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
17 | S106E | S106 - Structural Information | 9 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
18 | S107 | Season: Movements + Stock | 14 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
19 | S107E | S107 - Structural Information | 9 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
20 | S117 | Receipt/article | 26 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
21 | S953 | BW Vorl.für BON/Artikel S117 | 26 | SAISJ | Saisonjahr | nvarchar | 4 | 0 | | |
TOPInventory Management |
22 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 145 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
23 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 145 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPMaterial Master |
24 | MARA | General Material Data | 78 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
25 | MARA_TMP | File for Incorrect Data in Direct Input | 85 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
26 | MVRA | Cross-version fields for MARA | 78 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
27 | WRF_DISCONT_POS | Worklist Items: Discontinuation for Seasonal Procurement | 18 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
28 | WSTN_AL_LINK | Relation between alloc table created and generic article | 3 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
29 | WSTN_CTL_POST | Prepack creation and allocation - posting control | 3 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPMerchandise and Assortment Planning |
30 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 11 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
31 | TWISPC_SAISO | Retail Planning: Assign. Posting Periods to Season Cat./Year | 3 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPPrice Planning Workbench |
32 | WRF_PPW_PPDART | PPD Material Item | 18 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPPromotion |
33 | WAKR | Promotion Discounts | 19 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
34 | WMFP | Markdown Planning - item data (materials) | 15 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
35 | WSAH | Worklist Season wind-up - header | 3 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
TOPPurchasing |
36 | EKPO | Purchasing Document Item | 139 | SAISJ | Season Year | nvarchar | 4 | 0 | | |
37 | WRF_POHF_POL | Order list | 31 | SAISJ | Season Year | nvarchar | 4 | 0 | | |