SAP ABAP Table MCHB (Batch Stocks)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MCHB	Table Relationship Diagram
Short Description	Batch Stocks

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
4	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	MARD
5	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
6	LVORM	☐	LVOCB	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch Stock
7	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
12	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
13	SPERC	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
14	CLABS	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
15	CUMLM	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
16	CINSM	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
17	CEINM	☐	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
18	CSPEM	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
19	CRETM	☐	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
20	CVMLA	☐	VMLAB	MENG13V	QUAN	13	3	Valuated unrestricted-use stock in previous period
21	CVMUM	☐	VMUML	MENG13V	QUAN	13	3	Stock in transfer, previous period
22	CVMIN	☐	VMINS	MENG13V	QUAN	13	3	Stock in quality inspection from previous period
23	CVMEI	☐	VMEIN	MENG13V	QUAN	13	3	Restricted-use stock in previous period
24	CVMSP	☐	VMSPE	MENG13V	QUAN	13	3	Blocked stock of previous period
25	CVMRE	☐	VMRET	MENG13V	QUAN	13	3	Blocked stock returns, previous period
26	KZICL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
27	KZICQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
28	KZICE	☐	KZILE	INVKZ	CHAR	3	0	Physical inventory indicator for restricted-use stock
29	KZICS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
30	KZVCL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
31	KZVCQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
32	KZVCE	☐	KZVLE	INVKZ	CHAR	3	0	Physical inventory ind. for restricted-use stock, prev.pd
33	KZVCS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
34	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
35	CHDLL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
36	CHJIN	☐	GJINV	GJAHR	NUMC	4	0	Fiscal year of current physical inventory indicator
37	CHRUE	☐	CHRUE	XFELD	CHAR	1	0	MCHBH rec. already exists for per. before last of MCHB per.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCHB	CHARG	MCHA	CHARG	KEY	1	CN
2	MCHB	HERKL	T005	LAND1	REF	C	CN
3	MCHB	LGORT	MARD	LGORT	KEY	1	CN
4	MCHB	MANDT	T000	MANDT	KEY	1	CN
5	MCHB	MATNR	MARA	MATNR	KEY	1	CN
6	MCHB	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in