MLCRP

Transparent Table Application Table

Material-Ledger-Beleg: Preisänderung (Währungen, Preise)

MLCRP is an SAP database table in S/4HANA. Material-Ledger-Beleg: Preisänderung (Währungen, Preise). It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMLV_MLCRP_UCT_UNION view union_all Material Ledger Document: Price Changes (Currencies, Prices) with correct CURTP
R_NonMigrtdMatlLdgrDocItmPrice view from BASIC

Fields (18)

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.
pvprs_new ck_pvp_new Per. Unit Price
stprs_new ck_stp_new Standard Price
vprsv_new vprsv Price control
peinh_new ck_peinh_new New Price Unit
manpae_v ck_manpae Manual Pr. Chg.
salk3um ck_salum Adjustment
manpae_s ck_manpae Manual Pr. Chg.
salk3ums ck_salums Adjustment
erzkalk ck_erzkalk StdCostEst Prc.
zukbew ck_zukbew Future Val. Pr.
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-Beleg: Preisänderung (Währungen, Preise)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MLCRP (
    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]
    PVPRS_NEW,    -- Per. Unit Price [ck_pvp_new]
    STPRS_NEW,    -- Standard Price [ck_stp_new]
    VPRSV_NEW,    -- Price control [vprsv]
    PEINH_NEW,    -- New Price Unit [ck_peinh_new]
    MANPAE_V,     -- Manual Pr. Chg. [ck_manpae]
    SALK3UM,      -- Adjustment [ck_salum]
    MANPAE_S,     -- Manual Pr. Chg. [ck_manpae]
    SALK3UMS,     -- Adjustment [ck_salums]
    ERZKALK,      -- StdCostEst Prc. [ck_erzkalk]
    ZUKBEW,       -- Future Val. Pr. [ck_zukbew]
    SDM_VERSION,  -- SDM Versioning [fins_ml_sdm_version]
    PRIMARY KEY (MANDT, BELNR, KJAHR, POSNR, BDATJ, POPER, CURTP)
);