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 |
MSTB | Stock in Transit (as of 605) |
|
MSTE | Stock in Transit Sales Order (as of 605) | E |
MSTQ | Stock in Transit Project (as of 605) | Q |
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)
3 Comments
Abhishek Padmanabhuni Ayyappa
Very helpful, thanks for posting
Oliver Hörmann
Dear All,
what is with Stock Type:
B - Stock of Material Provided by Customer
or
CO_SOBKZ_D: 5 - Stock of Material Provided by Customer
does anybody know a helpfull process?
Regars,
Oliver
Hai Wang
Wow, what a great work. Thanks for sharing!