1. Home
  2. Resources
  3. SAP Tables
  4. MCH1 - Batches (if Batch Management Cross-Plant)

SAP Table MCH1

Batches (if Batch Management Cross-Plant)

MCH1 (Batches (if Batch Management Cross-Plant)) 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 MCH1 to other SAP tables.

MCH1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
CHARG Batch Number CHARG_D CHAR 10 0
LVORM Deletion Flag for All Data in a Batch LVOC1 CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
CHAME Unit of issue for batch (deactivated) CHAME 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
X Yes
NULL No
BATCH_TYPE Type of Batch BATCH_TYPE CHAR 1 0
NULL Batch
1 WIP Batch

MCH1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCH1 HERKL MCH1 HERKL T005 Countries LAND1
MCH1 HERKL SY MANDT T005 Countries MANDT
MCH1 HERKR SY MANDT T005S Taxes: Region (Province) Key MANDT
MCH1 HERKR MCH1 HERKL T005S Taxes: Region (Province) Key LAND1
MCH1 HERKR MCH1 HERKR T005S Taxes: Region (Province) Key BLAND
MCH1 LIFNR SY MANDT LFA1 Vendor Master (General Section) MANDT
MCH1 LIFNR MCH1 LIFNR LFA1 Vendor Master (General Section) LIFNR
MCH1 MANDT MCH1 MANDT T000 Clients MANDT
MCH1 MATNR MCH1 MANDT MARA General Material Data MANDT
MCH1 MATNR MCH1 MATNR MARA General Material Data MATNR
MCH1 MTVER MCH1 MTVER TVFM Foreign Trade: Material Pricing Groups in Export MTVER
MCH1 MTVER SY MANDT TVFM Foreign Trade: Material Pricing Groups in Export MANDT
MCH1 VLMAT SY MANDT MARA General Material Data MANDT
MCH1 VLMAT MCH1 VLMAT MARA General Material Data MATNR
MCH1 VLWRK SY MANDT MARC Plant Data for Material MANDT
MCH1 VLWRK MCH1 VLMAT MARC Plant Data for Material MATNR
MCH1 VLWRK MCH1 VLWRK MARC Plant Data for Material WERKS