| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1ISRWP/800H0110 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 9 | PLGTP | Preislagentyp | nvarchar | 2 | 0 | | |
2 | /1ISRWP/800H0111 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 9 | PLGTP | Preislagentyp | nvarchar | 2 | 0 | | |
3 | /1ISRWP/800H0112 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 9 | PLGTP | Preislagentyp | nvarchar | 2 | 0 | | |
4 | /1ISRWP/800H0113 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 9 | PLGTP | Preislagentyp | nvarchar | 2 | 0 | | |
5 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 77 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
6 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 77 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
7 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 78 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
8 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 77 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
9 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 77 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
10 | S952E | S952 - Structural information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
11 | S958E | S958 - Structural information | 8 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
12 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 79 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPAssortment Maintenance |
13 | TWPT | Price band categories | 2 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
14 | TWPTT | Text: price band category | 3 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
15 | MMARA | General material data | 79 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPData Collection |
16 | S083 | Material: Movements | 15 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
17 | S083E | S083 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
18 | S084 | Material: Stock | 9 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
19 | S084E | S084 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
20 | S085 | Material: Movements + Stock | 15 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
21 | S085E | S085 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
22 | S105 | Season: Movements | 16 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
23 | S105E | S105 - Structural Information | 11 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
24 | S106 | Season: Stock | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
25 | S106E | S106 - Structural Information | 11 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
26 | S107 | Season: Movements + Stock | 16 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
27 | S107E | S107 - Structural Information | 11 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
28 | S110 | OTB | 15 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
29 | S110E | S110 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
30 | S117 | Receipt/article | 24 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
31 | S124 | Customer / material | 14 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
32 | S124E | S124 - Structural Information | 9 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
33 | S952 | Reference Structure for Generating Info Structures | 15 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
34 | S953 | BW Vorl.für BON/Artikel S117 | 24 | PLGTP | Preislagentyp | nvarchar | 2 | 0 | | |
35 | S958 | Reference Structure for Generating Info Structures | 13 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPInventory Management |
36 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 132 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
37 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 132 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPMaterial Master |
38 | MARA | General Material Data | 79 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
39 | MARA_TMP | File for Incorrect Data in Direct Input | 86 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
40 | MVKE | Sales Data for Material | 68 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
41 | MVKE_TMP | File for Incorrect Data in Direct Input | 71 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
42 | MVRA | Cross-version fields for MARA | 79 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
43 | MVVE | Sales Data for Material | 68 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
44 | WRF_PRGRPLEVELS | Price Levels of a Price Pattern | 6 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPMerchandise and Assortment Planning |
45 | S202 | MAP: Merchandise Planning Structure | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
46 | S202E | S202 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
47 | S203 | MAP: Merchandise Planning Stock | 9 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
48 | S203E | S203 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
49 | S204 | MAP: Merchandise Planning Movements | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
50 | S204E | S204 - Structural Information | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
51 | S208 | MAP: Assortment Planning | 8 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
52 | S208E | S208 - Structural Information | 8 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
53 | S216 | MAP: Average Retail WOC | 35 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
54 | S217 | MAP: AvgRetail MON | 35 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
55 | S218 | MAP: AvgRetail BUP | 35 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
56 | TWISPA_AVERAGERT | Merchandise and Assortment Planning: Average Retail | 10 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
57 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 9 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |
TOPSales Plan |
58 | T445Q | Prices for Price Band Categories | 8 | PLGTP | Price Band Category | nvarchar | 2 | 0 | | |