MSLB

Transparent Table Application Table
27 Fields 2 CDS Views

Special Stocks with Supplier

MSLB is an SAP database table in S/4HANA. Special Stocks with Supplier. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
nsdm_e_mslb view from MSLB Compatibility View
P_Mtm_Batches_For_Locking view union BASIC List of Batches to lock for stock MTM per material / plant

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY charg charg_d Batch
KEY sobkz sobkz Special Stock
KEY lifnr lifnr Supplier
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
lbspr sperr Phys. Inv. Blk
lblab labst Unrestricted
lbins insme Quality Insp.
lbvla vmlab Unrestr.-use
lbvin vmins In qual. insp.
lbill kzill Warehouse stock
lbilq kzilq QualInspStock
lbvll kzvll Warehouse stock
lbvlq kzvlq QualInspStock
lbfll kzfll Warehouse stock
lbflq kzflq QualInspStock
lbdll dlinl Last Count Date
lbein einme Restricted-Use
lbvei vmein Restr.-use PP
ersda ersda Created On
lbjin gjinv Fiscal year of current physical inventory indicator
lbrue sbrue MxxxH rec. already exists for per. before last of Mxxx per.
lbuml umlme_o SC In Transf.
sgt_scat sgt_scat Stock Segment

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Special Stocks with Supplier
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSLB (
    MANDT,     -- Client [mandt]
    MATNR,     -- Material [matnr]
    WERKS,     -- Plant [werks_d]
    CHARG,     -- Batch [charg_d]
    SOBKZ,     -- Special Stock [sobkz]
    LIFNR,     -- Supplier [lifnr]
    LFGJA,     -- Year Cur.Period [lfgja]
    LFMON,     -- Current Period [lfmon]
    LBSPR,     -- Phys. Inv. Blk [sperr]
    LBLAB,     -- Unrestricted [labst]
    LBINS,     -- Quality Insp. [insme]
    LBVLA,     -- Unrestr.-use [vmlab]
    LBVIN,     -- In qual. insp. [vmins]
    LBILL,     -- Warehouse stock [kzill]
    LBILQ,     -- QualInspStock [kzilq]
    LBVLL,     -- Warehouse stock [kzvll]
    LBVLQ,     -- QualInspStock [kzvlq]
    LBFLL,     -- Warehouse stock [kzfll]
    LBFLQ,     -- QualInspStock [kzflq]
    LBDLL,     -- Last Count Date [dlinl]
    LBEIN,     -- Restricted-Use [einme]
    LBVEI,     -- Restr.-use PP [vmein]
    ERSDA,     -- Created On [ersda]
    LBJIN,     -- Fiscal year of current physical inventory indicator [gjinv]
    LBRUE,     -- MxxxH rec. already exists for per. before last of Mxxx per. [sbrue]
    LBUML,     -- SC In Transf. [umlme_o]
    SGT_SCAT,  -- Stock Segment [sgt_scat]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, LIFNR)
);

Learn More