SAP table MCHA (Batches)

SAP table MCHA has 4 primary key fields being MANDT,MATNR,WERKS,CHARG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 MARC WERKS_D
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
LVORM Deletion Flag for All Data on a Batch at a Plant CHAR 1 0 LVOCA
ERSDA Created On DATS 8 0 ERSDA
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
LAEDA Date of Last Change DATS 8 0 LAEDA
VERAB Availability date DATS 8 0 VERAB
VFDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
ZUSCH Batch status key CHAR 1 0 * DZUSCH
ZUSTD Batch in Restricted-Use Stock CHAR 1 0 DZUSTD
ZAEDT Date of last status change DATS 8 0 DZAEDT
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
LICHA Supplier Batch Number CHAR 15 0 LICHN
VLCHA Original batch number (deactivated) CHAR 10 0 MCHA VLCHN
VLWRK Original plant (deactivated) CHAR 4 0 MARC VLWRK
VLMAT Original material (deactivated) CHAR 40 0 MARA VLMAT
BATCH_ID Batch ID RAW 16 0 BATCH_GUID
XPCBT Single-Unit Batch Indicator CHAR 1 0 MILL_XPCBT
Batch is not a singe-unit batch
X Batch is a singe-unit batch
BWTAR Valuation Type CHAR 10 0 MBEW BWTAR_D
CHAME Unit of issue for batch (deactivated) UNIT 3 0 T006 CHAME
LWEDT Date of last goods receipt DATS 8 0 LWEDT
FVDT1 Date for Free Use DATS 8 0 FVDAT
FVDT2 Date for Free Use DATS 8 0 FVDAT
FVDT3 Date for Free Use DATS 8 0 FVDAT
FVDT4 Date for Free Use DATS 8 0 FVDAT
FVDT5 Date for Free Use DATS 8 0 FVDAT
FVDT6 Date for Free Use DATS 8 0 FVDAT
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 T005S HERKR
MTVER Material Group for Intrastat CHAR 4 0 TVFM MTVER
QNDAT Next Inspection Date DATS 8 0 QNPDAT
HSDAT Date of Manufacture DATS 8 0 HSDAT
CUOBJ_BM Internal object no.: Batch classification NUMC 18 0 CUOBJ_BM
DEACT_BM Batch is no longer active CHAR 1 0 DEACT_BM
BATCH_TYPE Type of Batch CHAR 1 0 BATCH_TYPE
Batch
1 WIP Batch
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
ERSDA_TMSTP DEPRECATED - DO NOT USE DEC 15 0 LOBM_DEPRECATED_TIMESTAMP
ERSDA_TZ_SYS DEPRECATED - DO NOT USE CHAR 6 0 * LOBM_DEPRECATED_TZNZONE
ERSDA_TZ_USR DEPRECATED - DO NOT USE CHAR 6 0 * LOBM_DEPRECATED_TZNZONE
ZFDAT Date of Certification DATS 8 0 DZFDAT
CREATION_DATETIME Created On Timestamp DEC 21 7 LOBM_CREATED_ON
LASTCHANGE_DATETIME Last Change Timestamp DEC 21 7 LOBM_LAST_CHANGED
/STTPEC/SERTYPE Serialization Type INT1 3 0 /STTPEC/E_SERTYPE
/STTPEC/PLANT Batch Production Plant (Initial Plant) CHAR 4 0 * /STTPEC/E_WERKSP
/STTPEC/SYNCTIME Synchronization Time Stamp DEC 15 0 /STTPEC/E_SYNCTIME
/STTPEC/SYNCACT Synchronization Active CHAR 1 0 /STTPEC/E_SYNCACTIVE
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME

MCHA foreign key relationships

Table Field Check Table Check Field
0 MCHA BWTAR MBEW Material Valuation MANDT
0 MCHA BWTAR MBEW Material Valuation MATNR
0 MCHA BWTAR MBEW Material Valuation BWKEY
0 MCHA BWTAR MBEW Material Valuation BWTAR
1 MCHA CHAME T006 Units of Measurement MANDT
0 MCHA CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 MCHA HERKL T005 Countries MANDT
1 MCHA HERKL T005 Countries LAND1
0 MCHA HERKR T005S Taxes: Region (Province) Key LAND1
1 MCHA LIFNR LFA1 Supplier Master (General Section) MANDT
1 MCHA LIFNR LFA1 Supplier Master (General Section) LIFNR
0 MCHA MANDT T000 Clients MANDT
1 MCHA MATNR MARA General Material Data MANDT
1 MCHA MATNR MARA General Material Data MATNR
0 MCHA MTVER TVFM Material Group for Intrastat MANDT
1 MCHA VLCHA MCHA Batches MANDT
1 MCHA VLCHA MCHA Batches WERKS
1 MCHA VLCHA MCHA Batches CHARG
0 MCHA VLMAT MARA General Material Data MANDT
0 MCHA VLMAT MARA General Material Data MATNR
1 MCHA VLWRK MARC Plant Data for Material MANDT
1 MCHA VLWRK MARC Plant Data for Material MATNR
1 MCHA VLWRK MARC Plant Data for Material WERKS
0 MCHA WERKS MARC Plant Data for Material MANDT
0 MCHA WERKS MARC Plant Data for Material MATNR
0 MCHA WERKS MARC Plant Data for Material WERKS