MLBECRH

Transparent Table Application Table
16 Fields 2 CDS Views

Material Ledger Currency Table for GR/IR relevant transact.

MLBECRH is an SAP database table in S/4HANA. Material Ledger Currency Table for GR/IR relevant transact.. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMLV_EKBEBZH_UCT_UNION view inner History per Purchasing Document w. External CURTP
FMLV_MLBECRH_UCT_UNION view union_all Material Ledger Currency Table for GR/IR relevant transactions w. correct CURTP

Fields (16)

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 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
kudif kudif Exch.Rate Diff.
wkurs wkurs Exchange Rate
_dataaging data_temperature Data Aging
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 GR/IR relevant transact.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLBECRH (
    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]
    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]
    KUDIF,        -- Exch.Rate Diff. [kudif]
    WKURS,        -- Exchange Rate [wkurs]
    _DATAAGING,   -- Data Aging [data_temperature]
    SDM_VERSION,  -- SDM Versioning [fins_ml_sdm_version]
    PRIMARY KEY (MANDT, MLVNR, VGABE, GJAHR, BELNR, BUZEI, CURTP)
);

Learn More