SAP ABAP Table MCHA (Batches)

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	MCHA	Table Relationship Diagram
Short Description	Batches

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	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
5	LVORM	☐	LVOCA	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch at a Plant
6	.INCLUDE	☐				0	0	Data Fields for MCHA, MCH1 and MCH2: Division 1
7	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
11	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
12	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
13	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key	*
14	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
15	ZAEDT	☐	DZAEDT	DATUM	DATS	8	0	Date of last status change
16	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
17	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
18	VLCHA	☐	VLCHN	CHARG	CHAR	10	0	Original batch number (deactivated)	MCHA
19	VLWRK	☐	VLWRK	WERKS	CHAR	4	0	Original plant (deactivated)	MARC
20	VLMAT	☐	VLMAT	MATNR	CHAR	18	0	Original material (deactivated)	MARA
21	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
22	.INCLUDE	☐				0	0	Data Fields for MCHA, MCH1 and MCH2: Division 2
23	CHAME	☐	CHAME	MEINS	UNIT	3	0	Unit of issue for batch (deactivated)	T006
24	LWEDT	☐	LWEDT	DATUM	DATS	8	0	Date of last goods receipt
25	FVDT1	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
26	FVDT2	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
27	FVDT3	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
28	FVDT4	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
29	FVDT5	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
30	FVDT6	☐	FVDAT	DATUM	DATS	8	0	Date for unrestricted use
31	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
32	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
33	MTVER	☐	MTVER	MTVER	CHAR	4	0	Export/import material group	TVFM
34	QNDAT	☐	QNPDAT	DATUM	DATS	8	0	Next Inspection Date
35	HSDAT	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
36	CUOBJ_BM	☐	CUOBJ_BM	CUOBJ	NUMC	18	0	Internal object no.: Batch classification
37	DEACT_BM	☐	DEACT_BM	XFELD	CHAR	1	0	Batch is no longer active
38	BATCH_TYPE	☐	BATCH_TYPE	BATCH_TYPE	CHAR	1	0	Type of Batch

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCHA	BWTAR	MBEW	BWTAR
2	MCHA	CHAME	T006	MSEHI	REF	C	CN
3	MCHA	CHARG	MCH1	CHARG	KEY	1	CN
4	MCHA	HERKL	T005	LAND1	REF	C	CN
5	MCHA	HERKR	T005S	BLAND	REF	C	CN
6	MCHA	LIFNR	LFA1	LIFNR
7	MCHA	MANDT	T000	MANDT	KEY	1	CN
8	MCHA	MATNR	MARA	MATNR	KEY	1	CN
9	MCHA	MTVER	TVFM	MTVER	REF	C	CN
10	MCHA	VLCHA	MCHA	CHARG	REF	C	CN
11	MCHA	VLMAT	MARA	MATNR	REF	C	CN
12	MCHA	VLWRK	MARC	WERKS	REF	C	CN
13	MCHA	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in