SAP Table MCHA
Batches
MCHA (Batches) 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 MCHA to other SAP tables.
MCHA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
| WERKS | Plant | WERKS_D | MARC | CHAR | 4 | 0 | ||||||
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 | 0 | ||||||
| LVORM | Deletion Flag for All Data on a Batch at a Plant | LVOCA | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | MCHA | CHAR | 10 | 0 | ||||||
| VLWRK | Original plant (deactivated) | VLWRK | MARC | CHAR | 4 | 0 | ||||||
| VLMAT | Original material (deactivated) | VLMAT | MARA | CHAR | 18 | 0 | ||||||
| BWTAR | Valuation Type | BWTAR_D | MBEW | CHAR | 10 | 0 | ||||||
| CHAME | Unit of issue for batch (deactivated) | CHAME | T006 | UNIT | 3 | 0 | ||||||
| LWEDT | Date of last goods receipt | LWEDT | DATS | 8 | 0 | |||||||
| FVDT1 | Date for unrestricted use | FVDAT | DATS | 8 | 0 | |||||||
| FVDT2 | Date for unrestricted use | FVDAT | DATS | 8 | 0 | |||||||
| FVDT3 | Date for unrestricted use | FVDAT | DATS | 8 | 0 | |||||||
| FVDT4 | Date for unrestricted use | FVDAT | DATS | 8 | 0 | |||||||
| FVDT5 | Date for unrestricted use | FVDAT | DATS | 8 | 0 | |||||||
| FVDT6 | Date for unrestricted use | FVDAT | DATS | 8 | 0 | |||||||
| HERKL | Country of origin of the material | HERKL | T005 | CHAR | 3 | 0 | ||||||
| HERKR | Region of origin of material (non-preferential origin) | HERKR | T005S | CHAR | 3 | 0 | ||||||
| MTVER | Export/import material group | MTVER | TVFM | CHAR | 4 | 0 | ||||||
| QNDAT | Next Inspection Date | QNPDAT | DATS | 8 | 0 | |||||||
| HSDAT | Date of Manufacture | HSDAT | DATS | 8 | 0 | |||||||
| CUOBJ_BM | Internal object no.: Batch classification | CUOBJ_BM | NUMC | 18 | 0 | |||||||
| DEACT_BM | Batch is no longer active | DEACT_BM | CHAR | 1 | 0 |
Possible values
|
||||||
| BATCH_TYPE | Type of Batch | BATCH_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||
MCHA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MCHA | BWTAR | MCHA | BWTAR | MBEW | Material Valuation | BWTAR |
| MCHA | BWTAR | MCHA | MANDT | MBEW | Material Valuation | MANDT |
| MCHA | BWTAR | MCHA | MATNR | MBEW | Material Valuation | MATNR |
| MCHA | BWTAR | T001W | BWKEY | MBEW | Material Valuation | BWKEY |
| MCHA | CHAME | MCHA | MANDT | T006 | Units of Measurement | MANDT |
| MCHA | CHAME | MCHA | CHAME | T006 | Units of Measurement | MSEHI |
| MCHA | CHARG | MCHA | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| MCHA | CHARG | MCHA | MATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| MCHA | CHARG | MCHA | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
| MCHA | HERKL | MCHA | MANDT | T005 | Countries | MANDT |
| MCHA | HERKL | MCHA | HERKL | T005 | Countries | LAND1 |
| MCHA | HERKR | MCHA | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| MCHA | HERKR | MCHA | HERKL | T005S | Taxes: Region (Province) Key | LAND1 |
| MCHA | HERKR | MCHA | HERKR | T005S | Taxes: Region (Province) Key | BLAND |
| MCHA | LIFNR | MCHA | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| MCHA | LIFNR | MCHA | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| MCHA | MANDT | MCHA | MANDT | T000 | Clients | MANDT |
| MCHA | MATNR | MCHA | MANDT | MARA | General Material Data | MANDT |
| MCHA | MATNR | MCHA | MATNR | MARA | General Material Data | MATNR |
| MCHA | MTVER | MCHA | MANDT | TVFM | Foreign Trade: Material Pricing Groups in Export | MANDT |
| MCHA | MTVER | MCHA | MTVER | TVFM | Foreign Trade: Material Pricing Groups in Export | MTVER |
| MCHA | VLCHA | MCHA | VLMAT | MCHA | Batches | MATNR |
| MCHA | VLCHA | MCHA | VLWRK | MCHA | Batches | WERKS |
| MCHA | VLCHA | MCHA | VLCHA | MCHA | Batches | CHARG |
| MCHA | VLCHA | MCHA | MANDT | MCHA | Batches | MANDT |
| MCHA | VLMAT | MCHA | MANDT | MARA | General Material Data | MANDT |
| MCHA | VLMAT | MCHA | VLMAT | MARA | General Material Data | MATNR |
| MCHA | VLWRK | MCHA | MANDT | MARC | Plant Data for Material | MANDT |
| MCHA | VLWRK | MCHA | VLMAT | MARC | Plant Data for Material | MATNR |
| MCHA | VLWRK | MCHA | VLWRK | MARC | Plant Data for Material | WERKS |
| MCHA | WERKS | MCHA | MATNR | MARC | Plant Data for Material | MATNR |
| MCHA | WERKS | MCHA | WERKS | MARC | Plant Data for Material | WERKS |
| MCHA | WERKS | MCHA | MANDT | MARC | Plant Data for Material | MANDT |
