MLCRFLD

Transparent Table Application Table
11 Fields 3 CDS Views

Material Ledger Doc.: Field Groups (Currencies per Ledger)

MLCRFLD is an SAP database table in S/4HANA. Material Ledger Doc.: Field Groups (Currencies per Ledger). It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FMLV_MLCRF_UCT view from ML Document:Field Groups (Currencies) with correct CURTP
FMLV_MLCRF_UCT_UNION view from Material Ledger Document: Field Groups (Currencies) with correct CURTP
R_MigrtdMatlLdgrDocItmReval view from BASIC

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY belnr CK_BELNR Document Number
KEY kjahr CK_KJAHR Document Year
KEY posnr CK_MLPOS Item
KEY bdatj BDATJ Year
KEY poper POPER Posting Period
KEY rldnr FINS_LEDGER Ledger
KEY ext_curtype FINS_EXT_CURTYPE Crcy Type/Valn View
KEY feldg CK_FELDG Field Group
prdif CK_PRDIF Price Diff.
krdif CK_KRDIF Exch.Rate Diff.

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 Doc.: Field Groups (Currencies per Ledger)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLCRFLD (
    MANDT,        -- Client [MANDT]
    BELNR,        -- Document Number [CK_BELNR]
    KJAHR,        -- Document Year [CK_KJAHR]
    POSNR,        -- Item [CK_MLPOS]
    BDATJ,        -- Year [BDATJ]
    POPER,        -- Posting Period [POPER]
    RLDNR,        -- Ledger [FINS_LEDGER]
    EXT_CURTYPE,  -- Crcy Type/Valn View [FINS_EXT_CURTYPE]
    FELDG,        -- Field Group [CK_FELDG]
    PRDIF,        -- Price Diff. [CK_PRDIF]
    KRDIF,        -- Exch.Rate Diff. [CK_KRDIF]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR, BDATJ, POPER, RLDNR, EXT_CURTYPE, FELDG)
);

Learn More