Model / MM / MCHB

MM — Materials Management

MCHB

37 fields · 5 key · 6 foreign keys · sourced from leanx.eu

Batch Stocks — the storage-location-level stock quantities for a batch, one row per material per plant per storage location per batch, mirroring MARD's stock-bucket structure (unrestricted, quality inspection, blocked, in-transfer, returns) but scoped down to a single batch. Completes the batch lane started by MCH1 (cross-plant batch header) and MCHA (plant-level batch); this is the table a batch-aware inventory query joins against for on-hand quantity.

Hover a canonical name to see the legacy SAP field name

Canonical nameConceptDescriptionData elementTypeCheck table
CLI keycliensClientMANDTCLNT 3T000
MAT_NUM keymateria numerusMaterial NumberMATNRCHAR 18MARA
OFC keyofficinaPlantWERKS_DCHAR 4MARC
LOC keylocus repositionisStorage LocationLGORT_DCHAR 4MARD
GRX_NUM keygrex numerusBatch NumberCHARG_DCHAR 10MCHA
SGN_GRX_CPAsignum grex copiaDeletion Flag for All Data on a Batch StockLVOCBCHAR 1
CREcreatusCreated OnERSDADATS 8
NOM_PSN_CREnomen persona creatusName of Person who Created the ObjectERNAMCHAR 12
DIE_ULTdies ultimusDate of Last ChangeLAEDADATS 8
NOM_PSN_MUTnomen persona mutatusName of Person Who Changed ObjectAENAMCHAR 12
ANF_PERannus fiscalis periodusFiscal Year of Current PeriodLFGJANUMC 4
PER_INSperiodus inscriptioCurrent period (posting period)LFMONNUMC 2
IDXindexPhysical Inventory Blocking IndicatorSPERRCHAR 1
CPAcopiaValuated Unrestricted-Use StockLABSTQUAN 13,3
CPA_LOCcopia locus repositionisStock in transfer (from one storage location to another)UMLMDQUAN 13,3
CPA_ISPcopia inspectioStock in Quality InspectionINSMEQUAN 13,3
TOT_CPAsumma totalis copiaTotal Stock of All Restricted BatchesEINMEQUAN 13,3
CPA2copiaBlocked StockSPEMEQUAN 13,3
CPA3copiaBlocked Stock ReturnsRETMEQUAN 13,3
CPA_PERcopia periodusValuated unrestricted-use stock in previous periodVMLABQUAN 13,3
CPA_PER2copia periodusStock in Transfer in Previous PeriodVMUMLQUAN 13,3
CPA_ISP_PERcopia inspectio periodusStock in Quality Inspection in Previous PeriodVMINSQUAN 13,3
CPA_PER3copia periodusRestricted-Use Stock in Previous PeriodVMEINQUAN 13,3
CPA_PER4copia periodusBlocked stock of previous periodVMSPEQUAN 13,3
CPA_PER5copia periodusBlocked Stock Returns in Previous PeriodVMRETQUAN 13,3
IDX_CPA_ANNindex copia annusPhysical inventory indicator for whse stock in current yearKZILLCHAR 3
CPA_ANNcopia annusPhys. inventory ind. f. stock in qual. insp. in current yearKZILQCHAR 3
IDX_CPAindex copiaPhysical inventory indicator for restricted-use stockKZILECHAR 3
IDX_CPA2index copiaPhysical inventory indicator for blocked stockKZILSCHAR 3
IDX_CPA_ANN2index copia annusPhysical inventory indicator for stock in previous yearKZVLLCHAR 3
CPA_PER6copia periodusPhys. inventory ind. f. stock in qual. insp. in prev. periodKZVLQCHAR 3
CPA4copiaPhysical inventory ind. for restricted-use stock, prev.pdKZVLECHAR 3
IDX_CPA_PERindex copia periodusPhys. inventory indicator for blocked stock in prev. periodKZVLSCHAR 3
PTR_ORG_MATpatria origo materiaCountry of origin of the materialHERKLCHAR 3T005
DIE_ULT_CPAdies ultimus copiaDate of Last Posted Count for Unrestricted-Use StockDLINLDATS 8
ANF_IDXannus fiscalis indexFiscal year of current physical inventory indicatorGJINVNUMC 4
ULTultimusMCHBH rec. already exists for per. before last of MCHB per.CHRUECHAR 1

Foreign keys

FieldCheck tableCheck field
MANDTT000MANDT
MATNRMARAMATNR
WERKSMARCWERKS
LGORTMARDLGORT
CHARGMCHACHARG
HERKLT005LAND1

View MCHB.yaml in the repository