SAP Table S200
Inventory Controlling Stores
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table S200 (Inventory Controlling Stores) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S200 |
| Short Text | Inventory Controlling Stores |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S200
| 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 | |
| INVNU | ✔ | Physical inventory number | INVNU1 | CHAR | 16 | |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| LGORT | ✔ | Storage Location | LGORT_D | CHAR | 4 | * |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| CHARG | ✔ | Batch Number | CHARG_D | CHAR | 10 | MCH1 |
| SOBKZ | ✔ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 |
| BSTAR | ✔ | Stock type | BSTAR | CHAR | 1 | T064A |
| IVSTAT | ✔ | Statistical status of physical inventory | IVSTATUS | NUMC | 2 | |
| 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 | |
| IBUMNG | Book inventory balance, quantity in base unit of measure | MCW_IBUMNG | QUAN | 15 | ||
| IBUGEO | Book inventory balance at cost | MCW_IBUGEO | CURR | 17 | ||
| IBUGVO | Book inventory balance at retail | MCW_IBUGVO | CURR | 17 | ||
| IBUGVP | Book inventory balance at retail with tax | MCW_IBUGVP | CURR | 17 | ||
| IZLMNG | Quantity of stock, counted in base unit of measure | MCW_IZLMNG | QUAN | 15 | ||
| IZLGEO | Quantity of stock counted at cost | MCW_IZLGEO | CURR | 17 | ||
| IZLGVO | Quantity of stock counted at retail | MCW_IZLGVO | CURR | 17 | ||
| IZLGVP | Quantity of stock counted at retail with tax | MCW_IZLGVP | CURR | 17 | ||
| IDMMNG | Minus inventory difference quantity in BUn | MCW_IDMMNG | QUAN | 15 | ||
| IDMGEO | Minus inventory difference at cost | MCW_IDMGEO | CURR | 17 | ||
| IDMGVO | Minus inventory difference at retail | MCW_IDMGVO | CURR | 17 | ||
| IDMGVP | Minus inventory difference at retail | MCW_IDMGVP | CURR | 17 | ||
| IDPMNG | Plus inventory difference quantity in BUn | MCW_IDPMNG | QUAN | 15 | ||
| IDPGEO | Plus inventory difference at cost | MCW_IDPGEO | CURR | 17 | ||
| IDPGVO | Plus inventory difference at retail | MCW_IDPGVO | CURR | 17 | ||
| IDPGVP | Plus inventory difference at retail with tax | MCW_IDPGVP | CURR | 17 | ||
| WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 18 | ||
| WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 18 | ||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | |
| BTRKZ | Plant category | VLFKZ | CHAR | 1 | ||
| ABTNR | Department number | ABTNR | CHAR | 4 | TSAB | |
| KWART | Indicates that the value-only material is to be inventoried | XWART | CHAR | 1 |