P_CURMATLVALNPRICE_PR

DDL: P_CURMATLVALNPRICE_PR SQL: PCURMVPRICEPR Type: view BASIC Package: FINS_ML_PRODUCT_MASTER_API
12 Fields 1 Data Sources

Material Ledger Prices CKMLCR with Header Information

P_CURMATLVALNPRICE_PR is a Basic CDS View that provides data about "Material Ledger Prices CKMLCR with Header Information" in SAP S/4HANA. It reads from 1 data source (ckmlpr) and exposes 12 fields with key fields CostEstimate, CurrencyRole. Part of development package FINS_ML_PRODUCT_MASTER_API.

Data Sources (1)

SourceAliasJoin Type
ckmlpr pr from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCURMVPRICEPR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate ckmlpr kalnr ProdCostEst.No.
KEY CurrencyRole ckmlpr curtp Valuation Area
Ledger
FuturePrice ckmlpr zkprs Future Price
FuturePriceValidityStartDate ckmlpr zprsdat Fut. Price From
PlannedPrice
FutrCostEstValuationVariant ckmlpr bwva1 Valuation Var.
FutureCostEstFiscalYear ckmlpr pdatz Fut. FYyear
FutureCostEstimateFiscalPeriod ckmlpr pprdz Posting Period
FutureCostEstCostingVersion ckmlpr vers1 Late Completion
FutrPlanProjSlsOrdValnStrategy ckmlpr zbwst Fut. Valn Strat.
FixedPortionOfPlannedPrice

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CURMATLVALNPRICE_PR.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PCURMVPRICEPR

CREATE VIEW P_CURMATLVALNPRICE_PR AS
SELECT
  pr.kalnr AS CostEstimate,
  pr.curtp AS CurrencyRole,
  cast(' ' as rldnr) AS Ledger,
  pr.zkprs AS FuturePrice,
  pr.zprsdat AS FuturePriceValidityStartDate,
  cast(pr.zplpr as fml_plpr) AS PlannedPrice,
  pr.bwva1 AS FutrCostEstValuationVariant,
  pr.pdatz AS FutureCostEstFiscalYear,
  pr.pprdz AS FutureCostEstimateFiscalPeriod,
  pr.vers1 AS FutureCostEstCostingVersion,
  pr.zbwst AS FutrPlanProjSlsOrdValnStrategy,
  cast(pr.fplpx as fml_plpx) AS FixedPortionOfPlannedPrice
FROM ckmlpr AS pr
;

Learn More