MLBECRLDH

Transparent Table Application Table
17 Fields 3 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. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FMLV_EKBEBZH_UCT_UNION view left_outer History per Purchasing Document w. External CURTP
FMLV_MLBECRH_UCT view from Material Ledger Currency Table for GR/IR relevant trans w. correct CURTP
FMLV_MLBECRH_UCT_UNION view from Material Ledger Currency Table for GR/IR relevant transactions 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