SAP table MCHP (Batch Record for a Batch)

SAP table MCHP has 4 primary key fields being MANDT,MATNR,CHARG,EBRID.

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
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
EBRID Batch record number CHAR 15 0 EBRID
WERKS Plant CHAR 4 0 T001W WERKS_D
EBRSTATUS Status of the batch record CHAR 1 0 EBRSTATUS
1 Created
2 Enhanced
3 Archived
4 Approval version
5 Approved
6 Part.approved
7 Approval withdrawn
DOKNR Document number CHAR 25 0 DRAW DOKNR
DOKAR Document Type CHAR 3 0 DRAW DOKAR
DOKTL Document Part CHAR 3 0 DRAW DOKTL_D
DOKVR Document Version CHAR 2 0 DRAW DOKVR
VALDAT Availability date of batch record DATS 8 0 CHARG_DAT
VERSION Version of a Batch Record NUMC 4 0 EBR_VERS
VERS_STAT Batch record: old, new, or mixed version handling CHAR 1 0 EBRVSTAT
Old version handling
1 New version handling
2 Old and new versions exist

MCHP foreign key relationships

Table Field Check Table Check Field
0 MCHP CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 MCHP DOKAR DRAW Document Info Record DOKNR
1 MCHP DOKAR DRAW Document Info Record DOKVR
1 MCHP DOKAR DRAW Document Info Record DOKTL
0 MCHP DOKNR DRAW Document Info Record DOKNR
0 MCHP DOKNR DRAW Document Info Record DOKVR
0 MCHP DOKNR DRAW Document Info Record DOKTL
1 MCHP DOKTL DRAW Document Info Record DOKNR
1 MCHP DOKTL DRAW Document Info Record DOKVR
1 MCHP DOKTL DRAW Document Info Record DOKTL
0 MCHP DOKVR DRAW Document Info Record DOKNR
0 MCHP DOKVR DRAW Document Info Record DOKVR
0 MCHP DOKVR DRAW Document Info Record DOKTL
1 MCHP MANDT T000 Clients MANDT
0 MCHP MATNR MARA General Material Data MANDT
0 MCHP MATNR MARA General Material Data MATNR
1 MCHP WERKS T001W Plants/Branches MANDT
1 MCHP WERKS T001W Plants/Branches WERKS