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
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 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
X Yes
NULL No
BATCH_TYPE Type of Batch BATCH_TYPE CHAR 1 0
NULL Batch
1 WIP Batch

MCHA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
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 BWTAR MCHA BWTAR MBEW Material Valuation BWTAR
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 HERKL T005S Taxes: Region (Province) Key LAND1
MCHA HERKR MCHA HERKR T005S Taxes: Region (Province) Key BLAND
MCHA HERKR MCHA MANDT T005S Taxes: Region (Province) Key MANDT
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 MTVER TVFM Foreign Trade: Material Pricing Groups in Export MTVER
MCHA MTVER MCHA MANDT TVFM Foreign Trade: Material Pricing Groups in Export MANDT
MCHA VLCHA MCHA VLCHA MCHA Batches CHARG
MCHA VLCHA MCHA MANDT MCHA Batches MANDT
MCHA VLCHA MCHA VLMAT MCHA Batches MATNR
MCHA VLCHA MCHA VLWRK MCHA Batches WERKS
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 WERKS MARC Plant Data for Material WERKS
MCHA WERKS MCHA MANDT MARC Plant Data for Material MANDT
MCHA WERKS MCHA MATNR MARC Plant Data for Material MATNR