MCHA SAP (Batches) Table details

Dictionary Type: Table
Description: Batches




ABAP Code to SELECT data from MCHA
Related tables to MCHA
Access table MCHA




Table field list including key, data, relationships and ABAP select examples

MCHA is a standard SAP Table which is used to store Batches data and is available within R/3 SAP systems depending on the version and release level.

The MCHA table consists of various fields, each holding specific information or linking keys about Batches data available in SAP. These include MATNR (Material Number), WERKS (Plant), CHARG (Batch Number), LVORM (Deletion Flag for All Data on a Batch at a Plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MCHA table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4MARCWERKSWRKH_T001W_C
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
LVORMDeletion Flag for All Data on a Batch at a Plant LVOCACHAR1XFELD
ERSDACreated On ERSDADATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
LAEDADate of Last Change LAEDADATS8DATUM
VERABAvailability date VERABDATS8DATUM
VFDATShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
ZUSCHBatch status key DZUSCHCHAR1Assigned to domainZUSCH
ZUSTDBatch in Restricted-Use Stock DZUSTDCHAR1XFELD
ZAEDTDate of last status change DZAEDTDATS8DATUM
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
LICHAVendor Batch Number LICHNCHAR15LICHN
VLCHAOriginal batch number (deactivated) VLCHNCHAR10MCHACHARG
VLWRKOriginal plant (deactivated) VLWRKCHAR4MARCWERKS
VLMATOriginal material (deactivated) VLMATCHAR18MARAMATN1MATNR
.INCLU--AP 0
XPCBTSingle-Unit Batch Indicator MILL_XPCBTCHAR1MILL_XPCBT
BWTARValuation Type BWTAR_DCHAR10MBEWBWTARBWT
CHAMEUnit of issue for batch (deactivated) CHAMEUNIT3T006CUNITMEINS
LWEDTDate of last goods receipt LWEDTDATS8DATUM
FVDT1Date for unrestricted use FVDATDATS8DATUM
FVDT2Date for unrestricted use FVDATDATS8DATUM
FVDT3Date for unrestricted use FVDATDATS8DATUM
FVDT4Date for unrestricted use FVDATDATS8DATUM
FVDT5Date for unrestricted use FVDATDATS8DATUM
FVDT6Date for unrestricted use FVDATDATS8DATUM
HERKLCountry of origin of the material HERKLCHAR3T005LAND1LND
HERKRRegion of origin of material (non-preferential origin) HERKRCHAR3T005SREGIO
MTVERExport/import material group MTVERCHAR4TVFMMTVER
QNDATNext Inspection Date QNPDATDATS8DATUM
HSDATDate of Manufacture HSDATDATS8DATUM
CUOBJ_BMInternal object no.: Batch classification CUOBJ_BMNUMC18CUOBJ
DEACT_BMBatch is no longer active DEACT_BMCHAR1XFELD
BATCH_TYPEType of Batch BATCH_TYPECHAR1BATCH_TYPE

Key field Non-key field



How do I retrieve data from SAP table MCHA using ABAP code

The following ABAP code Example will allow you to do a basic selection on MCHA to SELECT all data from the table
DATA: WA_MCHA TYPE MCHA.

SELECT SINGLE *
FROM MCHA
INTO CORRESPONDING FIELDS OF WA_MCHA
WHERE...

How to access SAP table MCHA

Within an ECC or HANA version of SAP you can also view further information about MCHA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!