1. Home
  2. Resources
  3. SAP Tables
  4. MSLB - Special Stocks with Vendor

SAP Table MSLB

Special Stocks with Vendor

MSLB (Special Stocks 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 MSLB to other SAP tables.

MSLB 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
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
LBSPR 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
LBLAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
LBINS Stock in Quality Inspection INSME QUAN 13 3
LBVLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
LBVIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
LBILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
LBILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
LBVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
LBVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
LBFLL Physical inventory indicator for stock in following year KZFLL CHAR 3 0
LBFLQ Physical inventory indicator, quality insp.stck, follow.yr. KZFLQ CHAR 3 0
LBDLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
LBEIN Total Stock of All Restricted Batches EINME QUAN 13 3
LBVEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
ERSDA Created On ERSDA DATS 8 0
LBJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
LBRUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No
LBUML Stock in Transfer for Subcontracting (Plant to Plant) UMLME_O QUAN 13 3

MSLB foreign key relationships

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