SAP Table S107
Season: Movements + Stock
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S107 (Season: Movements + Stock) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S107 |
| Short Text | Season: Movements + Stock |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S107
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| EKGRP | ✔ | Purchasing Group | EKGRP | CHAR | 3 | T024 |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| LIFNR | ✔ | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| SATNR | ✔ | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| SAISJ | ✔ | Season Year | SAISJ | CHAR | 4 | |
| SAISO | ✔ | Season Category | SAISO | CHAR | 4 | T6WSP |
| PLGTP | ✔ | Price Band Category | PLGTP | CHAR | 2 | TWPT |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | |
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15 | ||
| UMSGEO | Sales at cost | MCW_UMSGEO | CURR | 19 | ||
| UMSGVO | Sales at retail | MCW_UMSGVO | CURR | 19 | ||
| UMSGVP | Sales at retail with tax | MCW_UMSGVP | CURR | 19 | ||
| PRSNLS | Sales deviation during sales | MCW_PRSNLS | CURR | 19 | ||
| AUMMNG | Promotion sales quantity in BUn | MCW_AUMMNG | QUAN | 15 | ||
| AUMGEO | Promotion sales at cost | MCW_AUMGEO | CURR | 19 | ||
| AUMGVO | Promotion sales at retail | MCW_AUMGVO | CURR | 19 | ||
| AUMGVP | Promotion sales at retail with tax | MCW_AUMGVP | CURR | 19 | ||
| UBPVPM | Revaluation at retail, plus, quantity | MCW_UBPVPM | QUAN | 15 | ||
| UBPGVO | Revaluation at retail, plus | MCW_UBPGVO | CURR | 19 | ||
| UBPGVP | Revaluation at retail, plus, at retail with tax | MCW_UBPGVP | CURR | 19 | ||
| UBPVAZ | Revaluation at retail, plus, no. of transactions | MCW_UBPVAZ | INT4 | 10 | ||
| UBMVPM | Revaluation at retail, minus, quantity | MCW_UBMVPM | QUAN | 15 | ||
| UBMGVO | Revaluation at retail, minus | MCW_UBMGVO | CURR | 19 | ||
| UBMGVP | Revaluation at retail, minus, at retail with tax | MCW_UBMGVP | CURR | 19 | ||
| UBMVAZ | Revaluation at retail, minus, no. of transactions | MCW_UBMVAZ | INT4 | 10 | ||
| ZUGMNG | Receipts quantity in BUn | MCW_ZUGMNG | QUAN | 15 | ||
| ZUGGEO | Receipts at cost | MCW_ZUGGEO | CURR | 19 | ||
| ZUGGVO | Receipts at retail | MCW_ZUGGVO | CURR | 19 | ||
| ZUGGVP | Receipts at retail with tax | MCW_ZUGGVP | CURR | 19 | ||
| ABGMNG | Issues quantity in BUn | MCW_ABGMNG | QUAN | 15 | ||
| ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 19 | ||
| ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 19 | ||
| ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 19 | ||
| BBZMNG | Order stock receipts quantity in BUn | MCW_BBZMNG | QUAN | 15 | ||
| BBZGEO | Order stock receipts at cost | MCW_BBZGEO | CURR | 19 | ||
| BBZGVO | Order stock receipts at retail | MCW_BBZGVO | CURR | 19 | ||
| BBZGVP | Order stock receipts at retail with tax | MCW_BBZGVP | CURR | 19 | ||
| BBAMNG | Order stock issues quantity in BUn | MCW_BBAMNG | QUAN | 15 | ||
| BBAGEO | Order stock issues at cost | MCW_BBAGEO | CURR | 19 | ||
| BBAGVO | Order stock issues at retail | MCW_BBAGVO | CURR | 19 | ||
| BBAGVP | Order stock issues at retail with tax | MCW_BBAGVP | CURR | 19 | ||
| KMAMNG | Goods issue (distribution center) quantity in BUn | MCW_KMAMNG | QUAN | 15 | ||
| KMAGEO | Goods issue (DC) at cost | MCW_KMAGEO | CURR | 19 | ||
| KMAGVO | Goods issue (DC) at retail | MCW_KMAGVO | CURR | 19 | ||
| KMAGVP | Goods issue (dist. center) at retail with tax | MCW_KMAGVP | CURR | 19 | ||
| KMAANZ | Goods issue (distribution center), no. of transactions | MCW_KMAANZ | INT4 | 10 | ||
| ULEMNG | Goods clearing: receipts quantity in BUn | MCW_ULEMNG | QUAN | 15 | ||
| ULEGEO | Goods clearing: receipts at cost | MCW_ULEGEO | CURR | 19 | ||
| ULEGVO | Goods clearing: receipts at retail | MCW_ULEGVO | CURR | 19 | ||
| ULEGVP | Goods clearing: receipts at retail with tax | MCW_ULEGVP | CURR | 19 | ||
| ULEANZ | Goods clearing: receipts, no. of transactions | MCW_ULEANZ | INT4 | 10 | ||
| ULAMNG | Goods clearing: issues quantity in BUn | MCW_ULAMNG | QUAN | 15 | ||
| ULAGEO | Goods clearing: issues at cost | MCW_ULAGEO | CURR | 19 | ||
| ULAGVO | Goods clearing: issues at retail | MCW_ULAGVO | CURR | 19 | ||
| ULAGVP | Goods clearing: issues at retail with tax | MCW_ULAGVP | CURR | 19 | ||
| ULAANZ | Goods clearing: issues, no. of transactions | MCW_ULAANZ | INT4 | 10 | ||
| BSTMNG | Stock quantity in base unit of measure | MCW_BSTMNG | QUAN | 15 | ||
| BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 19 | ||
| BSTGVO | Stock at retail | MCW_BSTGVO | CURR | 19 | ||
| BSTGVP | Stock at retail with tax | MCW_BSTGVP | CURR | 19 | ||
| BBSMNG | On-order stock quantity in BUn | MCW_BBSMNG | QUAN | 15 | ||
| BBSGEO | On-order stock at cost | MCW_BBSGEO | CURR | 19 | ||
| BBSGVO | On-order stock at retail | MCW_BBSGVO | CURR | 19 | ||
| BBSGVP | On-order stock at retail with tax | MCW_BBSGVP | CURR | 19 | ||
| ERSTZU | First receipt | MCW_ERSTZU | DATS | 8 | ||
| TAGEIV | Days on sale, no. of | MCW_TAGEIV | INT4 | 10 | ||
| URSPVP | Original retail price | MCW_URSPVP | CURR | 11 | ||
| AQMENG | Sales quota (quantity) | MCW_AQMENG | DEC | 6 | ||
| AQWERT | Sales quota (value) | MCW_AQWERT | DEC | 6 | ||
| FUMGVP | Fictitious sales at retail with tax | MCW_FUMGVP | CURR | 19 | ||
| FBSGVP | Fictitious stock at retail with tax | MCW_FBSGVP | CURR | 19 | ||
| UMSMAO | Sales margin | MCW_UMSMAO | DEC | 6 | ||
| UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 6 | ||
| AUMMAO | Promotion sales margin | MCW_AUMMAO | DEC | 6 | ||
| AUMMAM | Promotion sales margin with tax | MCW_AUMMAM | DEC | 6 | ||
| BSTMAO | Stock margin | MCW_BSTMAO | DEC | 6 | ||
| BSTMAM | Stock margin including tax | MCW_BSTMAM | DEC | 6 | ||
| BBSMAO | On-order stock margin | MCW_BBSMAO | DEC | 6 | ||
| BBSMAM | On-order stock margin with tax | MCW_BBSMAM | DEC | 6 | ||
| UHMENG | Inventory turn (quantity) | MCW_UHMENG | DEC | 6 | ||
| UHWERT | Inventory turn (value) | MCW_UHWERT | DEC | 6 | ||
| JUMENG | Annual inventory turn (quantity) | MCW_JUMENG | DEC | 6 | ||
| JUWERT | Annual inventory turn (value) | MCW_JUWERT | DEC | 6 | ||
| GMROIO | Gross margin return on inventory investment | MCW_GMROIO | DEC | 6 | ||
| GMROIM | Gross margin return on inventory investment with tax | MCW_GMROIM | DEC | 6 | ||
| RWMENG | Range of coverage in days (quantity) | MCW_RWMENG | DEC | 7 | ||
| RWWERT | Range of coverage in days (value) | MCW_RWWERT | DEC | 7 | ||
| SBSMNG | End of season stock quantity in BUn | MCW_SBSMNG | QUAN | 15 | ||
| SBSGEO | End of season stock at cost | MCW_SBSGEO | CURR | 19 | ||
| SBSGVO | End of season stock at retail | MCW_SBSGVO | CURR | 19 | ||
| SBSGVP | End of season stock at retail with tax | MCW_SBSGVP | CURR | 19 | ||
| MERK1 | Characteristic 1 | MCW_MERK1 | CHAR | 30 | ||
| MERK2 | Characteristic 2 | MCW_MERK2 | CHAR | 30 | ||
| MERK3 | Characteristic 3 | MCW_MERK3 | CHAR | 30 | ||
| WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | ||
| WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | ||
| ATINM1 | Internal characteristic number, characteristic 1 | MCW_ATINM1 | NUMC | 10 | * | |
| ATINM2 | Internal characteristic number, characteristic 2 | MCW_ATINM2 | NUMC | 10 | * | |
| ATINM3 | Internal characteristic number, characteristic 3 | MCW_ATINM3 | NUMC | 10 | * |