1. Home
  2. Resources
  3. SAP Tables
  4. MKOL - Special Stocks from Vendor

SAP Table MKOL

Special Stocks from Vendor

MKOL (Special Stocks from Vendor) 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 MKOL to other SAP tables.

MKOL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D MARD CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
LVORM Deletion Flag for All Data on a Consignment Stock LVOKL CHAR 1 0
X Yes
NULL No
ERSDA Created On ERSDA DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
SPERS Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
SLABS Unrestricted-Use Consignment Stock KLABS QUAN 13 3
SINSM Consignment Stock in Quality Inspection KINSM QUAN 13 3
SEINM Restricted-Use Consignment Stock KEINM QUAN 13 3
SSPEM Blocked Consignment Stock KSPEM QUAN 13 3
SVMLA Unrestricted-use consignment stock, previous period KVLAB QUAN 13 3
SVMIN Consignment stock in quality inspection, previous period KVINS QUAN 13 3
SVMEI Restricted-use consignment stock in the previous period KVEIN QUAN 13 3
SVMSP Blocked consignment stock, previous period KVSPE QUAN 13 3
KZISL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZISQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZISE Physical inventory indicator for restricted-use stock KZILE CHAR 3 0
KZISS Physical inventory indicator for blocked stock KZILS CHAR 3 0
KZVSL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
KZVSQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
KZVSE Physical inventory ind. for restricted-use stock, prev.pd KZVLE CHAR 3 0
KZVSS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
MMENG Minimum order quantity MMENG QUAN 13 3
AMENG Replenishment quantity AMENG QUAN 13 3
KODLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
KOJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
KORUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No

MKOL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MKOL CHARG MKOL MANDT MCHA Batches MANDT
MKOL CHARG MKOL MATNR MCHA Batches MATNR
MKOL CHARG MKOL WERKS MCHA Batches WERKS
MKOL CHARG MKOL CHARG MCHA Batches CHARG
MKOL LGORT MKOL LGORT MARD Storage Location Data for Material LGORT
MKOL LGORT MKOL MANDT MARD Storage Location Data for Material MANDT
MKOL LGORT MKOL MATNR MARD Storage Location Data for Material MATNR
MKOL LGORT MKOL WERKS MARD Storage Location Data for Material WERKS
MKOL LIFNR MKOL MANDT LFA1 Vendor Master (General Section) MANDT
MKOL LIFNR MKOL LIFNR LFA1 Vendor Master (General Section) LIFNR
MKOL MANDT MKOL MANDT T000 Clients MANDT
MKOL MATNR MKOL MANDT MARA General Material Data MANDT
MKOL MATNR MKOL MATNR MARA General Material Data MATNR
MKOL SOBKZ MKOL MANDT T148 Special Stock Indicator MANDT
MKOL SOBKZ MKOL SOBKZ T148 Special Stock Indicator SOBKZ
MKOL WERKS MKOL MANDT MARC Plant Data for Material MANDT
MKOL WERKS MKOL MATNR MARC Plant Data for Material MATNR
MKOL WERKS MKOL WERKS MARC Plant Data for Material WERKS