S107 - Season: Movements + Stock
Season: Movements + Stock information is stored in SAP table S107.
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 S107
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 | |
| EKGRP | Purchasing Group | X | EKGRP | CHAR | 6 | T024 |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| LIFNR | Vendor's account number | X | ELIFN | CHAR | 20 | LFA1 |
| MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
| SATNR | Cross-Plant Configurable Material | X | SATNR | CHAR | 80 | MARA |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| SAISJ | Season Year | X | SAISJ | CHAR | 8 | |
| SAISO | Season Category | X | SAISO | CHAR | 8 | T6WSP |
| PLGTP | Price Band Category | X | PLGTP | CHAR | 4 | TWPT |
| 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 | ||
| AUMMNG | Promotion sales quantity in BUn | MCW_AUMMNG | QUAN | 8 | ||
| AUMGEO | Promotion sales at cost | MCW_AUMGEO | CURR | 10 | ||
| AUMGVO | Promotion sales at retail | MCW_AUMGVO | CURR | 10 | ||
| AUMGVP | Promotion sales at retail with tax | MCW_AUMGVP | CURR | 10 | ||
| UBPVPM | Revaluation at retail, plus, quantity | MCW_UBPVPM | QUAN | 8 | ||
| UBPGVO | Revaluation at retail, plus | MCW_UBPGVO | CURR | 10 | ||
| UBPGVP | Revaluation at retail, plus, at retail with tax | MCW_UBPGVP | CURR | 10 | ||
| UBPVAZ | Revaluation at retail, plus, no. of transactions | MCW_UBPVAZ | INT4 | 4 | ||
| UBMVPM | Revaluation at retail, minus, quantity | MCW_UBMVPM | QUAN | 8 | ||
| UBMGVO | Revaluation at retail, minus | MCW_UBMGVO | CURR | 10 | ||
| UBMGVP | Revaluation at retail, minus, at retail with tax | MCW_UBMGVP | CURR | 10 | ||
| UBMVAZ | Revaluation at retail, minus, no. of transactions | MCW_UBMVAZ | INT4 | 4 | ||
| ABGMNG | Issues quantity in BUn | MCW_ABGMNG | QUAN | 8 | ||
| ABGGEO | Issues at cost | MCW_ABGGEO | CURR | 10 | ||
| ABGGVO | Issues at retail | MCW_ABGGVO | CURR | 10 | ||
| ABGGVP | Issues at retail with tax | MCW_ABGGVP | CURR | 10 | ||
| BBZMNG | Order stock receipts quantity in BUn | MCW_BBZMNG | QUAN | 8 | ||
| BBZGEO | Order stock receipts at cost | MCW_BBZGEO | CURR | 10 | ||
| BBZGVO | Order stock receipts at retail | MCW_BBZGVO | CURR | 10 | ||
| BBZGVP | Order stock receipts at retail with tax | MCW_BBZGVP | CURR | 10 | ||
| BBAMNG | Order stock issues quantity in BUn | MCW_BBAMNG | QUAN | 8 | ||
| BBAGEO | Order stock issues at cost | MCW_BBAGEO | CURR | 10 | ||
| BBAGVO | Order stock issues at retail | MCW_BBAGVO | CURR | 10 | ||
| BBAGVP | Order stock issues at retail with tax | MCW_BBAGVP | CURR | 10 | ||
| 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 | ||
| ULEMNG | Goods clearing: receipts quantity in BUn | MCW_ULEMNG | QUAN | 8 | ||
| ULEGEO | Goods clearing: receipts at cost | MCW_ULEGEO | CURR | 10 | ||
| ULEGVO | Goods clearing: receipts at retail | MCW_ULEGVO | CURR | 10 | ||
| ULEGVP | Goods clearing: receipts at retail with tax | MCW_ULEGVP | CURR | 10 | ||
| ULEANZ | Goods clearing: receipts, no. of transactions | MCW_ULEANZ | INT4 | 4 | ||
| ULAMNG | Goods clearing: issues quantity in BUn | MCW_ULAMNG | QUAN | 8 | ||
| ULAGEO | Goods clearing: issues at cost | MCW_ULAGEO | CURR | 10 | ||
| ULAGVO | Goods clearing: issues at retail | MCW_ULAGVO | CURR | 10 | ||
| ULAGVP | Goods clearing: issues at retail with tax | MCW_ULAGVP | CURR | 10 | ||
| ULAANZ | Goods clearing: issues, no. of transactions | MCW_ULAANZ | INT4 | 4 | ||
| BSTMNG | Stock quantity in base unit of measure | MCW_BSTMNG | QUAN | 8 | ||
| BSTGEO | Stock at cost | MCW_BSTGEO | CURR | 10 | ||
| BSTGVO | Stock at retail | MCW_BSTGVO | CURR | 10 | ||
| BSTGVP | Stock at retail with tax | MCW_BSTGVP | CURR | 10 | ||
| BBSMNG | On-order stock quantity in BUn | MCW_BBSMNG | QUAN | 8 | ||
| BBSGEO | On-order stock at cost | MCW_BBSGEO | CURR | 10 | ||
| BBSGVO | On-order stock at retail | MCW_BBSGVO | CURR | 10 | ||
| BBSGVP | On-order stock at retail with tax | MCW_BBSGVP | CURR | 10 | ||
| ERSTZU | First receipt | MCW_ERSTZU | DATS | 16 | ||
| TAGEIV | Days on sale, no. of | MCW_TAGEIV | INT4 | 4 | ||
| URSPVP | Original retail price | MCW_URSPVP | CURR | 6 | ||
| AQMENG | Sales quota (quantity) | MCW_AQMENG | DEC | 4 | ||
| AQWERT | Sales quota (value) | MCW_AQWERT | DEC | 4 | ||
| FUMGVP | Fictitious sales at retail with tax | MCW_FUMGVP | CURR | 10 | ||
| FBSGVP | Fictitious stock at retail with tax | MCW_FBSGVP | CURR | 10 | ||
| UMSMAO | Sales margin | MCW_UMSMAO | DEC | 4 | ||
| UMSMAM | Sales margin with tax | MCW_UMSMAM | DEC | 4 | ||
| AUMMAO | Promotion sales margin | MCW_AUMMAO | DEC | 4 | ||
| AUMMAM | Promotion sales margin with tax | MCW_AUMMAM | DEC | 4 | ||
| BSTMAO | Stock margin | MCW_BSTMAO | DEC | 4 | ||
| BSTMAM | Stock margin including tax | MCW_BSTMAM | DEC | 4 | ||
| BBSMAO | On-order stock margin | MCW_BBSMAO | DEC | 4 | ||
| BBSMAM | On-order stock margin with tax | MCW_BBSMAM | DEC | 4 | ||
| UHMENG | Inventory turn (quantity) | MCW_UHMENG | DEC | 4 | ||
| UHWERT | Inventory turn (value) | MCW_UHWERT | DEC | 4 | ||
| JUMENG | Annual inventory turn (quantity) | MCW_JUMENG | DEC | 4 | ||
| JUWERT | Annual inventory turn (value) | MCW_JUWERT | DEC | 4 | ||
| GMROIO | Gross margin return on inventory investment | MCW_GMROIO | DEC | 4 | ||
| GMROIM | Gross margin return on inventory investment with tax | MCW_GMROIM | DEC | 4 | ||
| RWMENG | Range of coverage in days (quantity) | MCW_RWMENG | DEC | 4 | ||
| RWWERT | Range of coverage in days (value) | MCW_RWWERT | DEC | 4 | ||
| SBSMNG | End of season stock quantity in BUn | MCW_SBSMNG | QUAN | 8 | ||
| SBSGEO | End of season stock at cost | MCW_SBSGEO | CURR | 10 | ||
| SBSGVO | End of season stock at retail | MCW_SBSGVO | CURR | 10 | ||
| SBSGVP | End of season stock at retail with tax | MCW_SBSGVP | CURR | 10 | ||
| MERK1 | Characteristic 1 | MCW_MERK1 | CHAR | 140 | ||
| MERK2 | Characteristic 2 | MCW_MERK2 | CHAR | 140 | ||
| MERK3 | Characteristic 3 | MCW_MERK3 | CHAR | 140 | ||
| WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 36 | ||
| WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 36 | ||
| ATINM1 | Internal characteristic number, characteristic 1 | MCW_ATINM1 | NUMC | 20 | * | |
| ATINM2 | Internal characteristic number, characteristic 2 | MCW_ATINM2 | NUMC | 20 | * | |
| ATINM3 | Internal characteristic number, characteristic 3 | MCW_ATINM3 | NUMC | 20 | * |