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