SAP table MSKA (Sales Order Stock)

SAP table MSKA has 8 primary key fields being MANDT,MATNR,WERKS,LGORT,CHARG,SOBKZ,VBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 MARC WERKS_D
LGORT Storage location CHAR 4 0 MARD LGORT_D
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFMON Current period (posting period) NUMC 2 0 LFMON
KASPR Physical Inventory Blocking Indicator CHAR 1 0 SPERR
No physical inventory defined for material
A Physical inventory not yet completed for material
X Due to phys. inv., material is blocked for movements
KALAB Valuated Unrestricted-Use Stock QUAN 13 3 LABST
KAINS Stock in Quality Inspection QUAN 13 3 INSME
KASPE Blocked Stock QUAN 13 3 SPEME
KAVLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
KAVIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
KAVSP Blocked stock of previous period QUAN 13 3 VMSPE
KAILL Physical inventory indicator for whse stock in current year CHAR 3 0 KZILL
KAILQ Phys. inventory ind. f. stock in qual. insp. in current year CHAR 3 0 KZILQ
KAILS Physical inventory indicator for blocked stock CHAR 3 0 KZILS
KAVLL Physical inventory indicator for stock in previous year CHAR 3 0 KZVLL
KAVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period CHAR 3 0 KZVLQ
KAVLS Phys. inventory indicator for blocked stock in prev. period CHAR 3 0 KZVLS
KAFLL Physical inventory indicator for stock in following year CHAR 3 0 KZFLL
KAFLQ Physical inventory indicator, quality insp.stck, follow.yr. CHAR 3 0 KZFLQ
KAFLS Phys. inventory ind. for blocked stock in following period CHAR 3 0 KZFLS
KADLL Date of Last Posted Count DATS 8 0 DLINL
KAEIN Total Stock of All Restricted Batches QUAN 13 3 EINME
KAVEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
ERSDA Created On DATS 8 0 ERSDA
KAJIN Fiscal year of current physical inventory indicator NUMC 4 0 GJINV
KARUE MxxxH rec. already exists for per. before last of Mxxx per. CHAR 1 0 SBRUE
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FSH_SALLOC_QTY Allocated Stock Quantity QUAN 13 3 FSH_SALLOC_QTY
/CWM/KALAB Valuated Unrestricted-Use Stock QUAN 13 3 LABST
/CWM/KAINS Stock in Quality Inspection QUAN 13 3 INSME
/CWM/KASPE Blocked Stock QUAN 13 3 SPEME
/CWM/KAEIN Total Stock of All Restricted Batches QUAN 13 3 EINME
/CWM/KAVLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
/CWM/KAVIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
/CWM/KAVSP Blocked stock of previous period QUAN 13 3 VMSPE
/CWM/KAVEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN

MSKA foreign key relationships

Table Field Check Table Check Field
0 MSKA CHARG MCHA Batches MANDT
0 MSKA CHARG MCHA Batches WERKS
0 MSKA CHARG MCHA Batches CHARG
1 MSKA LGORT MARD Storage Location Data for Material MANDT
1 MSKA LGORT MARD Storage Location Data for Material MATNR
1 MSKA LGORT MARD Storage Location Data for Material WERKS
1 MSKA LGORT MARD Storage Location Data for Material LGORT
0 MSKA MANDT T000 Clients MANDT
1 MSKA MATNR MARA General Material Data MANDT
1 MSKA MATNR MARA General Material Data MATNR
0 MSKA SOBKZ T148 Special Stock Indicator MANDT
0 MSKA SOBKZ T148 Special Stock Indicator SOBKZ
1 MSKA WERKS MARC Plant Data for Material MANDT
1 MSKA WERKS MARC Plant Data for Material MATNR
1 MSKA WERKS MARC Plant Data for Material WERKS