MLAUFCRLD

Transparent Table Application Table
14 Fields 2 CDS Views

Mat. Led. Currency Table for Order History icnl. Ledger

MLAUFCRLD is an SAP database table in S/4HANA. Mat. Led. Currency Table for Order History icnl. Ledger. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMLV_MLAUFCR_UCT view from ML Currency Table for Order History w. cor. CURTP
FMLV_MLAUFCR_UCT_UNION view from 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 ext_curtype FINS_EXT_CURTYPE Crcy Type/Valn View
KEY rldnr FINS_LEDGER Ledger
waers WAERS Currency
shkzg SHKZG Debit/Credit
wrbtr ACBTR_CS Amount
arewr AREWR GR/IR clr.value
reewr REEWR Invoice Value

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.

-- Mat. Led. Currency Table for Order History icnl. Ledger
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLAUFCRLD (
    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]
    EXT_CURTYPE,  -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
    RLDNR,        -- Ledger [FINS_LEDGER]
    WAERS,        -- Currency [WAERS]
    SHKZG,        -- Debit/Credit [SHKZG]
    WRBTR,        -- Amount [ACBTR_CS]
    AREWR,        -- GR/IR clr.value [AREWR]
    REEWR,        -- Invoice Value [REEWR]
    PRIMARY KEY (MANDT, MLVNR, VGABE, GJAHR, BELNR, BUZEI, KALNR, EXT_CURTYPE, RLDNR)
);

Learn More