SAP table MSKU (Special Stocks with Customer)

SAP table MSKU has 6 primary key fields being MANDT,MATNR,WERKS,CHARG,SOBKZ,KUNNR.

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
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFMON Current period (posting period) NUMC 2 0 LFMON
KUSPR 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
KULAB Valuated Unrestricted-Use Stock QUAN 13 3 LABST
KUINS Stock in Quality Inspection QUAN 13 3 INSME
KUVLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
KUVIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
KUILL Physical inventory indicator for whse stock in current year CHAR 3 0 KZILL
KUILQ Phys. inventory ind. f. stock in qual. insp. in current year CHAR 3 0 KZILQ
KUVLL Physical inventory indicator for stock in previous year CHAR 3 0 KZVLL
KUVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period CHAR 3 0 KZVLQ
KUFLL Physical inventory indicator for stock in following year CHAR 3 0 KZFLL
KUFLQ Physical inventory indicator, quality insp.stck, follow.yr. CHAR 3 0 KZFLQ
KUDLL Date of Last Posted Count DATS 8 0 DLINL
KUEIN Total Stock of All Restricted Batches QUAN 13 3 EINME
KUVEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN
ERSDA Created On DATS 8 0 ERSDA
KUJIN Fiscal year of current physical inventory indicator NUMC 4 0 GJINV
KURUE MxxxH rec. already exists for per. before last of Mxxx per. CHAR 1 0 SBRUE
KUUML Stock in Transfer for Customer Consignment (Plant to Plant) QUAN 13 3 UMLME_W
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/KULAB Valuated Unrestricted-Use Stock QUAN 13 3 LABST
/CWM/KUINS Stock in Quality Inspection QUAN 13 3 INSME
/CWM/KUEIN Total Stock of All Restricted Batches QUAN 13 3 EINME
/CWM/KUUML Stock in Transfer Cust. Consignment (Plant to Plant) in PUoM QUAN 13 3 /CWM/UMLME_W
/CWM/KUVLA Valuated unrestricted-use stock in previous period QUAN 13 3 VMLAB
/CWM/KUVIN Stock in Quality Inspection in Previous Period QUAN 13 3 VMINS
/CWM/KUVEI Restricted-Use Stock in Previous Period QUAN 13 3 VMEIN

MSKU foreign key relationships

Table Field Check Table Check Field
0 MSKU CHARG MCHA Batches MANDT
0 MSKU CHARG MCHA Batches WERKS
0 MSKU CHARG MCHA Batches CHARG
1 MSKU KUNNR KNA1 General Data in Customer Master MANDT
1 MSKU KUNNR KNA1 General Data in Customer Master KUNNR
0 MSKU MANDT T000 Clients MANDT
1 MSKU MATNR MARA General Material Data MANDT
1 MSKU MATNR MARA General Material Data MATNR
0 MSKU SOBKZ T148 Special Stock Indicator MANDT
0 MSKU SOBKZ T148 Special Stock Indicator SOBKZ
1 MSKU WERKS MARC Plant Data for Material MANDT
1 MSKU WERKS MARC Plant Data for Material MATNR
1 MSKU WERKS MARC Plant Data for Material WERKS