The Most Important SAP Stocks Tables used in SAP MM/SD

SAP Material

SAP Stocks are the main topics in Inventory Management in SAP.

In this post, you will be found the most important SAP Stocks Tables for Valuation, quantity and Types of stocks.

SAP Stock Tables

The main Tables for SAP stock are:

TableDescriptionSOBKZ
MARCPlant Data for Material
MARDStorage Location Data for Material
MCHBBatch Stocks
MKOLSpecial Stocks from VendorK/M
MSKASales Order StockE
MSKUSpecial Stocks with CustomerV/W
MSLBSpecial Stocks with VendorO
MSPRProject StockQ
MSSATotal Customer Orders on HandE
MSSLTotal Special Stocks with VendorO
MSSQProject Stock TotalQ
MSTBStock in Transit (as of 605)
MSTEStock in Transit Sales Order (as of 605)E
MSTQStock in Transit Project (as of 605)Q

SAP Stocks Valuation Tables

The list of SAP Stocks Valuation Tables are :

TableDescription
MBEWMaterial Valuation
EBEWSales Order Stock Valuation
QBEWProject Stock Valuation
OBEWValuated Stock with Subcontractor (only for Japan)

SAP Stocks Document Tables

SAP Stocks Document Tables are:

TableMeaningKey fields
MKPFHeader: Material Document Document number (MBLNR) & year (MJAHR)
MSEGMaterial Document – segments/ linesDocument number (MBLNR) & year (MJAHR) & line number (ZEILE)
BSIMIndex for material to the FI-documents Material (MATNR) & Valuation Area (BWKEY)…
CKMI1Material ledger index& used to document changes in MBEW for each movement KALNR use mbew-kaln1

Learn more about SAP Goods Movement here.

All SAP Stocks Tables

MARC – Plant Data for Material

MARC is the Plant Data for Material Table in SAP.

TableFieldMeaningValuated inTotalHistory tablePosted with
MARCPlant Data for Material
MARCUMLMCStock in transfer (plant to plant)MBEWMARCHTransfer without PO: 303 / 305
MARCTRAMEStock in transitMBEWMARCHTransfer with PO :351 / 101 & 641
MARCGLGMGTied empties stockMBEWMARCH
MARCVKUMCStock transfer sales value (plant to plant) for VO materialMBEWMARCH
MARCVKTRWTransit value at sales price for value-only materialMBEWMARCH
MARCBWESBValuated Goods Receipt Blocked StockMBEWMARCH

MARD – Storage Location Data for Material

MARD is Storage Location Data for Material is SAP.

TableFieldMeaningValuated inTotalHistory tablePosted with
MARDStorage Location Data for Material
MARDLABSTValuated stock with unrestricted useMBEWMARDH
MARDUMLMEStock in transfer (from one storage location to another)MBEWMARDH313 / 315
MARDINSMEStock in quality inspectionMBEWMARDH
MARDEINMETotal Stock of All Restricted BatchesMBEWMARDH
MARDSPEMEBlocked stockMBEWMARDH
MARDRETMEBlocked Stock ReturnsMARDH
MARDKLABSUnrestricted-use consignment stock
MARDKINSMConsignment stock in quality inspection
MARDKEINMRestricted-use consignment stock
MARDKSPEMBlocked consignment stock

MCHB – Batch Stocks

Batch stocks are stored in MCHB Table in SAP.

TableFieldMeaningValuated inTotalHistory tablePosted with
MCHBCLABSValuated stock with unrestricted useMBEWMARD-LABSTMCHBH
MCHBCUMLMStock in transfer (from one storage location to another)MBEWMARD-UMLMEMCHBH
MCHBCINSMStock in quality inspectionMBEWMARD-INSMEMCHBH
MCHBCEINMTotal Stock of All Restricted BatchesMBEWMARD-EINMEMCHBH
MCHBCSPEMBlocked stockMBEWMARD-SPEMEMCHBH
MCHBCRETMBlocked Stock ReturnsMARD-RETMEMCHBH

