MKOL

Special Stocks from Supplier | 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
SOBKZ FK Special Stock Indicator
LIFNR FK Account Number of Supplier
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
SLABS Unrestricted-Use Consignment Stock
SINSM Consignment Stock in Quality Inspection
SEINM Restricted-Use Consignment Stock
SSPEM Blocked Consignment Stock
SVMLA Unrestricted-use consignment stock, previous period
SVMIN Consignment stock in quality inspection, previous period
SVMEI Restricted-use consignment stock in the previous period
SVMSP Blocked consignment stock, previous period
MMENG Minimum order quantity
AMENG Replenishment quantity
FSH_SALLOC_QTY Allocated Stock Quantity
/CWM/SLABS Unrestricted-Use Consignment Stock
/CWM/SINSM Consignment Stock in Quality Inspection
/CWM/SEINM Restricted-Use Consignment Stock
/CWM/SSPEM Blocked Consignment Stock
/CWM/SVMLA Unrestricted-use consignment stock, previous period
/CWM/SVMIN Consignment stock in quality inspection, previous period
/CWM/SVMEI Restricted-use consignment stock in the previous period
/CWM/SVMSP Blocked consignment stock, previous period
Column Name Description
ERSDA Created On
LAEDA Date of Last Change
KODLL Date of Last Posted Count
Column Name Description
LVORM Deletion Flag for All Data on a Consignment Stock Show values
SPERS Physical Inventory Blocking Indicator Show values
KORUE MxxxH rec. already exists for per. before last of Mxxx 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
KZISL Physical inventory indicator for whse stock in current year INVKZ
KZISQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
KZISE Physical inventory indicator for restricted-use stock INVKZ
KZISS Physical inventory indicator for blocked stock INVKZ
KZVSL Physical inventory indicator for stock in previous year INVKZ
KZVSQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
KZVSE Physical inventory ind. for restricted-use stock, prev.pd INVKZ
KZVSS Phys. inventory indicator for blocked stock in prev. period INVKZ
KOJIN Fiscal year of current physical inventory indicator GJAHR
SGT_SCAT Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Material/plant/batch
  • Material Number
  • Batch Number
  • Plant
  • MKOL.MANDT == MCHA.MANDT
  • MKOL.MATNR == MCHA.MATNR
  • MKOL.CHARG == MCHA.CHARG
  • MKOL.WERKS == MCHA.WERKS
Storage location
  • Plant
  • Material Number
  • Storage location
  • MKOL.MANDT == MARD.MANDT
  • MKOL.WERKS == MARD.WERKS
  • MKOL.MATNR == MARD.MATNR
  • MKOL.LGORT == MARD.LGORT
Vendor
  • MKOL.MANDT == LFA1.MANDT
  • MKOL.LIFNR == LFA1.LIFNR
Client MKOL.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MKOL.MATNR == MARA.MATNR
  • MKOL.MANDT == MARA.MANDT
Special Stock Indicator
  • MKOL.MANDT == T148.MANDT
  • MKOL.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MKOL.MATNR == MARC.MATNR
  • MKOL.MANDT == MARC.MANDT
  • MKOL.WERKS == MARC.WERKS