SAP MM Stock Tables and Stock Types
转自：http://wiki.scn.sap.com/wiki/display/ERPSCM/Stock+Tables+and+Stock+Types
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)
