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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
MCHB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MCHB | CHARG | MCHB | WERKS |
MCHA
Batches
|
WERKS |
| MCHB | CHARG | MCHB | CHARG |
MCHA
Batches
|
CHARG |
| MCHB | CHARG | MCHB | MANDT |
MCHA
Batches
|
MANDT |
| MCHB | CHARG | MCHB | MATNR |
MCHA
Batches
|
MATNR |
| MCHB | HERKL | MCHB | MANDT |
T005
Countries
|
MANDT |
| MCHB | HERKL | MCHB | HERKL |
T005
Countries
|
LAND1 |
| 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 | LGORT | MCHB | MANDT |
MARD
Storage Location Data for Material
|
MANDT |
| 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 | MANDT |
MARC
Plant Data for Material
|
MANDT |
| MCHB | WERKS | MCHB | MATNR |
MARC
Plant Data for Material
|
MATNR |
| MCHB | WERKS | MCHB | WERKS |
MARC
Plant Data for Material
|
WERKS |