1. Home
  2. Resources
  3. SAP Tables
  4. MCHB - Batch Stocks

SAP Table MCHB

Batch Stocks

MCHB (Batch Stocks) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MCHB to other SAP tables.

MCHB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D MARD CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
LVORM Deletion Flag for All Data on a Batch Stock LVOCB CHAR 1 0
X Yes
NULL No
ERSDA Created On ERSDA DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
SPERC Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
CLABS Valuated Unrestricted-Use Stock LABST QUAN 13 3
CUMLM Stock in transfer (from one storage location to another) UMLMD QUAN 13 3
CINSM Stock in Quality Inspection INSME QUAN 13 3
CEINM Total Stock of All Restricted Batches EINME QUAN 13 3
CSPEM Blocked Stock SPEME QUAN 13 3
CRETM Blocked Stock Returns RETME QUAN 13 3
CVMLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
CVMUM Stock in Transfer in Previous Period VMUML QUAN 13 3
CVMIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
CVMEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
CVMSP Blocked stock of previous period VMSPE QUAN 13 3
CVMRE Blocked Stock Returns in Previous Period VMRET QUAN 13 3
KZICL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZICQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZICE Physical inventory indicator for restricted-use stock KZILE CHAR 3 0
KZICS Physical inventory indicator for blocked stock KZILS CHAR 3 0
KZVCL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
KZVCQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
KZVCE Physical inventory ind. for restricted-use stock, prev.pd KZVLE CHAR 3 0
KZVCS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
HERKL Country of origin of the material HERKL T005 CHAR 3 0
CHDLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
CHJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
CHRUE MCHBH rec. already exists for per. before last of MCHB per. CHRUE CHAR 1 0
X Yes
NULL No

MCHB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCHB CHARG MCHB MATNR MCHA Batches MATNR
MCHB CHARG MCHB WERKS MCHA Batches WERKS
MCHB CHARG MCHB CHARG MCHA Batches CHARG
MCHB CHARG MCHB MANDT MCHA Batches MANDT
MCHB HERKL MCHB HERKL T005 Countries LAND1
MCHB HERKL MCHB MANDT T005 Countries MANDT
MCHB LGORT MCHB MANDT MARD Storage Location Data for Material MANDT
MCHB LGORT MCHB MATNR MARD Storage Location Data for Material MATNR
MCHB LGORT MCHB WERKS MARD Storage Location Data for Material WERKS
MCHB LGORT MCHB LGORT MARD Storage Location Data for Material LGORT
MCHB MANDT MCHB MANDT T000 Clients MANDT
MCHB MATNR MCHB MANDT MARA General Material Data MANDT
MCHB MATNR MCHB MATNR MARA General Material Data MATNR
MCHB WERKS MCHB WERKS MARC Plant Data for Material WERKS
MCHB WERKS MCHB MANDT MARC Plant Data for Material MANDT
MCHB WERKS MCHB MATNR MARC Plant Data for Material MATNR