SAP MCHB Batch Stocks Table data and field list

MCHB is a standard SAP Table which is used to store Batch Stocks data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MCHB table consists of various fields, each holding specific information or linking keys about Batch Stocks data available in SAP. These include MATNR (Material Number), WERKS (Plant), LGORT (Storage Location), CHARG (Batch Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

MCHB table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MCHB table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MCHB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4MARCWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4MARDLGORTLAG
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA
LVORMDeletion Flag for All Data on a Batch Stock LVOCBCHAR1XFELD
ERSDACreated On ERSDADATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
LAEDADate of Last Change LAEDADATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
LFGJAFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
LFMONCurrent period (posting period) LFMONNUMC2MONAT
SPERCPhysical Inventory Blocking Indicator SPERRCHAR1SPERR
CLABSValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
CUMLMStock in transfer (from one storage location to another) UMLMDQUAN13(3) MENG13V
CINSMStock in Quality Inspection INSMEQUAN13(3) MENG13V
CEINMTotal Stock of All Restricted Batches EINMEQUAN13(3) MENG13V
CSPEMBlocked Stock SPEMEQUAN13(3) MENG13V
CRETMBlocked Stock Returns RETMEQUAN13(3) MENG13V
CVMLAValuated unrestricted-use stock in previous period VMLABQUAN13(3) MENG13V
CVMUMStock in Transfer in Previous Period VMUMLQUAN13(3) MENG13V
CVMINStock in Quality Inspection in Previous Period VMINSQUAN13(3) MENG13V
CVMEIRestricted-Use Stock in Previous Period VMEINQUAN13(3) MENG13V
CVMSPBlocked stock of previous period VMSPEQUAN13(3) MENG13V
CVMREBlocked Stock Returns in Previous Period VMRETQUAN13(3) MENG13V
KZICLPhysical inventory indicator for whse stock in current year KZILLCHAR3INVKZ
KZICQPhys. inventory ind. f. stock in qual. insp. in current year KZILQCHAR3INVKZ
KZICEPhysical inventory indicator for restricted-use stock KZILECHAR3INVKZ
KZICSPhysical inventory indicator for blocked stock KZILSCHAR3INVKZ
KZVCLPhysical inventory indicator for stock in previous year KZVLLCHAR3INVKZ
KZVCQPhys. inventory ind. f. stock in qual. insp. in prev. period KZVLQCHAR3INVKZ
KZVCEPhysical inventory ind. for restricted-use stock, prev.pd KZVLECHAR3INVKZ
KZVCSPhys. inventory indicator for blocked stock in prev. period KZVLSCHAR3INVKZ
HERKLCountry of origin of the material HERKLCHAR3T005LAND1LND
CHDLLDate of Last Posted Count for Unrestricted-Use Stock DLINLDATS8DATS
CHJINFiscal year of current physical inventory indicator GJINVNUMC4GJAHRGJAHR
CHRUEMCHBH rec. already exists for per. before last of MCHB per. CHRUECHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table MCHB using ABAP code

The following ABAP code Example will allow you to do a basic selection on MCHB to SELECT all data from the table
DATA: WA_MCHB TYPE MCHB.

SELECT SINGLE *
FROM MCHB
INTO CORRESPONDING FIELDS OF WA_MCHB
WHERE...

How to access SAP table MCHB

Within an ECC or HANA version of SAP you can also view further information about MCHB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to MCHB

    MARA - General Material Data
        MBEW - Material Valuation
        MARC - Plant Data for Material
            MARD - Material Master: Storage Location/Batch Segment
                MCHB - Batch Stocks

    MARAV - Generated Table for View MARAV
        MARM - Units of measure
    MLGT - Material Data for each storage type
        MBEWV - Generated Table for View MBEWV
        MVKE - Material Master: Sales Data
        MARCV - Generated Table for View MARCV
            PROPF - Forecast Parameters
            MARD - Material Master: Storage Location/Batch Segment
                MCHB - Batch Stocks
                    MKOL - Special Stocks from Vendor
        MLGN - Material Data for each warehouse number