SAP Table SMCHA
Lock Table MCHA
SMCHA (Lock Table MCHA) 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 SMCHA to other SAP tables.
SMCHA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
| WERKS | Plant | WERKS_D | MARC | CHAR | 4 | 0 | ||||||
| CHARG | Batch Number | CHARG_D | MCHA | CHAR | 10 | 0 | ||||||
| RMCHA | Return code for Table MCHA | RMCHA | CHAR | 1 | 0 |
Possible values
|
||||||
| XDBUP | Database update | XDBUP | CHAR | 1 | 0 |
Possible values
|
||||||
| XCHUP | Database update | XDBUP | CHAR | 1 | 0 |
Possible values
|
||||||
| XMARE | Checkbox | XFELD | CHAR | 1 | 0 |
Possible values
|
||||||
| LVORM | Deletion Flag for All Data on a Batch at a Plant | LVOCA | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| 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 | ||||||
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 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 |
Possible values
|
||||||
| BATCH_TYPE | Type of Batch | BATCH_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||
SMCHA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SMCHA | BWTAR | SYST | MANDT | T149D | Global Valuation Types | MANDT |
| SMCHA | BWTAR | SMCHA | BWTAR | T149D | Global Valuation Types | BWTAR |
| SMCHA | CHARG | SMCHA | CHARG | MCHA | Batches | CHARG |
| SMCHA | CHARG | SYST | MANDT | MCHA | Batches | MANDT |
| SMCHA | CHARG | SMCHA | MATNR | MCHA | Batches | MATNR |
| SMCHA | CHARG | SMCHA | WERKS | MCHA | Batches | WERKS |
| SMCHA | HERKL | SY | MANDT | T005 | Countries | MANDT |
| SMCHA | HERKL | SMCHA | HERKL | T005 | Countries | LAND1 |
| SMCHA | HERKR | SMCHA | HERKR | T005S | Taxes: Region (Province) Key | BLAND |
| SMCHA | HERKR | SY | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| SMCHA | HERKR | SMCHA | HERKL | T005S | Taxes: Region (Province) Key | LAND1 |
| SMCHA | LIFNR | SY | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| SMCHA | LIFNR | SMCHA | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| SMCHA | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
| SMCHA | MATNR | SMCHA | MATNR | MARA | General Material Data | MATNR |
| SMCHA | MTVER | SY | MANDT | TVFM | Foreign Trade: Material Pricing Groups in Export | MANDT |
| SMCHA | MTVER | SMCHA | MTVER | TVFM | Foreign Trade: Material Pricing Groups in Export | MTVER |
| SMCHA | VLMAT | SY | MANDT | MARA | General Material Data | MANDT |
| SMCHA | VLMAT | SMCHA | VLMAT | MARA | General Material Data | MATNR |
| SMCHA | VLWRK | SY | MANDT | MARC | Plant Data for Material | MANDT |
| SMCHA | VLWRK | SMCHA | VLMAT | MARC | Plant Data for Material | MATNR |
| SMCHA | VLWRK | SMCHA | VLWRK | MARC | Plant Data for Material | WERKS |
| SMCHA | WERKS | SMCHA | MATNR | MARC | Plant Data for Material | MATNR |
| SMCHA | WERKS | SMCHA | WERKS | MARC | Plant Data for Material | WERKS |
| SMCHA | WERKS | SYST | MANDT | MARC | Plant Data for Material | MANDT |
