SAP table SMCHB (Lock Table MCHB)

SAP table SMCHB has 4 primary key fields being MATNR,WERKS,LGORT,CHARG.

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
RMCHB Return code for Table MCHB CHAR 1 0 RMCHB
XDBUP Database update CHAR 1 0 XDBUP
CLABS Valuated Unrestricted-Use Stock QUAN 13 3 LABST
CUMLM Stock in transfer (plant to plant) QUAN 13 3 UMLME
CINSM Stock in Quality Inspection QUAN 13 3 INSME
CEINM Total Stock of All Restricted Batches QUAN 13 3 EINME
CSPEM Blocked Stock QUAN 13 3 SPEME
CRETM Blocked Stock Returns QUAN 13 3 RETME
CVMLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
CVMUM Stock in Transfer in Previous Period QUAN 13 3 VMUML
CVMIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
CVMEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
CVMSP Blocked stock of previous period QUAN 13 3 VMSPE
CVMRE Blocked Stock Returns in Previous Period QUAN 13 3 VMRET
CLABS_OLD Valuated Unrestricted-Use Stock QUAN 13 3 LABST
CUMLM_OLD Stock in transfer (plant to plant) QUAN 13 3 UMLME
CINSM_OLD Stock in Quality Inspection QUAN 13 3 INSME
CEINM_OLD Total Stock of All Restricted Batches QUAN 13 3 EINME
CSPEM_OLD Blocked Stock QUAN 13 3 SPEME
CRETM_OLD Blocked Stock Returns QUAN 13 3 RETME
CVMLA_OLD Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
CVMUM_OLD Stock in Transfer in Previous Period QUAN 13 3 VMUML
CVMIN_OLD Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
CVMEI_OLD Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
CVMSP_OLD Blocked stock of previous period QUAN 13 3 VMSPE
CVMRE_OLD Blocked Stock Returns in Previous Period QUAN 13 3 VMRET
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFMON Current period (posting period) NUMC 2 0 LFMON
LVORM Deletion Indicator CHAR 1 0 LVORM
RMCHBH Indicator: MCHBH for previous period could not be read CHAR 1 0 RMCHBH
CHLFM Period of MCHB NUMC 2 0 CHLFM
CHGJA Fiscal year of MCHB NUMC 4 0 CHGJA
CHRUE MCHBH rec. already exists for per. before last of MCHB per. CHAR 1 0 CHRUE
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
/CWM/CLABS Valuated Unrestricted-Use Stock QUAN 13 3 LABST
/CWM/CINSM Stock in Quality Inspection QUAN 13 3 INSME
/CWM/CEINM Total Stock of All Restricted Batches QUAN 13 3 EINME
/CWM/CSPEM Blocked Stock QUAN 13 3 SPEME
/CWM/CRETM Blocked Stock Returns QUAN 13 3 RETME
/CWM/CUMLM Stock in transfer (from one storage location to another) QUAN 13 3 UMLMD
/CWM/CVMLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
/CWM/CVMIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
/CWM/CVMEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
/CWM/CVMSP Blocked stock of previous period QUAN 13 3 VMSPE
/CWM/CVMRE Blocked Stock Returns in Previous Period QUAN 13 3 VMRET
/CWM/CVMUM Stock in Transfer in Previous Period QUAN 13 3 VMUML
/CWM/CLABS_OLD Valuated Unrestricted-Use Stock QUAN 13 3 LABST
/CWM/CINSM_OLD Stock in Quality Inspection QUAN 13 3 INSME
/CWM/CEINM_OLD Total Stock of All Restricted Batches QUAN 13 3 EINME
/CWM/CSPEM_OLD Blocked Stock QUAN 13 3 SPEME
/CWM/CRETM_OLD Blocked Stock Returns QUAN 13 3 RETME
/CWM/CUMLM_OLD Stock in transfer (from one storage location to another) QUAN 13 3 UMLMD
/CWM/CVMLA_OLD Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
/CWM/CVMIN_OLD Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
/CWM/CVMEI_OLD Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
/CWM/CVMSP_OLD Blocked stock of previous period QUAN 13 3 VMSPE
/CWM/CVMRE_OLD Blocked Stock Returns in Previous Period QUAN 13 3 VMRET
/CWM/CVMUM_OLD Stock in Transfer in Previous Period QUAN 13 3 VMUML
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FSH_SALLOC_QTY Allocated Stock Quantity QUAN 13 3 FSH_SALLOC_QTY
FSH_SALLOC_QTY_OLD Allocated Stock Quantity QUAN 13 3 FSH_SALLOC_QTY

SMCHB foreign key relationships

Table Field Check Table Check Field
0 SMCHB CHARG MCHA Batches MANDT
0 SMCHB CHARG MCHA Batches WERKS
0 SMCHB CHARG MCHA Batches CHARG
1 SMCHB LGORT T001L Storage Locations MANDT
1 SMCHB LGORT T001L Storage Locations WERKS
0 SMCHB MATNR MARA General Material Data MANDT
0 SMCHB MATNR MARA General Material Data MATNR
1 SMCHB WERKS T001W Plants/Branches MANDT
1 SMCHB WERKS T001W Plants/Branches WERKS