SAP Table MCHB stores Batch Stocksdata

  

In this post, I will try and describe everything you need to know about the SAP mchb table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for MCHB what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from MCHB....Right lets get started!


SAP MCHB dictionary attributes

Object Name: MCHB
Dictionary Type: Transparent table
Description: Batch Stocks


MCHB field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
MATNRMATNRCHAR18(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
WERKSWERKS_DCHAR4(0) MARCPlantWERKSWRKKCH_T001W_CWERKS
LGORTLGORT_DCHAR4(0) MARDStorage LocationLGORTLAGMG
CHARGCHARG_DCHAR10(0) MCHABatch NumberCHARGCHAMG
LVORMLVOCBCHAR1(0) Deletion Flag for All Data on a Batch StockXFELDMG
ERSDAERSDADATS8(0) Created OnDATUMMG
ERNAMERNAMCHAR12(0) Name of Person who Created the ObjectUSNAMSAP
LAEDALAEDADATS8(0) Date of Last ChangeDATUMMG
AENAMAENAMCHAR12(0) Name of Person Who Changed ObjectUSNAMSAP
LFGJALFGJANUMC4(0) Fiscal Year of Current PeriodGJAHRMG
LFMONLFMONNUMC2(0) Current period (posting period)MONATMG
SPERCSPERRCHAR1(0) Physical Inventory Blocking IndicatorSPERRMG
CLABSLABSTQUAN13(3) Valuated Unrestricted-Use StockMENG13VMG
CUMLMUMLMDQUAN13(3) Stock in transfer (from one storage location to another)MENG13VMG
CINSMINSMEQUAN13(3) Stock in Quality InspectionMENG13VMG
CEINMEINMEQUAN13(3) Total Stock of All Restricted BatchesMENG13VMG
CSPEMSPEMEQUAN13(3) Blocked StockMENG13VMG
CRETMRETMEQUAN13(3) Blocked Stock ReturnsMENG13VMG
CVMLAVMLABQUAN13(3) Valuated unrestricted-use stock in previous periodMENG13VMG
CVMUMVMUMLQUAN13(3) Stock in Transfer in Previous PeriodMENG13VMG
CVMINVMINSQUAN13(3) Stock in Quality Inspection in Previous PeriodMENG13VMG
CVMEIVMEINQUAN13(3) Restricted-Use Stock in Previous PeriodMENG13VMG
CVMSPVMSPEQUAN13(3) Blocked stock of previous periodMENG13VMG
CVMREVMRETQUAN13(3) Blocked Stock Returns in Previous PeriodMENG13VMG
KZICLKZILLCHAR3(0) Physical inventory indicator for whse stock in current yearINVKZMB
KZICQKZILQCHAR3(0) Phys. inventory ind. f. stock in qual. insp. in current yearINVKZMG
KZICEKZILECHAR3(0) Physical inventory indicator for restricted-use stockINVKZMG
KZICSKZILSCHAR3(0) Physical inventory indicator for blocked stockINVKZMG
KZVCLKZVLLCHAR3(0) Physical inventory indicator for stock in previous yearINVKZMG
KZVCQKZVLQCHAR3(0) Phys. inventory ind. f. stock in qual. insp. in prev. periodINVKZMG
KZVCEKZVLECHAR3(0) Physical inventory ind. for restricted-use stock, prev.pdINVKZMG
KZVCSKZVLSCHAR3(0) Phys. inventory indicator for blocked stock in prev. periodINVKZMG
HERKLHERKLCHAR3(0) T005Country of origin of the materialLAND1LNDMG
CHDLLDLINLDATS8(0) Date of Last Posted Count for Unrestricted-Use StockDATS
CHJINGJINVNUMC4(0) Fiscal year of current physical inventory indicatorGJAHR
CHRUECHRUECHAR1(0) MCHBH rec. already exists for per. before last of MCHB per.XFELD