MCHB

Batch Stocks | view | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
CHARG FK Batch Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
CLABS Valuated Unrestricted-Use Stock
CUMLM Stock in transfer (from one storage location to another)
CINSM Stock in Quality Inspection
CEINM Total Stock of All Restricted Batches
CSPEM Blocked Stock
CRETM Blocked Stock Returns
CVMLA Valuated unrestricted-use stock in previous period
CVMUM Stock in Transfer in Previous Period
CVMIN Stock in Quality Inspection in Previous Period
CVMEI Restricted-Use Stock in Previous Period
CVMSP Blocked stock of previous period
CVMRE Blocked Stock Returns in Previous Period
FSH_SALLOC_QTY Allocated Stock Quantity
/CWM/CLABS Valuated Unrestricted-Use Stock
/CWM/CINSM Stock in Quality Inspection
/CWM/CEINM Total Stock of All Restricted Batches
/CWM/CSPEM Blocked Stock
/CWM/CRETM Blocked Stock Returns
/CWM/CUMLM Stock in transfer (from one storage location to another)
/CWM/CVMLA Valuated unrestricted-use stock in previous period
/CWM/CVMIN Stock in Quality Inspection in Previous Period
/CWM/CVMEI Restricted-Use Stock in Previous Period
/CWM/CVMSP Blocked stock of previous period
/CWM/CVMRE Blocked Stock Returns in Previous Period
/CWM/CVMUM Stock in Transfer in Previous Period
Column Name Description
ERSDA Created On
LAEDA Date of Last Change
CHDLL Date of Last Posted Count
Column Name Description
LVORM Deletion Flag for All Data on a Batch Stock Show values
SPERC Physical Inventory Blocking Indicator Show values
CHRUE MCHBH rec. already exists for per. before last of MCHB per. Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
KZICL Physical inventory indicator for whse stock in current year INVKZ
KZICQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
KZICE Physical inventory indicator for restricted-use stock INVKZ
KZICS Physical inventory indicator for blocked stock INVKZ
KZVCL Physical inventory indicator for stock in previous year INVKZ
KZVCQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
KZVCE Physical inventory ind. for restricted-use stock, prev.pd INVKZ
KZVCS Phys. inventory indicator for blocked stock in prev. period INVKZ
CHJIN Fiscal year of current physical inventory indicator GJAHR
SGT_SCAT Stock Segment SGT_SRCA
FSH_SEASON_YEAR Season Year FSH_CJAHR
FSH_SEASON Season RFM_SAISO
FSH_COLLECTION Fashion Collection FSH_COLLECTION
FSH_THEME Fashion Theme FSH_THEME
Master Data Relations Join Conditions
Material/plant/batch
  • Material Number
  • Batch Number
  • Plant
  • MCHB.MANDT == MCHA.MANDT
  • MCHB.MATNR == MCHA.MATNR
  • MCHB.CHARG == MCHA.CHARG
  • MCHB.WERKS == MCHA.WERKS
Country of origin
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • MCHB.HERKL == T005.LAND1
  • MCHB.MANDT == T005.MANDT
Material/plant/storage location
  • Plant
  • Material Number
  • Storage location
  • MCHB.MANDT == MARD.MANDT
  • MCHB.WERKS == MARD.WERKS
  • MCHB.MATNR == MARD.MATNR
  • MCHB.LGORT == MARD.LGORT
Client MCHB.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MCHB.MATNR == MARA.MATNR
  • MCHB.MANDT == MARA.MANDT
Material/plant
  • Material Number
  • Client
  • Plant
  • MCHB.MATNR == MARC.MATNR
  • MCHB.MANDT == MARC.MANDT
  • MCHB.WERKS == MARC.WERKS