MLCRLD

Transparent Table Application Table
23 Fields 5 CDS Views

Material Ledger Document: Currency per Ledger and Values

MLCRLD is an SAP database table in S/4HANA. Material Ledger Document: Currency per Ledger and Values. It contains 23 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FMLV_MLCR_UCT view from Material Ledger Document:Currencies and Values w. cor. CURTP
FMLV_MLCR_UCT_UNION view from Material Ledger Document: Currencies and Values w. correct CURTP
FMLV_MLXXV_UCT view from FMLV_MLXXV_UCT
FMLV_MLXXV_UCT_UNION view from ML Document: Items and posting periods w. correct CURTP
R_MigrtdMatlLdgrDocItemValue view from BASIC

Fields (23)

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
waers WAERS Currency
salk3 CK_SALK3D Amount
salk3_old CK_SALK3_1 Inventory Value
salkv CK_SALKVD Amount (Info.)
salkv_old CK_SALKV_1 Val./Per.Unit Prc
peinh CK_PEINH_1 Price Unit
pvprs_old CK_PVP_OLD Per. Unit Price
stprs_old CK_STP_OLD Standard Price
vprsv_old VPRSV Price control
bnbtr BNBTR Delivery costs
exbwr EXBWR Ext. Amount LC
vkwrt VKWRT SalVal inc. VAT
vkwra VKWRA SalVal w/o VAT
exvkw EXVKW Sales Value
vksal_old VKSAL Total SP value

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: Currency per Ledger and Values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLCRLD (
    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]
    WAERS,        -- Currency [WAERS]
    SALK3,        -- Amount [CK_SALK3D]
    SALK3_OLD,    -- Inventory Value [CK_SALK3_1]
    SALKV,        -- Amount (Info.) [CK_SALKVD]
    SALKV_OLD,    -- Val./Per.Unit Prc [CK_SALKV_1]
    PEINH,        -- Price Unit [CK_PEINH_1]
    PVPRS_OLD,    -- Per. Unit Price [CK_PVP_OLD]
    STPRS_OLD,    -- Standard Price [CK_STP_OLD]
    VPRSV_OLD,    -- Price control [VPRSV]
    BNBTR,        -- Delivery costs [BNBTR]
    EXBWR,        -- Ext. Amount LC [EXBWR]
    VKWRT,        -- SalVal inc. VAT [VKWRT]
    VKWRA,        -- SalVal w/o VAT [VKWRA]
    EXVKW,        -- Sales Value [EXVKW]
    VKSAL_OLD,    -- Total SP value [VKSAL]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR, BDATJ, POPER, RLDNR, EXT_CURTYPE)
);

Learn More