MLCRP
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FMLV_MLCRP_UCT_UNION | view | union_all | Material Ledger Document: Price Changes (Currencies, Prices) with correct CURTP | |
| R_NonMigrtdMatlLdgrDocItmPrice | view | from | BASIC |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA