MLBECRLDH

Transparent Table Application Table
17 Fields 1 CDS Views

Mat. Led. Cur Table for GR/IR rel. transact. icnl. Ledger

MLBECRLDH is an SAP database table in S/4HANA. Mat. Led. Cur Table for GR/IR rel. transact. icnl. Ledger. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FMLV_MLBECRH_UCT view from Material Ledger Currency Table for GR/IR relevant trans w. correct CURTP

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mlvnr ck_mlvnr ML Transactn No
KEY vgabe cki_vgabe Transact. Type
KEY gjahr mjahr Mat. Doc. Year
KEY belnr mblnr Material Doc.
KEY buzei mblpo Mat. Doc.Item
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
kudif kudif Exch.Rate Diff.
wkurs wkurs Exchange Rate
bukrs fml_mlbecrld_bukrs Obsolete Field
_dataaging data_temperature Data Aging

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. Cur Table for GR/IR rel. transact. icnl. Ledger
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLBECRLDH (
    MANDT,        -- Client [mandt]
    MLVNR,        -- ML Transactn No [ck_mlvnr]
    VGABE,        -- Transact. Type [cki_vgabe]
    GJAHR,        -- Mat. Doc. Year [mjahr]
    BELNR,        -- Material Doc. [mblnr]
    BUZEI,        -- Mat. Doc.Item [mblpo]
    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]
    KUDIF,        -- Exch.Rate Diff. [kudif]
    WKURS,        -- Exchange Rate [wkurs]
    BUKRS,        -- Obsolete Field [fml_mlbecrld_bukrs]
    _DATAAGING,   -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, MLVNR, VGABE, GJAHR, BELNR, BUZEI, EXT_CURTYPE, RLDNR)
);

Learn More