SAP ABAP Table MCHI1 (Data Fields for MCHA, MCH1 and MCH2: Division 1)

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	INTTAB	Structure
Structure	MCHI1	Table Relationship Diagram
Short Description	Data Fields for MCHA, MCH1 and MCH2: Division 1

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
2	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
3	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
4	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
5	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
6	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
7	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
8	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
9	ZAEDT	☐	DZAEDT	DATUM	DATS	8	0	Date of last status change
10	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
11	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
12	VLCHA	☐	VLCHN	CHARG	CHAR	10	0	Original batch number (deactivated)	*
13	VLWRK	☐	VLWRK	WERKS	CHAR	4	0	Original plant (deactivated)	MARC
14	VLMAT	☐	VLMAT	MATNR	CHAR	18	0	Original material (deactivated)	MARA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCHI1	LIFNR	LFA1	LIFNR
2	MCHI1	VLMAT	MARA	MATNR
3	MCHI1	VLWRK	MARC	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in