SAP Table MCHI1
Data Fields for MCHA, MCH1 and MCH2: Division 1
MCHI1 (Data Fields for MCHA, MCH1 and MCH2: Division 1) 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 MCHI1 to other SAP tables.
MCHI1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ERSDA | Created On | ERSDA | DATS | 8 | 0 | |||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
| LAEDA | Date of Last Change | LAEDA | DATS | 8 | 0 | |||||||
| VERAB | Availability date | VERAB | DATS | 8 | 0 | |||||||
| VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | 0 | |||||||
| ZUSCH | Batch status key | DZUSCH | CHAR | 1 | 0 | |||||||
| ZUSTD | Batch in Restricted-Use Stock | DZUSTD | CHAR | 1 | 0 |
Possible values
|
||||||
| ZAEDT | Date of last status change | DZAEDT | DATS | 8 | 0 | |||||||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||
| LICHA | Vendor Batch Number | LICHN | CHAR | 15 | 0 | |||||||
| VLCHA | Original batch number (deactivated) | VLCHN | CHAR | 10 | 0 | |||||||
| VLWRK | Original plant (deactivated) | VLWRK | MARC | CHAR | 4 | 0 | ||||||
| VLMAT | Original material (deactivated) | VLMAT | MARA | CHAR | 18 | 0 | ||||||
MCHI1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MCHI1 | LIFNR | SY | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| MCHI1 | LIFNR | MCHI1 | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| MCHI1 | VLMAT | MCHI1 | VLMAT | MARA | General Material Data | MATNR |
| MCHI1 | VLMAT | SY | MANDT | MARA | General Material Data | MANDT |
| MCHI1 | VLWRK | SY | MANDT | MARC | Plant Data for Material | MANDT |
| MCHI1 | VLWRK | MCHI1 | VLMAT | MARC | Plant Data for Material | MATNR |
| MCHI1 | VLWRK | MCHI1 | VLWRK | MARC | Plant Data for Material | WERKS |
