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)
时间： 2024-07-30 16:13:24