MKOL

Transparent Table Application Table
38 Fields 1 CDS Views

Special Stocks from Supplier

MKOL is an SAP database table in S/4HANA. Special Stocks from Supplier. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
nsdm_e_mkol view from MKOL Compatibility View

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY lgort LGORT_D Location
KEY charg CHARG_D Batch
KEY sobkz SOBKZ Special Stock
KEY lifnr LIFNR Supplier
lvorm LVOKL Stock del. flag
ersda ERSDA Created On
ernam ERNAM Created By
aenam AENAM Changed By
laeda LAEDA Last Change
lfgja LFGJA Year Cur.Period
lfmon LFMON Current Period
spers SPERR Phys. Inv. Blk
slabs KLABS Unrestr. Consgt
sinsm KINSM Cnsgt in QInsp.
seinm KEINM Restr. Consgt
sspem KSPEM Blocked Consgt
svmla KVLAB Unrestr. cnsgt
svmin KVINS Cnsgt in QInsp
svmei KVEIN Restr. cnsgt
svmsp KVSPE Blocked cnsgt
kzisl KZILL Warehouse stock
kzisq KZILQ QualInspStock
kzise KZILE Restricted-use
kziss KZILS Blocked stock
kzvsl KZVLL Warehouse stock
kzvsq KZVLQ QualInspStock
kzvse KZVLE Restricted use
kzvss KZVLS Blocked stock
mmeng MMENG Minimum qty
ameng AMENG Replenishmt qty
kodll DLINL Last Count Date
kojin GJINV Fiscal year of current physical inventory indicator
korue SBRUE MxxxH rec. already exists for per. before last of Mxxx per.
sgt_scat SGT_SCAT Stock Segment
fsh_salloc_qty FSH_SALLOC_QTY Allocated Stock

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Special Stocks from Supplier
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MKOL (
    MANDT,           -- Client [MANDT]
    MATNR,           -- Material [MATNR]
    WERKS,           -- Plant [WERKS_D]
    LGORT,           -- Location [LGORT_D]
    CHARG,           -- Batch [CHARG_D]
    SOBKZ,           -- Special Stock [SOBKZ]
    LIFNR,           -- Supplier [LIFNR]
    LVORM,           -- Stock del. flag [LVOKL]
    ERSDA,           -- Created On [ERSDA]
    ERNAM,           -- Created By [ERNAM]
    AENAM,           -- Changed By [AENAM]
    LAEDA,           -- Last Change [LAEDA]
    LFGJA,           -- Year Cur.Period [LFGJA]
    LFMON,           -- Current Period [LFMON]
    SPERS,           -- Phys. Inv. Blk [SPERR]
    SLABS,           -- Unrestr. Consgt [KLABS]
    SINSM,           -- Cnsgt in QInsp. [KINSM]
    SEINM,           -- Restr. Consgt [KEINM]
    SSPEM,           -- Blocked Consgt [KSPEM]
    SVMLA,           -- Unrestr. cnsgt [KVLAB]
    SVMIN,           -- Cnsgt in QInsp [KVINS]
    SVMEI,           -- Restr. cnsgt [KVEIN]
    SVMSP,           -- Blocked cnsgt [KVSPE]
    KZISL,           -- Warehouse stock [KZILL]
    KZISQ,           -- QualInspStock [KZILQ]
    KZISE,           -- Restricted-use [KZILE]
    KZISS,           -- Blocked stock [KZILS]
    KZVSL,           -- Warehouse stock [KZVLL]
    KZVSQ,           -- QualInspStock [KZVLQ]
    KZVSE,           -- Restricted use [KZVLE]
    KZVSS,           -- Blocked stock [KZVLS]
    MMENG,           -- Minimum qty [MMENG]
    AMENG,           -- Replenishmt qty [AMENG]
    KODLL,           -- Last Count Date [DLINL]
    KOJIN,           -- Fiscal year of current physical inventory indicator [GJINV]
    KORUE,           -- MxxxH rec. already exists for per. before last of Mxxx per. [SBRUE]
    SGT_SCAT,        -- Stock Segment [SGT_SCAT]
    FSH_SALLOC_QTY,  -- Allocated Stock [FSH_SALLOC_QTY]
    PRIMARY KEY (MANDT, MATNR, WERKS, LGORT, CHARG, SOBKZ, LIFNR)
);

Learn More