SAP table MSLB (Special Stocks with Supplier)

SAP table MSLB has 6 primary key fields being MANDT,MATNR,WERKS,CHARG,SOBKZ,LIFNR.

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

MSLB foreign key relationships

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