| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1ISRWP/800H0101 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
2 | /1ISRWP/800H0102 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
3 | /1ISRWP/800H0103 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
4 | /1ISRWP/800H0104 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
5 | /1ISRWP/800H0105 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
6 | /1ISRWP/800H0106 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
7 | /1ISRWP/800H0107 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
8 | /1ISRWP/800H0108 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
9 | /1ISRWP/800H0109 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
10 | /1ISRWP/800H0110 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
11 | /1ISRWP/800H0111 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
12 | /1ISRWP/800H0112 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
13 | /1ISRWP/800H0113 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 2 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
14 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 46 | SAISO | Season Category | nvarchar | 4 | 0 | | |
15 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 46 | SAISO | Season Category | nvarchar | 4 | 0 | | |
16 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 47 | SAISO | Season Category | nvarchar | 4 | 0 | | |
17 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 46 | SAISO | Season Category | nvarchar | 4 | 0 | | |
18 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 46 | SAISO | Season Category | nvarchar | 4 | 0 | | |
19 | S952E | S952 - Structural information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
20 | S957E | S957 - Structural information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
21 | S958E | S958 - Structural information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
22 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 47 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPAssortment |
23 | WRFT_APC_GEN | Operational APC: General Customizing | 20 | SAISO | Default Season Category for Transfer from LWB to OAPC | nvarchar | 4 | 0 | | |
24 | WRF_APC_IBID | Purchasing List Inbound Interface Detailed Totals | 4 | SAISO | Season Category | nvarchar | 4 | 0 | | |
25 | WRF_APC_IBIT | Purchasing List Inbound Interface Totals | 4 | SAISO | Season Category | nvarchar | 4 | 0 | | |
26 | WRF_APC_MPA | Markdown Profile Assignment | 10 | SAISO | Season Category | nvarchar | 4 | 0 | | |
27 | WRF_APC_PLH | Purchasing List Header Data | 5 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPAssortment Maintenance |
28 | T6WSP | Check Table for Season Indicator | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
29 | T6WST | Texts to describe season indicators | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
30 | TWSAI | (Annual) Seasons | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
31 | TWSAJ | Annual seasons (distribution chain-specific) | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
32 | WSOJOBMAP | MAP: Temporary Listing Table from Planning | 6 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
33 | MMARA | General material data | 47 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPData Collection |
34 | S083 | Material: Movements | 14 | SAISO | Season Category | nvarchar | 4 | 0 | | |
35 | S083E | S083 - Structural Information | 9 | SAISO | Season Category | nvarchar | 4 | 0 | | |
36 | S084 | Material: Stock | 8 | SAISO | Season Category | nvarchar | 4 | 0 | | |
37 | S084E | S084 - Structural Information | 9 | SAISO | Season Category | nvarchar | 4 | 0 | | |
38 | S085 | Material: Movements + Stock | 14 | SAISO | Season Category | nvarchar | 4 | 0 | | |
39 | S085E | S085 - Structural Information | 9 | SAISO | Season Category | nvarchar | 4 | 0 | | |
40 | S105 | Season: Movements | 15 | SAISO | Season Category | nvarchar | 4 | 0 | | |
41 | S105E | S105 - Structural Information | 10 | SAISO | Season Category | nvarchar | 4 | 0 | | |
42 | S106 | Season: Stock | 9 | SAISO | Season Category | nvarchar | 4 | 0 | | |
43 | S106E | S106 - Structural Information | 10 | SAISO | Season Category | nvarchar | 4 | 0 | | |
44 | S107 | Season: Movements + Stock | 15 | SAISO | Season Category | nvarchar | 4 | 0 | | |
45 | S107E | S107 - Structural Information | 10 | SAISO | Season Category | nvarchar | 4 | 0 | | |
46 | S110 | OTB | 8 | SAISO | Season Category | nvarchar | 4 | 0 | | |
47 | S110E | S110 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
48 | S117 | Receipt/article | 25 | SAISO | Season Category | nvarchar | 4 | 0 | | |
49 | S124 | Customer / material | 13 | SAISO | Season Category | nvarchar | 4 | 0 | | |
50 | S124E | S124 - Structural Information | 8 | SAISO | Season Category | nvarchar | 4 | 0 | | |
51 | S952 | Reference Structure for Generating Info Structures | 8 | SAISO | Season Category | nvarchar | 4 | 0 | | |
52 | S953 | BW Vorl.für BON/Artikel S117 | 25 | SAISO | Saisontyp | nvarchar | 4 | 0 | | |
53 | S957 | Reference Structure for Generating Info Structures | 8 | SAISO | Season Category | nvarchar | 4 | 0 | | |
54 | S958 | Reference Structure for Generating Info Structures | 8 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPInventory Management |
55 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 130 | SAISO | Season Category | nvarchar | 4 | 0 | | |
56 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 130 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPMaterial Master |
57 | MARA | General Material Data | 47 | SAISO | Season Category | nvarchar | 4 | 0 | | |
58 | MARA_TMP | File for Incorrect Data in Direct Input | 54 | SAISO | Season Category | nvarchar | 4 | 0 | | |
59 | MVRA | Cross-version fields for MARA | 47 | SAISO | Season Category | nvarchar | 4 | 0 | | |
60 | WRF_DISCONT_POS | Worklist Items: Discontinuation for Seasonal Procurement | 17 | SAISO | Season Category | nvarchar | 4 | 0 | | |
61 | WSTN_AL_LINK | Relation between alloc table created and generic article | 4 | SAISO | Season Category | nvarchar | 4 | 0 | | |
62 | WSTN_CTL_POST | Prepack creation and allocation - posting control | 4 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPMerchandise and Assortment Planning |
63 | S202 | MAP: Merchandise Planning Structure | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
64 | S202E | S202 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
65 | S203 | MAP: Merchandise Planning Stock | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
66 | S203E | S203 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
67 | S204 | MAP: Merchandise Planning Movements | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
68 | S204E | S204 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
69 | S206 | MAP: Store Planning Stocks | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
70 | S206E | S206 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
71 | S207 | MAP: Store Planning Structure | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
72 | S207E | S207 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
73 | S208 | MAP: Assortment Planning | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
74 | S208E | S208 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
75 | S209 | MAP: OTB Movements | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
76 | S209E | S209 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
77 | S210 | MAP: OTB Stock | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
78 | S210E | S210 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
79 | S211 | MAP: OTB Evaluation Structure | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
80 | S211E | S211 - Structural Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
81 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 10 | SAISO | Season Category | nvarchar | 4 | 0 | | |
82 | TWISPC_SAISO | Retail Planning: Assign. Posting Periods to Season Cat./Year | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPPrice Planning Workbench |
83 | WRF_PPW_PPDART | PPD Material Item | 17 | SAISO | Season | nvarchar | 6 | 0 | | |
TOPPromotion |
84 | WAKR | Promotion Discounts | 18 | SAISO | Season Category | nvarchar | 4 | 0 | | |
85 | WMFP | Markdown Planning - item data (materials) | 14 | SAISO | Season Category | nvarchar | 4 | 0 | | |
86 | WSAH | Worklist Season wind-up - header | 2 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPPurchasing |
87 | EKPO | Purchasing Document Item | 138 | SAISO | Season Category | nvarchar | 4 | 0 | | |
88 | WRF_POHF_POL | Order list | 30 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPReporting |
89 | S205 | MAP: Store Planning Movements | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
90 | S205E | S205 - Structure Information | 3 | SAISO | Season Category | nvarchar | 4 | 0 | | |
TOPSales Plan |
91 | T445Q | Prices for Price Band Categories | 5 | SAISO | Season Category | nvarchar | 4 | 0 | | |
92 | T445QK | Prices for Price Band Categories (Key) | 5 | SAISO | Season Category | nvarchar | 4 | 0 | | |