| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHTMXK | IS-M: Media-Mix Contract Header Data | 12 | UMSATZ | IS-M/AM: Target Quantity for Monetary Contract | decimal | 15 | 2 | | |
| 2 | JJTMXB | IS-M: Media-Mix Package Element | 17 | UMSATZ | IS-M/AM: Target Quantity for Monetary Contract | decimal | 15 | 2 | | |
| 3 | JJTMXK | IS-M: Media-Mix Package Header | 16 | UMSATZ | IS-M/AM: Target Quantity for Monetary Contract | decimal | 15 | 2 | | |
| 4 | TJJV4_ABSTYP | External Key Table for Contract Category in Creation Type | 3 | UMSATZ | IS-M: Overall Target Agreement for Sales Volume Indicator | nvarchar | 1 | 0 | | |
| 5 | TJJV6 | IS-M: Fulfillment Rules for Media-Mix Contracts | 7 | UMSATZ | IS-M: Overall Target Agreement for Sales Volume Indicator | nvarchar | 1 | 0 | | |
| TOPData Collection |
| 6 | S117 | Receipt/article | 38 | UMSATZ | Sales POS | decimal | 19 | 2 | | |
| 7 | S119 | Transaction Number (Till Receipt) | 25 | UMSATZ | Sales POS | decimal | 19 | 2 | | |
| 8 | S953 | BW Vorl.für BON/Artikel S117 | 38 | UMSATZ | Umsatz POS | decimal | 19 | 2 | | |
| 9 | S954 | BW Vorl.für BON S119 | 25 | UMSATZ | Umsatz POS | decimal | 19 | 2 | | |
