MSKAO1
Special Stocks Appendix: Additional Quantities
MSKAO1 is an SAP database table in S/4HANA. Special Stocks Appendix: Additional Quantities. It contains 17 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| oib_e_mskao1 | view | from | MSKAO1 Compatibility View |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | matnr | MATNR | Material | |||
| KEY | werks | WERKS_D | Plant | |||
| KEY | lgort | LGORT_D | Location | |||
| KEY | charg | CHARG_D | Batch | |||
| KEY | sobkz | SOBKZ | Special Stock | |||
| KEY | vbeln | VBELN | SD Document | |||
| KEY | posnr | POSNR | Item | |||
| KEY | msehi | MSEHI | Internal UoM | |||
| kalab | LABST | Unrestricted | ||||
| kains | INSME | Quality Insp. | ||||
| kaspe | SPEME | Blocked Stock | ||||
| kavla | VMLAB | Unrestr.-use | ||||
| kavin | VMINS | In qual. insp. | ||||
| kavsp | VMSPE | Blocked | ||||
| kavei | VMEIN | Restr.-use PP | ||||
| kaein | EINME | Restricted-Use |
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 Appendix: Additional Quantities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSKAO1 (
MANDT, -- Client [MANDT]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
LGORT, -- Location [LGORT_D]
CHARG, -- Batch [CHARG_D]
SOBKZ, -- Special Stock [SOBKZ]
VBELN, -- SD Document [VBELN]
POSNR, -- Item [POSNR]
MSEHI, -- Internal UoM [MSEHI]
KALAB, -- Unrestricted [LABST]
KAINS, -- Quality Insp. [INSME]
KASPE, -- Blocked Stock [SPEME]
KAVLA, -- Unrestr.-use [VMLAB]
KAVIN, -- In qual. insp. [VMINS]
KAVSP, -- Blocked [VMSPE]
KAVEI, -- Restr.-use PP [VMEIN]
KAEIN, -- Restricted-Use [EINME]
PRIMARY KEY (MANDT, MATNR, WERKS, LGORT, CHARG, SOBKZ, VBELN, POSNR, 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