SAP table MSID (Vendor Stock with Vendor)

SAP table MSID has 7 primary key fields being MANDT,MATNR,WERKS,CHARG,SOBKZ,LIFNR,OWNER.

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

MSID foreign key relationships

Table Field Check Table Check Field
0 MSID CHARG MCHA Batches MANDT
0 MSID CHARG MCHA Batches WERKS
0 MSID CHARG MCHA Batches CHARG
1 MSID LIFNR LFA1 Supplier Master (General Section) MANDT
1 MSID LIFNR LFA1 Supplier Master (General Section) LIFNR
0 MSID MANDT T000 Clients MANDT
1 MSID MATNR MARA General Material Data MANDT
1 MSID MATNR MARA General Material Data MATNR
0 MSID OWNER LFA1 Supplier Master (General Section) MANDT
0 MSID OWNER LFA1 Supplier Master (General Section) LIFNR
1 MSID SOBKZ T148 Special Stock Indicator MANDT
1 MSID SOBKZ T148 Special Stock Indicator SOBKZ
0 MSID WERKS MARC Plant Data for Material MANDT
0 MSID WERKS MARC Plant Data for Material MATNR
0 MSID WERKS MARC Plant Data for Material WERKS