MSLBO1
Appendix for Special Stocks with Vendors: Add. Quantities
MSLBO1 is an SAP database table in S/4HANA. Appendix for Special Stocks with Vendors: Add. Quantities. It contains 13 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| oib_e_mslbo1 | view | from | MSLBO1 Compatibility View |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | |||
| KEY | msehi | MSEHI | Internal UoM | |||
| lblab | LABST | Unrestricted | ||||
| lbins | INSME | Quality Insp. | ||||
| lbvla | VMLAB | Unrestr.-use | ||||
| lbvin | VMINS | In qual. insp. | ||||
| lbein | EINME | Restricted-Use | ||||
| lbvei | VMEIN | Restr.-use PP |
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.
-- Appendix for Special Stocks with Vendors: Add. Quantities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSLBO1 (
MANDT, -- Client [MANDT]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
CHARG, -- Batch [CHARG_D]
SOBKZ, -- Special Stock [SOBKZ]
LIFNR, -- Supplier [LIFNR]
MSEHI, -- Internal UoM [MSEHI]
LBLAB, -- Unrestricted [LABST]
LBINS, -- Quality Insp. [INSME]
LBVLA, -- Unrestr.-use [VMLAB]
LBVIN, -- In qual. insp. [VMINS]
LBEIN, -- Restricted-Use [EINME]
LBVEI, -- Restr.-use PP [VMEIN]
PRIMARY KEY (MANDT, MATNR, WERKS, CHARG, SOBKZ, LIFNR, MSEHI)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA