1. Home
  2. Resources
  3. SAP Tables
  4. MSID - Vendor Stock with Vendor

SAP Table MSID

Vendor Stock with Vendor

MSID (Vendor Stock with Vendor) 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 MSID to other SAP tables.

MSID 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
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
OWNER Owner of stock OWNER_D LFA1 CHAR 10 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
IDSPR 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
IDLAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
IDINS Stock in Quality Inspection INSME QUAN 13 3
IDVLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
IDVIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
IDILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
IDILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
IDVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
IDVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
IDFLL Physical inventory indicator for stock in following year KZFLL CHAR 3 0
IDFLQ Physical inventory indicator, quality insp.stck, follow.yr. KZFLQ CHAR 3 0
IDDLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
IDEIN Total Stock of All Restricted Batches EINME QUAN 13 3
IDVEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
ERSDA Created On ERSDA DATS 8 0
IDJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
IDRUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No

MSID foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MSID CHARG MSID MATNR MCHA Batches MATNR
MSID CHARG MSID WERKS MCHA Batches WERKS
MSID CHARG MSID CHARG MCHA Batches CHARG
MSID CHARG MSID MANDT MCHA Batches MANDT
MSID LIFNR MSID MANDT LFA1 Vendor Master (General Section) MANDT
MSID LIFNR MSID LIFNR LFA1 Vendor Master (General Section) LIFNR
MSID MANDT MSID MANDT T000 Clients MANDT
MSID MATNR MSID MANDT MARA General Material Data MANDT
MSID MATNR MSID MATNR MARA General Material Data MATNR
MSID OWNER MSID MANDT LFA1 Vendor Master (General Section) MANDT
MSID OWNER MSID OWNER LFA1 Vendor Master (General Section) LIFNR
MSID SOBKZ MSID SOBKZ T148 Special Stock Indicator SOBKZ
MSID SOBKZ MSID MANDT T148 Special Stock Indicator MANDT
MSID WERKS MSID MANDT MARC Plant Data for Material MANDT
MSID WERKS MSID MATNR MARC Plant Data for Material MATNR
MSID WERKS MSID WERKS MARC Plant Data for Material WERKS