MSSL – Total Special Stocks with Vendor

The SAP table MSSL contains Total Special Stocks with Vendor

TableFieldMeaningValuated inTotalHistory tablePosted with
MSSLSLLBValuated stock with unrestricted useMBEW**
MSSLSLINSStock in quality inspectionMBEW**
MSSLSLEINTotal Stock of All Restricted BatchesMBEW**

MSLB – Special Stocks with Vendor

MSLB – Special Stocks with Vendor

TableFieldMeaningValuated inTotal in tableHistory tablePosted with
MSLBLBLABValuated stock with unrestricted useMBEWMSSL-SLLABMSLBH
MSLBLBINSStock in quality inspectionMBEWMSSL-SLINSMSLBH
MSLBLBEINTotal Stock of All Restricted BatchesMBEWMSSL-SLEINMSLBH

MSKU – Special Stocks with Customer

MSKU – Special Stocks with Customer

TableFieldMeaningValuated inTotalHistory tablePosted with
MSKUKULABValuated stock with unrestricted useMBEWMSKUH
MSKUKUINSStock in quality inspectionMBEWMSKUH
MSKUKUEINTotal Stock of All Restricted BatchesMBEWMSKUH

MSSA – Total Customer Orders on Hand

MSSA – Total Customer Orders on Hand

TableFieldMeaningValuated inTotalHistory tablePosted with
MSSASALABTotal Customer Orders on HandEBEW* MBEW+
MSSASAINSStock in quality inspectionEBEW* MBEW+
MSSASASPEBlocked stockEBEW* MBEW+
MSSASAEINTotal Stock of All Restricted BatchesEBEW* MBEW+
MSSASATRAStock in transitEBEW* MBEW+MSSAH

MSKA – Sales Order Stock

MSKA – Sales Order Stock

TableFieldMeaningValuated inTotalHistory tablePosted with
MSKAKALABTotal Customer Orders on HandEBEW* MBEW+MSSA-SALABMSKAH
MSKAKAINSStock in quality inspectionEBEW* MBEW+MSSA-SAINSMSKAH
MSKAKASPEBlocked stockEBEW* MBEW+MSSA-SASPEMSKAH
MSKAKAEINTotal Stock of All Restricted BatchesEBEW* MBEW+MSSA-SAEINMSKAH

MSSQ – Project Stock Total

MSSQ – Project Stock Total

TableFieldMeaningValuated inTotalHistory tablePosted with
MSSQSQLABTotal Customer Orders on HandQBEW* MBEW+
MSSQSQINSStock in quality inspectionQBEW* MBEW+
MSSQSQSPEBlocked stockQBEW* MBEW+
MSSQSQEINTotal Stock of All Restricted BatchesQBEW* MBEW+
MSSQSQTRAStock in transitQBEW* MBEW+MSSQH

MSPR – Project Stock

MSPR – Project Stock

TableFieldMeaningValuated inTotalHistory tablePosted with
MSPRPRLABTotal Customer Orders on HandQBEW* MBEW+MSSQ-SQLABMSPRH
MSPRPRINSStock in quality inspectionQBEW* MBEW+MSSQ-SQINSMSPRH
MSPRPRSPEBlocked stockQBEW* MBEW+MSSQ-SQSPEMSPRH
MSPRPREINTotal Stock of All Restricted BatchesQBEW* MBEW+MSSQ-SQEINMSPRH

MKOL – Special SAP Stocks from Vendor

MKOL – Special SAP Stocks from Vendor

TableFieldMeaningValuated inTotalHistory tablePosted with
MKOLSLABSUnrestricted-use consignment stockMARD-KLABSMKOLH
MKOLSINSMConsignment stock in quality inspectionMARD-KINSMMKOLH
MKOLSEINMRestricted-use consignment stockMARD-KEINMMKOLH
MKOLSSPEMBlocked consignment stockMARD-KSPEMMKOLH

Source: scn.sap.com

For information on SAP Stocks, check this SAP Stock Overview