Stock Tables and Stock Types
Content
Stock tables
| Table | Description | SOBKZ |
|---|---|---|
| MARC | Plant Data for Material | |
| MARD | Storage Location Data for Material | |
| MCHB | Batch Stocks | |
| MSSL | Total Special Stocks with Vendor | O |
| MSLB | Special Stocks with Vendor | O |
| MSKU | Special Stocks with Customer | V,W |
| MSSA | Total Customer Orders on Hand | E |
| MSKA | Sales Order Stock | E |
| MSSQ | Project Stock Total | Q |
| MSPR | Project Stock | Q |
| MKOL | Special Stocks from Vendor | K,M |
Valuation Tables
| Table | Description |
|---|---|
| MBEW | Material Valuation |
| EBEW | Sales Order Stock Valuation |
| QBEW | Project Stock Valuation |
| OBEW | Valuated Stock with Subcontractor (only for Japan) |
Document Tables
| Table | Meaning | Key fields |
|---|---|---|
| MKPF | Header: Material Document | Document number (MBLNR), year (MJAHR) |
| MSEG | Material Document - segments/ lines | Document number (MBLNR), year (MJAHR), line number (ZEILE) |
| BSIM | Index for material to the FI-documents | Material (MATNR), Valuation Area (BWKEY)... |
| CKMI1 | Material ledger index, used to document changes in MBEW for each movement | KALNR, use mbew-kaln1 |
All Stocks
| Table | Field | Meaning | Valuated in | Total in table | History table | Posted with |
|---|---|---|---|---|---|---|
| MARC | Plant Data for Material | |||||
| MARC | UMLMC | Stock in transfer (plant to plant) | MBEW | MARCH | Transfer without PO, 303 / 305 | |
| MARC | TRAME | Stock in transit | MBEW | MARCH | Transfer with PO, 351 / 101, 641 | |
| MARC | GLGMG | Tied empties stock | MBEW | MARCH | ||
| MARC | VKUMC | Stock transfer sales value (plant to plant) for VO material | MBEW | MARCH | ||
| MARC | VKTRW | Transit value at sales price for value-only material | MBEW | MARCH | ||
| MARC | BWESB | Valuated Goods Receipt Blocked Stock | MBEW | MARCH | ||
| MARD | Storage Location Data for Material | |||||
| MARD | LABST | Valuated stock with unrestricted use | MBEW | MARDH | ||
| MARD | UMLME | Stock in transfer (from one storage location to another) | MBEW | MARDH | 313 / 315 | |
| MARD | INSME | Stock in quality inspection | MBEW | MARDH | ||
| MARD | EINME | Total Stock of All Restricted Batches | MBEW | MARDH | ||
| MARD | SPEME | Blocked stock | MBEW | MARDH | ||
| MARD | RETME | Blocked Stock Returns | MARDH | |||
| MARD | KLABS | Unrestricted-use consignment stock | ||||
| MARD | KINSM | Consignment stock in quality inspection | ||||
| MARD | KEINM | Restricted-use consignment stock | ||||
| MARD | KSPEM | Blocked consignment stock | ||||
| MCHB | Batch Stocks | |||||
| MCHB | CLABS | Valuated stock with unrestricted use | MBEW | MARD-LABST | MCHBH | |
| MCHB | CUMLM | Stock in transfer (from one storage location to another) | MBEW | MARD-UMLME | MCHBH | |
| MCHB | CINSM | Stock in quality inspection | MBEW | MARD-INSME | MCHBH | |
| MCHB | CEINM | Total Stock of All Restricted Batches | MBEW | MARD-EINME | MCHBH | |
| MCHB | CSPEM | Blocked stock | MBEW | MARD-SPEME | MCHBH | |
| MCHB | CRETM | Blocked Stock Returns | MARD-RETME | MCHBH | ||
| MSSL | Total Special Stocks with Vendor | |||||
| MSSL | SLLB | Valuated stock with unrestricted use | MBEW** | |||
| MSSL | SLINS | Stock in quality inspection | MBEW** | |||
| MSSL | SLEIN | Total Stock of All Restricted Batches | MBEW** | |||
| MSLB | Special Stocks with Vendor | |||||
| MSLB | LBLAB | Valuated stock with unrestricted use | MBEW | MSSL-SLLAB | MSLBH | |
| MSLB | LBINS | Stock in quality inspection | MBEW | MSSL-SLINS | MSLBH | |
| MSLB | LBEIN | Total Stock of All Restricted Batches | MBEW | MSSL-SLEIN | MSLBH | |
| MSKU | Special Stocks with Customer | |||||
| MSKU | KULAB | Valuated stock with unrestricted use | MBEW | MSKUH | ||
| MSKU | KUINS | Stock in quality inspection | MBEW | MSKUH | ||
| MSKU | KUEIN | Total Stock of All Restricted Batches | MBEW | MSKUH | ||
| MSSA | Total Customer Orders on Hand | |||||
| MSSA | SALAB | Total Customer Orders on Hand | EBEW* MBEW+ | |||
| MSSA | SAINS | Stock in quality inspection | EBEW* MBEW+ | |||
| MSSA | SASPE | Blocked stock | EBEW* MBEW+ | |||
| MSSA | SAEIN | Total Stock of All Restricted Batches | EBEW* MBEW+ | |||
| MSSA | SATRA | Stock in transit | EBEW* MBEW+ | MSSAH | ||
| MSKA | Sales Order Stock | |||||
| MSKA | KALAB | Total Customer Orders on Hand | EBEW* MBEW+ | MSSA-SALAB | MSKAH | |
| MSKA | KAINS | Stock in quality inspection | EBEW* MBEW+ | MSSA-SAINS | MSKAH | |
| MSKA | KASPE | Blocked stock | EBEW* MBEW+ | MSSA-SASPE | MSKAH | |
| MSKA | KAEIN | Total Stock of All Restricted Batches | EBEW* MBEW+ | MSSA-SAEIN | MSKAH | |
| MSSQ | Project Stock Total | |||||
| MSSQ | SQLAB | Total Customer Orders on Hand | QBEW* MBEW+ | |||
| MSSQ | SQINS | Stock in quality inspection | QBEW* MBEW+ | |||
| MSSQ | SQSPE | Blocked stock | QBEW* MBEW+ | |||
| MSSQ | SQEIN | Total Stock of All Restricted Batches | QBEW* MBEW+ | |||
| MSSQ | SQTRA | Stock in transit | QBEW* MBEW+ | MSSQH | ||
| MSPR | Project Stock | |||||
| MSPR | PRLAB | Total Customer Orders on Hand | QBEW* MBEW+ | MSSQ-SQLAB | MSPRH | |
| MSPR | PRINS | Stock in quality inspection | QBEW* MBEW+ | MSSQ-SQINS | MSPRH | |
| MSPR | PRSPE | Blocked stock | QBEW* MBEW+ | MSSQ-SQSPE | MSPRH | |
| MSPR | PREIN | Total Stock of All Restricted Batches | QBEW* MBEW+ | MSSQ-SQEIN | MSPRH | |
| MKOL | Special Stocks from Vendor | |||||
| MKOL | SLABS | Unrestricted-use consignment stock | MARD-KLABS | MKOLH | ||
| MKOL | SINSM | Consignment stock in quality inspection | MARD-KINSM | MKOLH | ||
| MKOL | SEINM | Restricted-use consignment stock | MARD-KEINM | MKOLH | ||
| MKOL | SSPEM | Blocked consignment stock | MARD-KSPEM | MKOLH |
* only if MSSA/MSSQ - KZBWS = 'M'
+ only if MSSA/MSSQ - KZBWS = 'A'
** if MSSL-XOBEW = 'X' valuated in table OBEW (only for Japan from 4.6 on)
http://wiki.sdn.sap.com/wiki/display/ERPSCM/Stock+Tables+and+Stock+Types
