S086 - Promotion
Promotion information is stored in SAP table S086.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S086
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| AKTNR | Promotion | X | WAKTION | CHAR | 20 | WAKH |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| BTRKZ | Plant category | X | VLFKZ | CHAR | 2 | |
| WGRU2 | Material group hierarchy 2 | X | MCW_WGRU2 | CHAR | 36 | |
| WGRU1 | Material group hierarchy 1 | X | MCW_WGRU1 | CHAR | 36 | |
| MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| AKTYP | Promotion Category | X | W_AKTYP | CHAR | 8 | TWTY |
| AKTHE | Promotion theme | X | W_AKTHE | CHAR | 8 | TWAT |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| HWAER | Local Currency | HWAER | CUKY | 10 | TCURC | |
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 8 | ||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 10 | ||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 10 | ||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 10 | ||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 10 | ||
| WESMNG | Goods receipt (vendor) quantity in BUn | MCW_WESMNG | QUAN | 8 | ||
| WESGEO | Goods receipt (vendor) at cost | MCW_WESGEO | CURR | 10 | ||
| WESGVO | Goods receipt (vendor) at retail | MCW_WESGVO | CURR | 10 | ||
| WESGVP | Goods receipt (vendor) at retail with tax | MCW_WESGVP | CURR | 10 | ||
| WESANZ | Goods receipt (vendor) number of transactions | MCW_WESANZ | INT4 | 4 | ||
| KMEMNG | Goods receipt (distribution center) quantity in BUn | MCW_KMEMNG | QUAN | 8 | ||
| KMEGEO | Goods receipt (DC) at cost | MCW_KMEGEO | CURR | 10 | ||
| KMEGVO | Goods receipt (DC) at retail | MCW_KMEGVO | CURR | 10 | ||
| KMEGVP | Goods receipt (dist. center) at retail with tax | MCW_KMEGVP | CURR | 10 | ||
| KMEANZ | Goods receipt (distribution center), no. of transactions | MCW_KMEANZ | INT4 | 4 | ||
| KMAMNG | Goods issue (distribution center) quantity in BUn | MCW_KMAMNG | QUAN | 8 | ||
| KMAGEO | Goods issue (DC) at cost | MCW_KMAGEO | CURR | 10 | ||
| KMAGVO | Goods issue (DC) at retail | MCW_KMAGVO | CURR | 10 | ||
| KMAGVP | Goods issue (dist. center) at retail with tax | MCW_KMAGVP | CURR | 10 | ||
| KMAANZ | Goods issue (distribution center), no. of transactions | MCW_KMAANZ | INT4 | 4 | ||
| BVLMNG | Order volume quantity Retail | MCW_BVLMNG | QUAN | 8 | ||
| BVLGEO | Order volume at cost | MCW_BVLGEO | CURR | 10 | ||
| BVLGVO | Order volume at retail | MCW_BVLGVO | CURR | 10 | ||
| BVLGVP | Order volume at retail with tax | MCW_BVLGVP | CURR | 10 | ||
| BVLANZ | Order volume, number of transactions | MCW_BVLANZ | INT4 | 4 | ||
| WESMAO | Goods receipt margin (vendor+GR(DC)) | MCW_WESMAO | DEC | 4 | ||
| WESMAM | Goods receipt margin with tax (vendor+GR(DC)) | MCW_WESMAM | DEC | 4 | ||
| UMSMAO | Sales margin | MCW_UMSMAO | DEC | 4 | ||
| UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 4 | ||
| BVLMAO | Order volume margin | MCW_BVLMAO | DEC | 4 | ||
| BVLMAM | Order volume margin with tax | MCW_BVLMAM | DEC | 4 |