Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_ProdValnMatlLdgrFutrPrcWD

DDL: I_PRODVALNMATLLDGRFUTRPRCWD SQL: IPRODVALNFUTRWD Type: view TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Product BO Valuation Material Ledger Future Prices (Draft)

I_ProdValnMatlLdgrFutrPrcWD is a Transactional CDS View that provides data about "Product BO Valuation Material Ledger Future Prices (Draft)" in SAP S/4HANA. It reads from 1 data source (ckmlpr) and exposes 16 fields with key fields ProdCostEstNumber, CurrencyRoleName, Product, ValuationArea, ValuationType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ckmlpr ckmlpr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProductValuationWD _ValuationArea $projection.ProdCostEstNumber = _ValuationArea.ProdCostEstNumber and $projection.Product = _ValuationArea.Product

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPRODVALNFUTRWD view
EndUserText.label Product BO Valuation Material Ledger Future Prices (Draft) view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PROD_VALN_FUT view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProdCostEstNumber ckmlpr kalnr ProdCostEst.No.
KEY CurrencyRoleName ckmlpr curtp Valuation Area
KEY Product Valuation matnr Vehicle Model
KEY ValuationArea Valuation bwkey Valuation Area
KEY ValuationType Valuation bwtar Valuation Type
ValuationClass Valuation bklas Valuation Class
FuturePrice ckmlpr zkprs Future Price
PlannedPriceInCoCodeCrcy ckmlpr zplpr Fut. Plnd Price
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.
FxdPortnOfFutPlPrcInCoCodeCrcy ckmlpr fplpx Fut. PlanPrice, Fxd
FuturePriceValidityStartDate ckmlpr zprsdat Fut. Price From
_ValuationArea _ValuationArea

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 I_ProdValnMatlLdgrFutrPrcWD.
-- 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: IPRODVALNFUTRWD

CREATE VIEW I_ProdValnMatlLdgrFutrPrcWD AS
SELECT
  ckmlpr.kalnr AS ProdCostEstNumber,
  ckmlpr.curtp AS CurrencyRoleName,
  Valuation.matnr AS Product,
  Valuation.bwkey AS ValuationArea,
  Valuation.bwtar AS ValuationType,
  Valuation.bklas AS ValuationClass,
  ckmlpr.zkprs AS FuturePrice,
  ckmlpr.zplpr AS PlannedPriceInCoCodeCrcy,
  ckmlpr.bwva1 AS FutrCostEstValuationVariant,
  ckmlpr.pdatz AS FutureCostEstFiscalYear,
  ckmlpr.pprdz AS FutureCostEstimateFiscalPeriod,
  ckmlpr.vers1 AS FutureCostEstCostingVersion,
  ckmlpr.zbwst AS FutrPlanProjSlsOrdValnStrategy,
  ckmlpr.fplpx AS FxdPortnOfFutPlPrcInCoCodeCrcy,
  ckmlpr.zprsdat AS FuturePriceValidityStartDate
FROM ckmlpr
LEFT OUTER JOIN I_ProductValuationWD AS _ValuationArea ON ProdCostEstNumber = _ValuationArea.ProdCostEstNumber AND Product = _ValuationArea.Product  -- association [1..1]
;

Learn More