1. Home
  2. Resources
  3. SAP Tables
  4. SMCHB - Lock Table MCHB

SAP Table SMCHB

Lock Table MCHB

SMCHB (Lock Table MCHB) 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 SMCHB to other SAP tables.

SMCHB table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
RMCHB Return code for Table MCHB RMCHB CHAR 1 0
X Yes
NULL No
XDBUP Database update XDBUP CHAR 1 0
X Yes
NULL No
CLABS Valuated Unrestricted-Use Stock LABST QUAN 13 3
CUMLM Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
CINSM Stock in Quality Inspection INSME QUAN 13 3
CEINM Total Stock of All Restricted Batches EINME QUAN 13 3
CSPEM Blocked Stock SPEME QUAN 13 3
CRETM Blocked Stock Returns RETME QUAN 13 3
CVMLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
CVMUM Stock in Transfer in Previous Period VMUML QUAN 13 3
CVMIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
CVMEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
CVMSP Blocked stock of previous period VMSPE QUAN 13 3
CVMRE Blocked Stock Returns in Previous Period VMRET QUAN 13 3
CLABS_OLD Valuated Unrestricted-Use Stock LABST QUAN 13 3
CUMLM_OLD Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
CINSM_OLD Stock in Quality Inspection INSME QUAN 13 3
CEINM_OLD Total Stock of All Restricted Batches EINME QUAN 13 3
CSPEM_OLD Blocked Stock SPEME QUAN 13 3
CRETM_OLD Blocked Stock Returns RETME QUAN 13 3
CVMLA_OLD Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
CVMUM_OLD Stock in Transfer in Previous Period VMUML QUAN 13 3
CVMIN_OLD Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
CVMEI_OLD Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
CVMSP_OLD Blocked stock of previous period VMSPE QUAN 13 3
CVMRE_OLD Blocked Stock Returns in Previous Period VMRET QUAN 13 3
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
LVORM Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
RMCHBH Indicator: MCHBH for previous period could not be read RMCHBH CHAR 1 0
X Yes
NULL No
CHLFM Period of MCHB CHLFM NUMC 2 0
CHGJA Fiscal year of MCHB CHGJA NUMC 4 0
CHRUE MCHBH rec. already exists for per. before last of MCHB per. CHRUE CHAR 1 0
X Yes
NULL No

SMCHB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SMCHB CHARG SYST MANDT MCHA Batches MANDT
SMCHB CHARG SMCHB MATNR MCHA Batches MATNR
SMCHB CHARG SMCHB WERKS MCHA Batches WERKS
SMCHB CHARG SMCHB CHARG MCHA Batches CHARG
SMCHB LGORT SMCHB WERKS T001L Storage Locations WERKS
SMCHB LGORT SMCHB LGORT T001L Storage Locations LGORT
SMCHB LGORT SYST MANDT T001L Storage Locations MANDT
SMCHB MATNR SYST MANDT MARA General Material Data MANDT
SMCHB MATNR SMCHB MATNR MARA General Material Data MATNR
SMCHB WERKS SYST MANDT T001W Plants/Branches MANDT
SMCHB WERKS SMCHB WERKS T001W Plants/Branches WERKS