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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
BATCH_TYPE
Type of Batch
|
BATCH_TYPE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
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 |