S200 - Inventory Controlling Stores
Inventory Controlling Stores information is stored in SAP table S200.
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 S200
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 | |
| INVNU | Physical Inventory Number | X | INVNU1 | CHAR | 32 | |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| LGORT | Storage location | X | LGORT_D | CHAR | 8 | |
| MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| CHARG | Batch Number | X | CHARG_D | CHAR | 20 | MCH1 |
| SOBKZ | Special Stock Indicator | X | SOBKZ | CHAR | 2 | T148 |
| BSTAR | Stock type | X | BSTAR | CHAR | 2 | T064A |
| IVSTAT | Statistical status of physical inventory | X | IVSTATUS | NUMC | 4 | |
| 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 | |
| IBUMNG | Book inventory balance, quantity in base unit of measure | MCW_IBUMNG | QUAN | 8 | ||
| IBUGEO | Book inventory balance at cost | MCW_IBUGEO | CURR | 9 | ||
| IBUGVO | Book inventory balance at retail | MCW_IBUGVO | CURR | 9 | ||
| IBUGVP | Book inventory balance at retail with tax | MCW_IBUGVP | CURR | 9 | ||
| IZLMNG | Quantity of stock, counted in base unit of measure | MCW_IZLMNG | QUAN | 8 | ||
| IZLGEO | Quantity of stock counted at cost | MCW_IZLGEO | CURR | 9 | ||
| IZLGVO | Quantity of stock counted at retail | MCW_IZLGVO | CURR | 9 | ||
| IZLGVP | Quantity of stock counted at retail with tax | MCW_IZLGVP | CURR | 9 | ||
| IDMMNG | Minus inventory difference quantity in BUn | MCW_IDMMNG | QUAN | 8 | ||
| IDMGEO | Minus inventory difference at cost | MCW_IDMGEO | CURR | 9 | ||
| IDMGVO | Minus inventory difference at retail | MCW_IDMGVO | CURR | 9 | ||
| IDMGVP | Minus inventory difference at retail | MCW_IDMGVP | CURR | 9 | ||
| IDPMNG | Plus inventory difference quantity in BUn | MCW_IDPMNG | QUAN | 8 | ||
| IDPGEO | Plus inventory difference at cost | MCW_IDPGEO | CURR | 9 | ||
| IDPGVO | Plus inventory difference at retail | MCW_IDPGVO | CURR | 9 | ||
| IDPGVP | Plus inventory difference at retail with tax | MCW_IDPGVP | CURR | 9 | ||
| WGRU1 | Material group hierarchy 1 | MCW_WGRU1 | CHAR | 36 | ||
| WGRU2 | Material group hierarchy 2 | MCW_WGRU2 | CHAR | 36 | ||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 80 | MARA | |
| BTRKZ | Plant category | VLFKZ | CHAR | 2 | ||
| ABTNR | Department number | ABTNR | CHAR | 8 | TSAB | |
| KWART | Indicates that the value-only material is to be inventoried | XWART | CHAR | 2 |