MSKU

Transparent Table Application Table
27 Fields 2 CDS Views

Special Stocks with Customer

MSKU is an SAP database table in S/4HANA. Special Stocks with Customer. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
nsdm_e_msku view from MSKU Compatibility View
P_Mtm_Batches_For_Locking view union BASIC

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY charg charg_d Batch
KEY sobkz sobkz Special Stock
KEY kunnr kunnr Customer
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
kuspr sperr Phys. Inv. Blk
kulab labst Unrestricted
kuins insme Quality Insp.
kuvla vmlab Unrestr.-use
kuvin vmins In qual. insp.
kuill kzill Warehouse stock
kuilq kzilq QualInspStock
kuvll kzvll Warehouse stock
kuvlq kzvlq QualInspStock
kufll kzfll Warehouse stock
kuflq kzflq QualInspStock
kudll dlinl Last Count Date
kuein einme Restricted-Use
kuvei vmein Restr.-use PP
ersda ersda Created On
kujin gjinv Fiscal year of current physical inventory indicator
kurue sbrue MxxxH rec. already exists for per. before last of Mxxx per.
kuuml umlme_w Stock in Trans.
sgt_scat sgt_scat Stock Segment

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 with Customer
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSKU (
    MANDT,     -- Client [mandt]
    MATNR,     -- Material [matnr]
    WERKS,     -- Plant [werks_d]
    CHARG,     -- Batch [charg_d]
    SOBKZ,     -- Special Stock [sobkz]
    KUNNR,     -- Customer [kunnr]
    LFGJA,     -- Year Cur.Period [lfgja]
    LFMON,     -- Current Period [lfmon]
    KUSPR,     -- Phys. Inv. Blk [sperr]
    KULAB,     -- Unrestricted [labst]
    KUINS,     -- Quality Insp. [insme]
    KUVLA,     -- Unrestr.-use [vmlab]
    KUVIN,     -- In qual. insp. [vmins]
    KUILL,     -- Warehouse stock [kzill]
    KUILQ,     -- QualInspStock [kzilq]
    KUVLL,     -- Warehouse stock [kzvll]
    KUVLQ,     -- QualInspStock [kzvlq]
    KUFLL,     -- Warehouse stock [kzfll]
    KUFLQ,     -- QualInspStock [kzflq]
    KUDLL,     -- Last Count Date [dlinl]
    KUEIN,     -- Restricted-Use [einme]
    KUVEI,     -- Restr.-use PP [vmein]
    ERSDA,     -- Created On [ersda]
    KUJIN,     -- Fiscal year of current physical inventory indicator [gjinv]
    KURUE,     -- MxxxH rec. already exists for per. before last of Mxxx per. [sbrue]
    KUUML,     -- Stock in Trans. [umlme_w]
    SGT_SCAT,  -- Stock Segment [sgt_scat]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, KUNNR)
);

Learn More