MLAUFCR

Transparent Table Application Table
14 Fields 1 CDS Views

Material Ledger Currency Table for Order History

MLAUFCR is an SAP database table in S/4HANA. Material Ledger Currency Table for Order History. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FMLV_MLAUFCR_UCT_UNION view union_all ML Currency Table for Order History w. cor. CURTP

Fields (14)

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
KEY curtp FINS_CURTYPE Curr./Val. Type
waers WAERS Currency
shkzg SHKZG Debit/Credit
wrbtr ACBTR_CS Amount
arewr AREWR GR/IR clr.value
reewr REEWR Invoice Value
sdm_version FINS_ML_SDM_VERSION SDM Versioning

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 Currency Table for Order History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLAUFCR (
    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]
    CURTP,        -- Curr./Val. Type [FINS_CURTYPE]
    WAERS,        -- Currency [WAERS]
    SHKZG,        -- Debit/Credit [SHKZG]
    WRBTR,        -- Amount [ACBTR_CS]
    AREWR,        -- GR/IR clr.value [AREWR]
    REEWR,        -- Invoice Value [REEWR]
    SDM_VERSION,  -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, MLVNR, VGABE, GJAHR, BELNR, BUZEI, KALNR, CURTP)
);

Learn More