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