MLPP

Transparent Table Application Table
23 Fields 4 CDS Views

Material Ledger Document: Posting Periods and Quantities

MLPP is an SAP database table in S/4HANA. Material Ledger Document: Posting Periods and Quantities. It contains 23 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FMLV_MLXXV_UCT view inner FMLV_MLXXV_UCT
FMLV_MLXXV_UCT_UNION view inner ML Document: Items and posting periods w. correct CURTP
ML4H_CDS_MLIT_CL view inner Select all closing documents
P_MLDocumentQuantities view from BASIC

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY belnr CK_BELNR Document Number
KEY kjahr CK_KJAHR Document Year
KEY posnr CK_MLPOS Item
KEY bdatj BDATJ Year
KEY poper POPER Posting Period
budat BUDAT Posting Date
perart CK_PER_ART Period Type
lbkum CK_LBKUMD Quantity
lbkum_old CK_LBKUM Total Stock
untper CK_UNTPER Value Type
bklas BKLAS Valuation Class
xkonchk CK_XKONCHK Constncy Check
status CK_MLSTAT Status
modif CK_MODIF BOM Item Type
xvnb CKML_XVNB RoC Completed
xwip CKML_XWIP WIP Completed
xobjwip CKML_XOBJWIP WIP Calculated
xnopl CK_NO_PBPOPO No Stock Check
xmstuf CKML_XMSTUF ML Price Det. Compl.
xckmm CKML_XCKMM CKMM Completed
xclean CKML_XCLEAN Period Empty
xavrsim CKML_XAVRSIM AVRSIM Set

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.

-- Material Ledger Document: Posting Periods and Quantities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLPP (
    MANDT,      -- Client [MANDT]
    BELNR,      -- Document Number [CK_BELNR]
    KJAHR,      -- Document Year [CK_KJAHR]
    POSNR,      -- Item [CK_MLPOS]
    BDATJ,      -- Year [BDATJ]
    POPER,      -- Posting Period [POPER]
    BUDAT,      -- Posting Date [BUDAT]
    PERART,     -- Period Type [CK_PER_ART]
    LBKUM,      -- Quantity [CK_LBKUMD]
    LBKUM_OLD,  -- Total Stock [CK_LBKUM]
    UNTPER,     -- Value Type [CK_UNTPER]
    BKLAS,      -- Valuation Class [BKLAS]
    XKONCHK,    -- Constncy Check [CK_XKONCHK]
    STATUS,     -- Status [CK_MLSTAT]
    MODIF,      -- BOM Item Type [CK_MODIF]
    XVNB,       -- RoC Completed [CKML_XVNB]
    XWIP,       -- WIP Completed [CKML_XWIP]
    XOBJWIP,    -- WIP Calculated [CKML_XOBJWIP]
    XNOPL,      -- No Stock Check [CK_NO_PBPOPO]
    XMSTUF,     -- ML Price Det. Compl. [CKML_XMSTUF]
    XCKMM,      -- CKMM Completed [CKML_XCKMM]
    XCLEAN,     -- Period Empty [CKML_XCLEAN]
    XAVRSIM,    -- AVRSIM Set [CKML_XAVRSIM]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR, BDATJ, POPER)
);

Learn More