| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Collection |
1 | S077 | STRPS: Movements | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
2 | S079 | STRPS: Movements + Stock | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
3 | S080 | Purchasing: Movements | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
4 | S082 | Purchasing: Movements + Stock | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
5 | S083 | Material: Movements | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
6 | S085 | Material: Movements + Stock | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
7 | S086 | Promotion | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
8 | S105 | Season: Movements | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
9 | S107 | Season: Movements + Stock | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
10 | S110 | OTB | 75 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
11 | S121 | Material aggregation - POS | 20 | UMSGEO | Sales transactions (till receipts) at cost | decimal | 19 | 2 | | |
12 | S123 | Customer / material group | 57 | UMSGEO | Third-party sales at cost | decimal | 19 | 2 | | |
13 | S124 | Customer / material | 56 | UMSGEO | Third-party sales at cost | decimal | 19 | 2 | | |
14 | S160 | Perishables | 60 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
15 | S685 | MAP IRT350 | 17 | UMSGEO | Umsatz EP | decimal | 19 | 2 | | |
16 | S952 | Reference Structure for Generating Info Structures | 37 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
17 | S955 | Istdatenspeicher MAP - BW | 41 | UMSGEO | Umsatz EP | decimal | 19 | 2 | | |
18 | S957 | Reference Structure for Generating Info Structures | 23 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
TOPMerchandise and Assortment Planning |
19 | S202 | MAP: Merchandise Planning Structure | 37 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
20 | S204 | MAP: Merchandise Planning Movements | 29 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
21 | S207 | MAP: Store Planning Structure | 23 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
22 | S212 | CatMan: Hohe Ebene | 23 | UMSGEO | Omzet inkoopprijs | decimal | 19 | 2 | | |
23 | S212BIW1 | S212BIW1 * CatMan: High Level | 23 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
24 | S212BIW2 | S212BIW2 * CatMan: High Level | 23 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
25 | S214 | CatMan: Indizees für ROP | 21 | UMSGEO | Omzet inkoopprijs | decimal | 19 | 2 | | |
26 | S214BIW1 | S214BIW1 * CatMan: Indexes for Space Management Program | 21 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
27 | S214BIW2 | S214BIW2 * CatMan: Indexes for Space Management Program | 21 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
28 | S216 | MAP: Average Retail WOC | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
29 | S217 | MAP: AvgRetail MON | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
30 | S218 | MAP: AvgRetail BUP | 22 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
31 | S219 | CatMan: Feine Ebene | 24 | UMSGEO | Omzet inkoopprijs | decimal | 19 | 2 | | |
32 | S219BIW1 | S219BIW1 * CatMan: Fine Level | 24 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
33 | S219BIW2 | S219BIW2 * CatMan: Detailed Level | 24 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |
TOPReporting |
34 | S205 | MAP: Store Planning Movements | 23 | UMSGEO | Sales at cost | decimal | 19 | 2 | | |