MLAUF

Transparent Table Application Table
27 Fields 2 CDS Views

Material Ledger Item Table for Order History

MLAUF is an SAP database table in S/4HANA. Material Ledger Item Table for Order History. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMLV_MLAUFMFCR_UCT view from ML Item Table Inner Join ML Currency table for Order History
FMLV_MLAUFMFCR_UCT_UNION view from ML Item Table Inner Join ML Currency table for Order History

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mlvnr CK_MLVNR ML Transactn No
KEY vgabe CKI_VGAAU Transact. Type
KEY gjahr MJAHR Mat. Doc. Year
KEY belnr MBLNR Material Doc.
KEY buzei MBLPO Mat. Doc.Item
KEY kalnr CK_KALNR Cost EstimateNo
budat BUDAT Posting Date
menge MENGE_D Quantity
poper POPER Posting Period
bdatj BDATJ Year
hrkft HRKFT Origin Group
kstar KSTAR Cost Element
bwart BWART Movement Type
aufnr AUFNR Order
posnr CO_POSNR Item Number
settle_poper POPER Posting Period
saprl SYSAPRL SAP Release
cpudt CPUDT Entered On
cputm CPUTM Entered at
xwoff XWOFF Calcn of val.Open
werks WERKS_D Plant
storno XFELD Checkbox
meins MEINS Base Unit
bstmg BSTMG PO Quantity
bstme BSTME Order Unit
grir_active CK_MULTI Multiple Usage

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 Item Table for Order History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLAUF (
    MANDT,         -- Client [MANDT]
    MLVNR,         -- ML Transactn No [CK_MLVNR]
    VGABE,         -- Transact. Type [CKI_VGAAU]
    GJAHR,         -- Mat. Doc. Year [MJAHR]
    BELNR,         -- Material Doc. [MBLNR]
    BUZEI,         -- Mat. Doc.Item [MBLPO]
    KALNR,         -- Cost EstimateNo [CK_KALNR]
    BUDAT,         -- Posting Date [BUDAT]
    MENGE,         -- Quantity [MENGE_D]
    POPER,         -- Posting Period [POPER]
    BDATJ,         -- Year [BDATJ]
    HRKFT,         -- Origin Group [HRKFT]
    KSTAR,         -- Cost Element [KSTAR]
    BWART,         -- Movement Type [BWART]
    AUFNR,         -- Order [AUFNR]
    POSNR,         -- Item Number [CO_POSNR]
    SETTLE_POPER,  -- Posting Period [POPER]
    SAPRL,         -- SAP Release [SYSAPRL]
    CPUDT,         -- Entered On [CPUDT]
    CPUTM,         -- Entered at [CPUTM]
    XWOFF,         -- Calcn of val.Open [XWOFF]
    WERKS,         -- Plant [WERKS_D]
    STORNO,        -- Checkbox [XFELD]
    MEINS,         -- Base Unit [MEINS]
    BSTMG,         -- PO Quantity [BSTMG]
    BSTME,         -- Order Unit [BSTME]
    GRIR_ACTIVE,   -- Multiple Usage [CK_MULTI]
    PRIMARY KEY (MANDT, MLVNR, VGABE, GJAHR, BELNR, BUZEI, KALNR)
);

Learn More