MSKAO1

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
oib_e_mskao1 view from MSKAO1 Compatibility View

Fields (17)

KeyField Data ElementDescription DomainTypeLength
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)
);