MSKA

Transparent Table Application Table
33 Fields 2 CDS Views

Sales Order Stock

MSKA is an SAP database table in S/4HANA. Sales Order Stock. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
nsdm_e_mska view from MSKA Compatibility View
P_Mtm_Batches_For_Locking view union BASIC

Fields (33)

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 vbeln vbeln SD Document
KEY posnr posnr Item
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
kaspr sperr Phys. Inv. Blk
kalab labst Unrestricted
kains insme Quality Insp.
kaspe speme Blocked Stock
kavla vmlab Unrestr.-use
kavin vmins In qual. insp.
kavsp vmspe Blocked
kaill kzill Warehouse stock
kailq kzilq QualInspStock
kails kzils Blocked stock
kavll kzvll Warehouse stock
kavlq kzvlq QualInspStock
kavls kzvls Blocked stock
kafll kzfll Warehouse stock
kaflq kzflq QualInspStock
kafls kzfls Blocked stock
kadll dlinl Last Count Date
kaein einme Restricted-Use
kavei vmein Restr.-use PP
ersda ersda Created On
kajin gjinv Fiscal year of current physical inventory indicator
karue sbrue MxxxH rec. already exists for per. before last of Mxxx per.
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.

-- Sales Order Stock
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSKA (
    MANDT,     -- Client [mandt]
    MATNR,     -- Material [matnr]
    WERKS,     -- Plant [werks_d]
    LGORT,     -- Location [lgort_d]
    CHARG,     -- Batch [charg_d]
    SOBKZ,     -- Special Stock [sobkz]
    VBELN,     -- SD Document [vbeln]
    POSNR,     -- Item [posnr]
    LFGJA,     -- Year Cur.Period [lfgja]
    LFMON,     -- Current Period [lfmon]
    KASPR,     -- Phys. Inv. Blk [sperr]
    KALAB,     -- Unrestricted [labst]
    KAINS,     -- Quality Insp. [insme]
    KASPE,     -- Blocked Stock [speme]
    KAVLA,     -- Unrestr.-use [vmlab]
    KAVIN,     -- In qual. insp. [vmins]
    KAVSP,     -- Blocked [vmspe]
    KAILL,     -- Warehouse stock [kzill]
    KAILQ,     -- QualInspStock [kzilq]
    KAILS,     -- Blocked stock [kzils]
    KAVLL,     -- Warehouse stock [kzvll]
    KAVLQ,     -- QualInspStock [kzvlq]
    KAVLS,     -- Blocked stock [kzvls]
    KAFLL,     -- Warehouse stock [kzfll]
    KAFLQ,     -- QualInspStock [kzflq]
    KAFLS,     -- Blocked stock [kzfls]
    KADLL,     -- Last Count Date [dlinl]
    KAEIN,     -- Restricted-Use [einme]
    KAVEI,     -- Restr.-use PP [vmein]
    ERSDA,     -- Created On [ersda]
    KAJIN,     -- Fiscal year of current physical inventory indicator [gjinv]
    KARUE,     -- MxxxH rec. already exists for per. before last of Mxxx per. [sbrue]
    SGT_SCAT,  -- Stock Segment [sgt_scat]
    PRIMARY KEY (MANDT, MATNR, WERKS, LGORT, CHARG, SOBKZ, VBELN, POSNR)
);

Learn More