MSLB

Special Stocks with Supplier | view | #masterdata | Component: Basic Functions
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
LIFNR FK Account Number of Supplier
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
LBLAB Valuated Unrestricted-Use Stock
LBINS Stock in Quality Inspection
LBVLA Valuated unrestricted-use stock in previous period
LBVIN Stock in Quality Inspection in Previous Period
LBEIN Total Stock of All Restricted Batches
LBVEI Restricted-Use Stock in Previous Period
LBUML Stock in Transfer for Subcontracting (Plant to Plant)
/CWM/LBLAB Valuated, Unrestricted-Use Stock in Parallel Unit of Measure
/CWM/LBINS Inspection Stock in Parallel Unit of Measure
/CWM/LBEIN Total Stock of All Restricted Batches in Parallel UoM
/CWM/LBUML Stock in Transfer Subcontractor (Plant to Plant) in PUoM
/CWM/LBVLA Valuated unrestricted-use stock in previous period
/CWM/LBVIN Stock in Quality Inspection in Previous Period
/CWM/LBVEI Restricted-Use Stock in Previous Period
Column Name Description
LBDLL Date of Last Posted Count
ERSDA Created On
Column Name Description
LBSPR Physical Inventory Blocking Indicator Show values
LBRUE MxxxH rec. already exists for per. before last of Mxxx per. Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
LBILL Physical inventory indicator for whse stock in current year INVKZ
LBILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
LBVLL Physical inventory indicator for stock in previous year INVKZ
LBVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
LBFLL Physical inventory indicator for stock in following year INVKZ
LBFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
LBJIN Fiscal year of current physical inventory indicator GJAHR
SGT_SCAT Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Batch
  • Material Number
  • Batch Number
  • Plant
  • MSLB.MANDT == MCHA.MANDT
  • MSLB.MATNR == MCHA.MATNR
  • MSLB.CHARG == MCHA.CHARG
  • MSLB.WERKS == MCHA.WERKS
Vendor
  • MSLB.MANDT == LFA1.MANDT
  • MSLB.LIFNR == LFA1.LIFNR
Client MSLB.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MSLB.MATNR == MARA.MATNR
  • MSLB.MANDT == MARA.MANDT
Special Stock Indicator
  • MSLB.MANDT == T148.MANDT
  • MSLB.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MSLB.MATNR == MARC.MATNR
  • MSLB.MANDT == MARC.MANDT
  • MSLB.WERKS == MARC.WERKS