1. Home
  2. Resources
  3. SAP Tables
  4. MSKA - Sales Order Stock

SAP Table MSKA

Sales Order Stock

MSKA (Sales Order Stock) 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 MSKA to other SAP tables.

MSKA 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
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
KASPR 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
KALAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
KAINS Stock in Quality Inspection INSME QUAN 13 3
KASPE Blocked Stock SPEME QUAN 13 3
KAVLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
KAVIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
KAVSP Blocked stock of previous period VMSPE QUAN 13 3
KAILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KAILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KAILS Physical inventory indicator for blocked stock KZILS CHAR 3 0
KAVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
KAVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
KAVLS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
KAFLL Physical inventory indicator for stock in following year KZFLL CHAR 3 0
KAFLQ Physical inventory indicator, quality insp.stck, follow.yr. KZFLQ CHAR 3 0
KAFLS Phys. inventory ind. for blocked stock in following period KZFLS CHAR 3 0
KADLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
KAEIN Total Stock of All Restricted Batches EINME QUAN 13 3
KAVEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
ERSDA Created On ERSDA DATS 8 0
KAJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
KARUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No

MSKA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MSKA CHARG MSKA WERKS MCHA Batches WERKS
MSKA CHARG MSKA CHARG MCHA Batches CHARG
MSKA CHARG MSKA MANDT MCHA Batches MANDT
MSKA CHARG MSKA MATNR MCHA Batches MATNR
MSKA LGORT MSKA MATNR MARD Storage Location Data for Material MATNR
MSKA LGORT MSKA WERKS MARD Storage Location Data for Material WERKS
MSKA LGORT MSKA LGORT MARD Storage Location Data for Material LGORT
MSKA LGORT MSKA MANDT MARD Storage Location Data for Material MANDT
MSKA MANDT MSKA MANDT T000 Clients MANDT
MSKA MATNR MSKA MANDT MARA General Material Data MANDT
MSKA MATNR MSKA MATNR MARA General Material Data MATNR
MSKA POSNR MSKA MANDT VBUP Sales Document: Item Status MANDT
MSKA POSNR MSKA VBELN VBUP Sales Document: Item Status VBELN
MSKA POSNR MSKA POSNR VBUP Sales Document: Item Status POSNR
MSKA SOBKZ MSKA MANDT T148 Special Stock Indicator MANDT
MSKA SOBKZ MSKA SOBKZ T148 Special Stock Indicator SOBKZ
MSKA VBELN MSKA MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MSKA VBELN MSKA VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
MSKA WERKS MSKA MANDT MARC Plant Data for Material MANDT
MSKA WERKS MSKA MATNR MARC Plant Data for Material MATNR
MSKA WERKS MSKA WERKS MARC Plant Data for Material WERKS