1. Home
  2. Resources
  3. SAP Tables
  4. MSKU - Special Stocks with Customer

SAP Table MSKU

Special Stocks with Customer

MSKU (Special Stocks with Customer) 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 MSKU to other SAP tables.

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

MSKU foreign key relationships

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