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)
8 Comments
Unknown User (y9v3t8s)
Very good, thank you very much!
Former Member
Very Helpful collection of Table ,Thanks.
Former Member
Really very useful! Thanks!
Former Member
this is very useful and helpful summary !!!
Former Member
very useful and detailed summary. It will help for anyone who has to do learn more on STOCK tables.
Thank You,
Regards,
Vivek
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!