MLPP

Transparent Table Application Table
15 Fields 4 CDS Views

Material-Ledger-Beleg: Buchungsperioden und Mengen

MLPP is an SAP database table in S/4HANA. Material-Ledger-Beleg: Buchungsperioden und Mengen. It contains 15 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 (15)

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

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-Beleg: Buchungsperioden und Mengen
-- 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]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR, BDATJ, POPER)
);

Learn More