MLCRF

Transparent Table Application Table
11 Fields 2 CDS Views

Material Ledger Document: Field Groups (Currencies)

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMLV_MLCRF_UCT_UNION view union_all Material Ledger Document: Field Groups (Currencies) with correct CURTP
R_NonMigrtdMatlLdgrDocItmReval 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 curtp CURTP Crcy type/val.
KEY feldg CK_FELDG Field Group
prdif CK_PRDIF Price Diff.
krdif CK_KRDIF Exch.Rate Diff.
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 Document: Field Groups (Currencies)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLCRF (
    MANDT,        -- Client [MANDT]
    BELNR,        -- Document Number [CK_BELNR]
    KJAHR,        -- Document Year [CK_KJAHR]
    POSNR,        -- Item [CK_MLPOS]
    BDATJ,        -- Year [BDATJ]
    POPER,        -- Posting Period [POPER]
    CURTP,        -- Crcy type/val. [CURTP]
    FELDG,        -- Field Group [CK_FELDG]
    PRDIF,        -- Price Diff. [CK_PRDIF]
    KRDIF,        -- Exch.Rate Diff. [CK_KRDIF]
    SDM_VERSION,  -- SDM Versioning [FINS_ML_SDM_VERSION]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR, BDATJ, POPER, CURTP, FELDG)
);

Learn More